Rman recovery from standby backup to Primary
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Rman recovery from standby backup to Primary

  1. #1
    Join Date
    Dec 2001
    Location
    Edmonton, Canada
    Posts
    50

    Rman recovery from standby backup to Primary

    Hi,

    I have configured data gaurd for 9i database on Windows. I am backing up standby database and trying to perfom recovery on primary for a lost datafile.
    I am getting error controlfile is older thatn datafile.
    Please let me know if I am missing any step in the following procedure.

    Backup at Standby site.

    Recovery Manager: Release 9.2.0.1.0 - Production

    Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

    Windows 2000 Version 5.1 Service Pack 2, CPU type 586
    Starting with debugging turned off

    connected to target database: ORCL9I (DBID=1992448566)
    connected to recovery catalog database

    RMAN>

    Starting backup at 24-AUG-06
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: sid=24 devtype=DISK
    channel ORA_DISK_1: starting archive log backupset
    channel ORA_DISK_1: specifying archive log(s) in backup set
    input archive log thread=1 sequence=49 recid=92 stamp=599052711
    input archive log thread=1 sequence=50 recid=95 stamp=599053337
    input archive log thread=1 sequence=51 recid=94 stamp=599053335
    input archive log thread=1 sequence=52 recid=96 stamp=599053612
    input archive log thread=1 sequence=53 recid=97 stamp=599053613
    input archive log thread=1 sequence=54 recid=98 stamp=599053761
    input archive log thread=1 sequence=55 recid=99 stamp=599058611
    input archive log thread=1 sequence=56 recid=100 stamp=599058991
    input archive log thread=1 sequence=62 recid=111 stamp=599132172
    input archive log thread=1 sequence=63 recid=113 stamp=599132272
    input archive log thread=1 sequence=64 recid=114 stamp=599132274
    input archive log thread=1 sequence=65 recid=115 stamp=599148947
    input archive log thread=1 sequence=66 recid=116 stamp=599149049
    input archive log thread=1 sequence=67 recid=118 stamp=599218560
    input archive log thread=1 sequence=68 recid=119 stamp=599218560
    input archive log thread=1 sequence=69 recid=120 stamp=599218561
    input archive log thread=1 sequence=70 recid=117 stamp=599218556
    input archive log thread=1 sequence=71 recid=121 stamp=599219279
    input archive log thread=1 sequence=72 recid=122 stamp=599219299
    input archive log thread=1 sequence=73 recid=123 stamp=599224912
    input archive log thread=1 sequence=74 recid=124 stamp=599224929
    input archive log thread=1 sequence=75 recid=125 stamp=599227360
    input archive log thread=1 sequence=76 recid=126 stamp=599227370
    input archive log thread=1 sequence=77 recid=127 stamp=599235260
    input archive log thread=1 sequence=78 recid=128 stamp=599235273
    input archive log thread=1 sequence=79 recid=129 stamp=599239124
    input archive log thread=1 sequence=80 recid=130 stamp=599239173
    input archive log thread=1 sequence=81 recid=131 stamp=599239300
    input archive log thread=1 sequence=82 recid=132 stamp=599240284
    input archive log thread=1 sequence=83 recid=133 stamp=599240383
    input archive log thread=1 sequence=84 recid=134 stamp=599240662
    input archive log thread=1 sequence=85 recid=135 stamp=599240750
    input archive log thread=1 sequence=86 recid=138 stamp=599301847
    input archive log thread=1 sequence=87 recid=137 stamp=599301846
    input archive log thread=1 sequence=88 recid=136 stamp=599301837
    input archive log thread=1 sequence=89 recid=139 stamp=599301871
    input archive log thread=1 sequence=90 recid=140 stamp=599302195
    channel ORA_DISK_1: starting piece 1 at 24-AUG-06
    channel ORA_DISK_1: finished piece 1 at 24-AUG-06
    piece handle=C:\ORACLE\BACKUP\ORCL9I\DF_ORCL9I_20060824_S15_P1 comment=NONE
    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:18
    Finished backup at 24-AUG-06

    Starting backup at 24-AUG-06
    using channel ORA_DISK_1
    channel ORA_DISK_1: starting full datafile backupset
    channel ORA_DISK_1: specifying datafile(s) in backupset
    input datafile fno=00001 name=C:\ORACLE\ORADATA\ORCL9I\SYSTEM01.DBF
    input datafile fno=00002 name=C:\ORACLE\ORADATA\ORCL9I\UNDOTBS01.DBF
    input datafile fno=00004 name=C:\ORACLE\ORADATA\ORCL9I\EXAMPLE01.DBF
    input datafile fno=00010 name=C:\ORACLE\ORADATA\ORCL9I\TEST1.DBF
    input datafile fno=00009 name=C:\ORACLE\ORADATA\ORCL9I\XDB01.DBF
    input datafile fno=00005 name=C:\ORACLE\ORADATA\ORCL9I\INDX01.DBF
    input datafile fno=00008 name=C:\ORACLE\ORADATA\ORCL9I\USERS01.DBF
    input datafile fno=00003 name=C:\ORACLE\ORADATA\ORCL9I\DRSYS01.DBF
    input datafile fno=00006 name=C:\ORACLE\ORADATA\ORCL9I\ODM01.DBF
    input datafile fno=00007 name=C:\ORACLE\ORADATA\ORCL9I\TOOLS01.DBF
    channel ORA_DISK_1: starting piece 1 at 24-AUG-06
    channel ORA_DISK_1: finished piece 1 at 24-AUG-06
    piece handle=C:\ORACLE\BACKUP\ORCL9I\DF_ORCL9I_20060824_S16_P1 comment=NONE
    channel ORA_DISK_1: backup set complete, elapsed time: 00:01:36
    Finished backup at 24-AUG-06

    Starting backup at 24-AUG-06
    using channel ORA_DISK_1
    specification does not match any archive log in the recovery catalog
    Finished backup at 24-AUG-06

    RMAN-06497: WARNING: controlfile is not current, controlfile autobackup skipped

    RMAN>

    Recovery Manager complete.

    **************************
    Recovering datafile at Primary level. I took datafile offline and did the following steps from rman.


    Recovery Manager: Release 9.2.0.1.0 - Production

    Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

    Windows 2000 Version 5.1 Service Pack 2, CPU type 586
    Starting with debugging turned off

    connected to target database: ORCL9I (DBID=1992448566)
    connected to recovery catalog database



    RMAN> restore datafile 9;
    Starting restore at 24-AUG-06

    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: sid=21 devtype=DISK
    channel ORA_DISK_1: starting datafile backupset restore
    channel ORA_DISK_1: specifying datafile(s) to restore from backup set
    restoring datafile 00009 to C:\ORACLE\ORADATA\ORCL9I\XDB01.DBF
    channel ORA_DISK_1: restored backup piece 1
    piece handle=C:\ORACLE\BACKUP\ORCL9I\DF_ORCL9I_20060824_S16_P1 tag=TAG20060824T090824 params=NULL
    channel ORA_DISK_1: restore complete
    Finished restore at 24-AUG-06


    RMAN> recover datafile 9;
    Starting recover at 24-AUG-06
    using channel ORA_DISK_1
    could not read file header for datafile 9 error reason 15
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of recover command at 08/24/2006 09:35:30
    RMAN-06094: datafile 9 must be restored


    RMAN> exit


    Recovery Manager complete.
    An elephant is a mouse with an operating system.

  2. #2
    Join Date
    Nov 2001
    Posts
    335
    Rename or delete datafile that you are trying to restore.
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  3. #3
    Join Date
    Dec 2001
    Location
    Edmonton, Canada
    Posts
    50
    Quote Originally Posted by BV1963
    Rename or delete datafile that you are trying to restore.
    I deleted and renamed the datafile but it does not work.
    An elephant is a mouse with an operating system.

  4. #4
    Join Date
    Nov 2001
    Posts
    335
    Can you check before the recover command that file is actually restored?
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  5. #5
    Join Date
    Dec 2001
    Location
    Edmonton, Canada
    Posts
    50
    Quote Originally Posted by BV1963
    Can you check before the recover command that file is actually restored?
    Yes, I am restoring the right file, it can be seen in the log that I sent.
    An elephant is a mouse with an operating system.

  6. #6
    Join Date
    Dec 2001
    Location
    Edmonton, Canada
    Posts
    50
    It recovered the datafile using nocatalog.
    An elephant is a mouse with an operating system.

  7. #7
    Join Date
    Dec 2001
    Location
    Edmonton, Canada
    Posts
    50
    Closing the thread
    An elephant is a mouse with an operating system.

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    opening thread, dont close threads here because other people may want to contribute

  9. #9
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Quote Originally Posted by anujdutt
    It recovered the datafile using nocatalog.
    ????
    maybe you need to recreate your catalog and start a new bkup.
    ---------------

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