recover standby database
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: recover standby database

  1. #1
    Join Date
    Nov 2004
    Posts
    20

    Exclamation recover standby database

    I have backed up archive logs to the standby database and followed the steps below to recover it, but am running into the error shown. What am doing wrong?

    SQL> connect /as sysdba
    Connected to an idle instance.
    SQL> startup nomount
    ORACLE instance started.

    Total System Global Area 286858140 bytes
    Fixed Size 453532 bytes
    Variable Size 184549376 bytes
    Database Buffers 100663296 bytes
    Redo Buffers 1191936 bytes
    SQL> alter database mount standby database;

    Database altered.

    SQL> recover standby database until cancel;
    ORA-00279: change 739533 generated at 01/23/2006 12:36:36 needed for thread 1
    ORA-00289: suggestion : C:\U01\APP\ORACLE\ADMIN\OKCDBST2\ARCHARCH_1_64.ARC
    ORA-00280: change 739533 for thread 1 is in sequence #64


    Specify log: {=suggested | filename | AUTO | CANCEL}

    ORA-00279: change 739895 generated at 01/23/2006 12:54:36 needed for thread 1
    ORA-00289: suggestion : C:\U01\APP\ORACLE\ADMIN\OKCDBST2\ARCHARCH_1_65.ARC
    ORA-00280: change 739895 for thread 1 is in sequence #65
    ORA-00278: log file 'C:\U01\APP\ORACLE\ADMIN\OKCDBST2\ARCHARCH_1_64.ARC' no
    longer needed for this recovery


    Specify log: {=suggested | filename | AUTO | CANCEL}

    ORA-00279: change 741914 generated at 01/23/2006 14:36:17 needed for thread 1
    ORA-00289: suggestion : C:\U01\APP\ORACLE\ADMIN\OKCDBST2\ARCHARCH_1_66.ARC
    ORA-00280: change 741914 for thread 1 is in sequence #66
    ORA-00278: log file 'C:\U01\APP\ORACLE\ADMIN\OKCDBST2\ARCHARCH_1_65.ARC' no
    longer needed for this recovery


    Specify log: {=suggested | filename | AUTO | CANCEL}

    ORA-00308: cannot open archived log
    'C:\U01\APP\ORACLE\ADMIN\OKCDBST2\ARCHARCH_1_66.ARC'
    ORA-27041: unable to open file
    OSD-04002: unable to open file
    O/S-Error: (OS 2) The system cannot find the file specified.


    SQL> alter database open resetlogs;
    alter database open resetlogs
    *
    ERROR at line 1:
    ORA-01666: controlfile is for a standby database

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    what are you trying to do, perform a switchover or sync with your prod db?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    and what version

  4. #4
    Join Date
    Nov 2004
    Posts
    20
    am trying to sync with production database

  5. #5
    Join Date
    Nov 2004
    Posts
    20
    version 9.2

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    so why did you create a standby, is it a one time thing, or consistently up to date?

  7. #7
    Join Date
    Nov 2004
    Posts
    20
    I just built one for practice. I imagine if i built one it will be consistently be up to date. Can tell me how to do both? Thanks

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    it is a physical or a logical standby?

  9. #9
    Join Date
    Nov 2004
    Posts
    20
    It is a physical

  10. #10
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    alter database recover managed standby database disconnect from session;

    this needs to be done AFTER you have done alter database mount standby database;

    That will keep it in sync forever, make sure you have set log_archive_dest on the primary, fal client and server as well

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