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

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

Threaded View

  1. #1
    Join Date
    Sep 2006

    Ctl file recovery, recover/restore DB, RMAN , Oracle

    Hello All
    I am tryin to test a recovery scenario.
    RMAN> alter database mount;

    RMAN-03022: compiling command: alter db
    RMAN-06199: database mounted
    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

    RMAN> startup nomount;
    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
    RMAN> startup force mount;--GOOD
    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
    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
    ORA-00289: suggestion : /arclogs/1_5.arc
    ORA-00280: change 962525655 for thread 1 is in sequence #5

    Specify log: {=suggested | filename | AUTO | CANCEL}
    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
    current controlfile
    tag = my_cf
    format '/backup/prod/backup/full/ctl/cf_%d_%t_%u.f';

    In adv
    Last edited by greenchille; 10-10-2006 at 04:55 PM. Reason: Version

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