-
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
Last edited by greenchille; 10-10-2006 at 04:55 PM.
Reason: Version
-
ther is no restoring a database in there - is that intentional?
you restored an old controlfile and did nothing else, so it was out of sync with all the datafiles
why did you do that?
-
Hello Dave,
I want to test a recovery scenario. Can I recover the DB...
I Tried to restore the DB Later.. which it completed.
Now I cannot open the DB.
Did that answer your Q?.
Thx
C
-
need to post the steps from start to finish incuding the database restore
-
Hello Dave,
(1) I removed my old backup files... all of them.
(2) did a fresh rman back up
(3) tried to restore the ctl file from above (worked, steps in detail in my first list of questions
(4)since it didn't worked abt the 'ORA-01110: data file 1: '/u02/oradata/prod/data/system01.dbf'
I tried to restore the DB.
To post all the text it will be hude file
Can I post here?
Thx
C
-
how huge is it? (in Mb) ....attached it as file by clicking manage attachment
Behind The Success And Failure Of A Man Is A Woman
-
Hello
Sorry i am totally confused how to test the recovery process..
Btw, I distroyed the database and imported the data as fresh..
I will post as more in detail..
Thx
C
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|