Ctl file recovery, recover/restore DB, RMAN , Oracle 8.1.7.4
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Ctl file recovery, recover/restore DB, RMAN , Oracle 8.1.7.4

  1. #1
    Join Date
    Sep 2006
    Posts
    12

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    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?

  3. #3
    Join Date
    Sep 2006
    Posts
    12
    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

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    need to post the steps from start to finish incuding the database restore

  5. #5
    Join Date
    Sep 2006
    Posts
    12
    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

  6. #6
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    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

  7. #7
    Join Date
    Sep 2006
    Posts
    12
    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
  •  



Click Here to Expand Forum to Full Width