ADSM-L

Error restore controlfile

2004-02-16 20:25:09
Subject: Error restore controlfile
From: nghiatd <nghiatd2 AT FPT.COM DOT VN>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 17 Feb 2004 08:32:34 +0700
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?
 

<Prev in Thread] Current Thread [Next in Thread>