Error restore controlfile
2004-02-16 20:25:09
Hi all,
I got a error when I restore coltrolfile:
RMAN> run {
2> allocate channel ch1 type disk;
3> restore controlfile;
4> }
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: ch1
RMAN-08500: channel ch1: sid=15 devtype=DISK
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel ch1: starting datafile backupset restore
RMAN-08502: set_count=113 set_stamp=518277743 creation_time=16-FEB-04
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03007: retryable error occurred during execution of command: IRESTORE
RMAN-07004: unhandled exception during command execution on channel ch1
RMAN-10035: exception raised in RPC: ORA-19607: C:\ORACLE\ORADATA\TEST\CONTROL01
.CTL is an active controlfile
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.RESTORECONTROL
FILETO
When I restore the control file to a new location, replicates it to all control
file location. The progress is successful.Then mounts the control file in order
to restore the database. I got a error message :
RMAN> run {
2> allocate channel ch1 type disk;
3> replicate controlfile from 'c:/oracle/oradata/test/cf2.ctl';
4> alter database mount;
5> restore database;
6> recover database;
7> alter database open resetlogs;
8> }
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: ch1
RMAN-08500: channel ch1: sid=15 devtype=DISK
RMAN-03022: compiling command: replicate
RMAN-03023: executing command: replicate
RMAN-08058: replicating controlfile
RMAN-08506: input filename=C:\ORACLE\ORADATA\TEST\CF2.CTL
RMAN-08505: output filename=C:\ORACLE\ORADATA\TEST\CONTROL01.CTL
RMAN-08505: output filename=C:\ORACLE\ORADATA\TEST\CONTROL02.CTL
RMAN-08505: output filename=C:\ORACLE\ORADATA\TEST\CONTROL03.CTL
RMAN-03022: compiling command: alter db
RMAN-06199: database mounted
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel ch1: starting datafile backupset restore
RMAN-08502: set_count=107 set_stamp=518290874 creation_time=16-FEB-04
RMAN-08089: channel ch1: specifying datafile(s) to restore from backup set
RMAN-08523: restoring datafile 00001 to C:\ORACLE\ORADATA\TEST\SYSTEM01.DBF
RMAN-08523: restoring datafile 00002 to C:\ORACLE\ORADATA\TEST\RBS01.DBF
RMAN-08523: restoring datafile 00003 to C:\ORACLE\ORADATA\TEST\USERS01.DBF
RMAN-08523: restoring datafile 00004 to C:\ORACLE\ORADATA\TEST\TEMP01.DBF
RMAN-08523: restoring datafile 00005 to C:\ORACLE\ORADATA\TEST\TOOLS01.DBF
RMAN-08523: restoring datafile 00006 to C:\ORACLE\ORADATA\TEST\INDX01.DBF
RMAN-08523: restoring datafile 00007 to C:\ORACLE\ORADATA\TEST\DR01.DBF
RMAN-08523: restoring datafile 00008 to C:\ORACLE\ORADATA\TEST\RCVCAT01.DBF
RMAN-08523: restoring datafile 00009 to C:\ORACLE\ORADATA\TEST\OEM_REPOSITORY.O
A
RMAN-08023: channel ch1: restored backup piece 1
RMAN-08511: piece handle=C:\ORACLE\ORA81\DATABASE\3BFE8VDQ_1_1 tag=null params=
ULL
RMAN-08024: channel ch1: restore complete
RMAN-03022: compiling command: recover
RMAN-03022: compiling command: recover(1)
RMAN-03022: compiling command: recover(2)
RMAN-03022: compiling command: recover(3)
RMAN-03023: executing command: recover(3)
RMAN-08054: starting media recovery
RMAN-03022: compiling command: recover(4)
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: recover
RMAN-03002: failure during compilation of command
RMAN-03013: command type: recover(4)
RMAN-06054: media recovery requesting unknown log: thread 1 scn 327992
What can I do to fix this?
|
|
|