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

Thread: automatic recovery

  1. #1
    Join Date
    Nov 2000
    Posts
    440

    automatic recovery

    I have a standby database that i want to open and recover every week.

    I cannot use dataguard, since my client does not want to buy another oracle license.

    So we down the primary server once a week. And we startup the standby database to recover it.
    We transfer the archive log in real time using a software.


    Question:
    I want the recovery process to be done automaticaly.

    Here is what we do presently:

    startup nomount;
    alter database mount standby database;
    recover standby database;

    ORA-00279: change 18491383 generated at 01/02/2007 16:08:47 needed for thread 1
    ORA-00289: suggestion :
    D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2007_01_15\O1_MF_1_
    4224_%U_.ARC
    ORA-00280: change 18491383 for thread 1 is in sequence #4224


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




    But oracle always ask us to enter the filename or put auto manualy. Is there a way to do this automaticaly?

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Did you try "recover standby database automatic;" or if necessary "recover standby database automatic from location 'D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2007_01_15\';"

  3. #3
    Join Date
    Nov 2000
    Posts
    440
    It worked with the following:
    recover automatic standby database until cancel;


    Thanks

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    and you still need a license for your other server, you have an oracle instance running - you need to license it

  5. #5
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    They don't. They recover it while the primary is down :-D
    However I belive you need a licence even if the software is installed, although not running

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    doesnt matter if the primary is down, you license the server, if it is running - you need a license (if up for more than 5 days per year in total)

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