RMAN und Backups des Controlfile Autor: Marco
Werbung
SOUG : Backup Controlfile und RMAN
!
#
"
(
)
Page 1 of 5
$%&
'
*
!
%"
#
#$
"' (
"
&
)
"
"
*
"
"
"
"
"
"
'
(
!
+
"
""
(
+
!, ALTER DATABASE BACKUP CONTROLFILE TO '/u00/app/oracle/admin/T816A/backup/ctrl.bck';
).
(
"
"
#
/
(
0
!
*
"
).
'
Recovery Manager: Release 8.1.6.0.0 - Production
RMAN-06005: connected to target database: T816A (DBID=3488375461)
RMAN-06008: connected to recovery catalog database
RMAN> run {
2>
allocate channel ch1 type disk;
3>
backup
4>
(current controlfile format '$ORACLE_BASE/admin/T816A/backup/ctrl_s%s_p%p');
5>
release channel ch1;
6>
}
RMAN-03022:
RMAN-03023:
RMAN-08030:
RMAN-08500:
compiling command: allocate
executing command: allocate
allocated channel: ch1
channel ch1: sid=12 devtype=DISK
RMAN-03022:
RMAN-03025:
RMAN-03023:
RMAN-08003:
RMAN-08005:
RMAN-03023:
RMAN-08008:
RMAN-08502:
RMAN-08010:
RMAN-08011:
RMAN-08013:
RMAN-08503:
RMAN-08525:
RMAN-03023:
RMAN-08003:
RMAN-08005:
compiling command: backup
performing implicit partial resync of recovery catalog
executing command: partial resync
starting partial resync of recovery catalog
partial resync complete
executing command: backup
channel ch1: starting full datafile backupset
set_count=5 set_stamp=396753258 creation_time=05-MAY-00
channel ch1: specifying datafile(s) in backupset
including current controlfile in backupset
channel ch1: piece 1 created
piece handle=/u00/app/oracle/admin/T816A/backup/ctrl_s5_p1 comment=NONE
backup set complete, elapsed time: 00:00:04
executing command: partial resync
starting partial resync of recovery catalog
partial resync complete
http://www.trivadis.com/Images/Bckctrl_rman_tcm16-7059.htm
15.09.2004
SOUG : Backup Controlfile und RMAN
Page 2 of 5
RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: ch1
RMAN>
&
(
1
+
2
3
0
5
*
).
5
"
+ "
'+
"
"
). *
)
(
+
4
'+
*
"
5
).
4
"
"
" 5
6
Recovery Manager: Release 8.1.6.0.0 - Production
RMAN-06005: connected to target database: T816A (DBID=3488375461)
RMAN-06008: connected to recovery catalog database
RMAN> list backupset of controlfile;
RMAN-03022: compiling command: list
List of
Key
------25
Backup Sets
Recid
Stamp
LV Set Stamp Set Count Completion Time
---------- ---------- -- ---------- ---------- ---------------------2
396753260 0 396753258 5
05-MAY-00
List of
Key
------26
00
Backup Pieces
Pc# Cp# Status
Completion Time
Piece Name
--- --- ----------- ---------------------- -----------------------1
1
AVAILABLE
05-MAY/u00/app/oracle/admin/T816A/backup/ctrl_s5_p1
Controlfile Included
Ckp SCN
Ckp time
---------- --------------33168
05-MAY-00
RMAN> list copy of controlfile;
RMAN-03022: compiling command: list
List of
Key
------23
00
Controlfile Copies
S Completion time Ckp SCN
Ckp time
Name
- --------------- ---------- --------------- -----A 05-MAY-00
33151
01-MAY/u00/app/oracle/admin/T816A/backup/ctrl.bck
RMAN>
(
+
+
!
7
"'
*
"'
* +
!
+
).
*
"4
"
'
).
"' +
http://www.trivadis.com/Images/Bckctrl_rman_tcm16-7059.htm
15.09.2004
SOUG : Backup Controlfile und RMAN
8
!
5
1./ 1- -
Page 3 of 5
"
"'
5) -/ ( ) /) ) !
). +
*
) $3 %
+(
Recovery Manager: Release 8.1.6.0.0 - Production
RMAN-06006: connected to target database: T816A (not mounted)
RMAN-06008: connected to recovery catalog database
RMAN> run {
2>
allocate channel ch1 type disk;
3>
restore controlfile;
4>
sql "alter database mount";
5>
set until logseq=120 thread=1;
6>
restore database;
7>
recover database;
8>
release channel ch1;
9> }
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: ch1
RMAN-08500: channel ch1: sid=10 devtype=DISK
RMAN-03022: compiling command: restore
RMAN-03022:
RMAN-03023:
RMAN-08021:
RMAN-08505:
RMAN-08025:
RMAN-08506:
RMAN-08501:
RMAN-08058:
RMAN-08506:
RMAN-08505:
RMAN-08505:
compiling command: IRESTORE
executing command: IRESTORE
channel ch1: restoring controlfile
output filename=/u01/oradata/T816A/ctl1T816A.dbf
channel ch1: copied controlfile copy
input filename=/u00/app/oracle/admin/T816A/backup/ctrl.bck
output filename=/u01/oradata/T816A/ctl1T816A.dbf recid=0 stamp=0
replicating controlfile
input filename=/u01/oradata/T816A/ctl1T816A.dbf
output filename=/u02/oradata/T816A/ctl2T816A.dbf
output filename=/u03/oradata/T816A/ctl3T816A.dbf
RMAN-03022: compiling command: sql
RMAN-06162: sql statement: alter database mount
RMAN-03023: executing command: sql
....
....
8
*
+
"
+
"' +
"
*
91
(
!
"
4
(
*
(
+
+
9
(
+
#
)
).
+
"
+
!
5
$
+
+ 5
*
6
change controlfilecopy '/u00/app/oracle/admin//T816A/backup/ctrl.bck' unavailable;
:
).
0
*
"
"
http://www.trivadis.com/Images/Bckctrl_rman_tcm16-7059.htm
15.09.2004
SOUG : Backup Controlfile und RMAN
Page 4 of 5
restore ( controlfile ) from backupset;
+ ,
-$
;
!
+
*<
!
+ (
+
+
).
"
"
4
!
"
*
1+
0*
ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/u00/app/oracle/admin/tmp/standby.ctl';
1
2#=+
). (
"
(
+
+
"'
!
).
+ (
+
% +
*
(
+
4
"'
+
+
Recovery Manager: Release 8.1.5.0.0 - Production
RMAN-06006: connected to target database: T815A (not mounted)
RMAN-06008: connected to recovery catalog database
RMAN> run {
3>
allocate channel ch1 type disk;
4>
restore controlfile;
5>
sql "alter database mount";
6>
restore database;
7>
recover database;
8>
release channel ch1;
9> }
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: ch1
RMAN-08500: channel ch1: sid=10 devtype=DISK
RMAN-03022: compiling command: restore
RMAN-03022:
RMAN-03023:
RMAN-08021:
RMAN-08505:
RMAN-08025:
RMAN-08506:
RMAN-08501:
RMAN-08058:
RMAN-08506:
RMAN-08505:
RMAN-08505:
compiling command: IRESTORE
executing command: IRESTORE
channel ch1: restoring controlfile
output filename=/u01/oradata/T815A/ctl1T815A.dbf
channel ch1: copied controlfile copy
input filename=/u00/app/oracle/admin/tmp/standby.ctl
output filename=/u01/oradata/T815A/ctl1T815A.dbf recid=0 stamp=0
replicating controlfile
input filename=/u01/oradata/T815A/ctl1T815A.dbf
output filename=/u02/oradata/T815A/ctl2T815A.dbf
output filename=/u03/oradata/T815A/ctl3T815A.dbf
RMAN-03022:
RMAN-06162:
RMAN-03023:
RMAN-03026:
RMAN-08031:
RMAN-00571:
RMAN-00569:
RMAN-00571:
RMAN-03006:
RMAN-07004:
RMAN-20000:
RMAN-11003:
RMAN-11001:
compiling command: sql
sql statement: alter database mount
executing command: sql
error recovery releasing channel resources
released channel: ch1
===========================================================
=============== ERROR MESSAGE STACK FOLLOWS ===============
===========================================================
non-retryable error occurred during execution of command: sql
unhandled exception during command execution on channel default
abnormal termination of job step
failure during parse/execution of SQL statement: alter database mount
Oracle Error: ORA-01666: controlfile is for a standby database
RMAN>
http://www.trivadis.com/Images/Bckctrl_rman_tcm16-7059.htm
15.09.2004
SOUG : Backup Controlfile und RMAN
)+ 1
(
+
2#>
% +
Page 5 of 5
"0
"
"
"'
"
).
!
+
. /
*
).
4
)+
1
"
+
&
*
+
*
"
+
).
!
4
'+
/
).
"
$
*
+
!
)?
%
%
'
#=@
A 7BC>B
/ 6
D E# B# @:2 C@ >C
06 D E# B# @:2 C@ >E
http://www.trivadis.com/Images/Bckctrl_rman_tcm16-7059.htm
15.09.2004