Ctl file recovery, recover/restore DB, RMAN , Oracle 8.1.7.4
Hello All
I am tryin to test a recovery scenario.
---(1)---GOOD
RMAN> alter database mount;
RMAN-03022: compiling command: alter db
RMAN-06199: database mounted
---(2)---GOOD
RMAN> run {
2> allocate channel c1 type disk;
3> restore controlfile to '/opt/home/oracle/xxx/cf1.ctl';
4> shutdown immediate;
5> }
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=13 devtype=DISK
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel c1: starting datafile backupset restore
RMAN-08502: set_count=51 set_stamp=603464443 creation_time=10-OCT-06
RMAN-08021: channel c1: restoring controlfile
RMAN-08505: output filename=/opt/home/oracle/xxx/cf1.ctl
RMAN-08023: channel c1: restored backup piece 1
RMAN-08511: piece handle=/backup/prod/backup/full/ctl/cf_PROD_603464443_1jhvg8nr.f tag=MY_CF params=NULL
RMAN-08024: channel c1: restore complete
RMAN-03022: compiling command: shutdown
RMAN-06404: database dismounted
RMAN-06402: Oracle instance shut down
---(3)---GOOD
RMAN> startup nomount;
---(4)---GOOD
RMAN> run {
2> replicate controlfile from '/opt/home/oracle/xxx/cf1.ctl';
3> }
RMAN-03022: compiling command: replicate
RMAN-03023: executing command: replicate
RMAN-08058: replicating controlfile
RMAN-08506: input filename=/opt/home/oracle/chandu/cf1.ctl
RMAN-08505: output filename=/u02/oradata/prod/ctrl/control01.ctl
RMAN-08505: output filename=/u03/oradata/prod/ctrl/control02.ctl
---(5)----
RMAN> startup force mount;--GOOD
---(6)---
RMAN> alter database open;--NOT GOOD
RMAN-03022: compiling command: alter db
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: alter db
RMAN-06003: ORACLE error from target database: ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
RMAN-06097: text of failing SQL statement: alter database open
RMAN-06099: error occurred in source file: krmk.pc, line: 22286
---(7)---NOT GOOD TOO TO RECVOVER
I logged in dba
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 962525655 generated at 10/10/2006 13:00:40 needed for thread
1
ORA-00289: suggestion : /arclogs/1_5.arc
ORA-00280: change 962525655 for thread 1 is in sequence #5
Specify log: {=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00308: cannot open archived log '/arclogs/1_5.arc'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u02/oradata/prod/data/system01.dbf'
_____________________________
___
(a)I have a q, what are the steps should be taken to restore the DB.
as i have to recover/restore the DB using the new ctl(restore ctl file)
(b) I found out that to restore ctl file the Db should be mounted. What if i lost the ctl file, I cannot restore the ctl file?. during my back procedure i do the following
backup
current controlfile
tag = my_cf
format '/backup/prod/backup/full/ctl/cf_%d_%t_%u.f';
(C) CAN YOU EXPLAIN WHAT I DID WRONG IN THE ABOVE STEPS 1-7
Thx
In adv
C