DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Recovry failure- Standby db

  1. #1
    Join Date
    Feb 2003
    Location
    Tehran/Iran
    Posts
    94

    Recovry failure- Standby db

    Hi all,
    I'm trying to build a standby server. Everything goes just fine until using the recover command from standby database for updating the standby database.

    The problem is that I get the error message indicating that the system file is from before resetlogs which is not since I have backuped up the system (opend) after using resetlogs open of open database commend.
    Do you know how to bypass this failure.

    Regards
    Hamhey

  2. #2
    Join Date
    Aug 2002
    Posts
    176
    You could have messed up with a backupfile from a old backup.
    The backup should be a cold backup taken at a consistent time by shutting down with normal,immediate or transaction. Then you open the database and backup the standby controlfile.

    Thanks
    Success Consists of Getting Up Just One More Time Than You've Fallen Down
    Be Blessed

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by Rohit
    The backup should be a cold backup taken at a consistent time...
    No, the backup should be any kind of full backup, either cold or hot. Full hot backup will be just as good as a cold one.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Apr 2003
    Posts
    14
    can you please post lines from alert.log file, from the time you mount standby database and query "recover standby database"
    Moe M Haroon

  5. #5
    Join Date
    Feb 2003
    Location
    Tehran/Iran
    Posts
    94
    HI guys,
    The error messages getting from stand database is as follows:

    SQL> recover standby database;
    ORA-00283: recovery session canceled due to errors
    ORA-01190: controlfile or data file 1 is from before the last RESETLOGS
    ORA-01110: data file 1: '/opt/apps/oracle/product/8.1.5/dbs/oradata/soldb/system01_SOL.dbf'

    And the alert file indicating:

    ORA-000283 faiure.
    Any idea what is wrong. The failure is generate of controlfile or system file. The controlfile has been generated for standby database

    Regards
    Hamhey
    Last edited by hamhey; 04-26-2003 at 01:58 AM.

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