This discussion is archived
5 Replies Latest reply: Feb 12, 2013 2:09 PM by 990515 RSS

Manual Standby Database not in sync with missing archivelogs

990515 Newbie
Currently Being Moderated
Hello,

OS: Solaris
DB: Oracle 11.2.0.1 EE
Not Using ASM or RAC

I have a Production database that is in archivelog mode and a Standby DR server.
Both servers (Prod, Standby) have exact same structure and db name/version.

We manually scp archive logs and recover them to a manual standby database via SQL Scripts "cron". (I.E. set autorecovery on; recover standby database;)
We recently got out of sync with our log files and have not been applying them to the standby. As part of Prod Maintenance, these log files were deleted and are not available anymore.
I've tried several ways to "rebuild" our standby database. I have tried to Shutdown prod, backup all the db files and scp them to standby, re-create standby controlfile and startup mount and recover standby.
Every time I try to apply a new archive log via recover standby, these are the errors:

ORA-00279: change 211077622 generated at 1/27/2012 12:18:42 needed for thread 1
ORA-00289: suggestion : /oradump/arch/PROD/PROD_arch_1_69486_736618850.arc
ORA-00280: change 211077622 for thread 1 is in sequence #69486


ORA-00308: cannot open archived log '/oradump/arch/PROD/PROD_arch_1_69486_736618850.arc'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

ORA-10879: error signaled in parallel recovery slave
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: '/oradevices/PROD/oraPRODsystem1.dbf'

When I check v$log_history, the new logs have not been applied.
I've also tried the "Restore from incremental backup via SCN" method with same results.

Is there a way to re-create the standby clean and ensure that the log chain that is currently broken gets fixed or reset?
I would eventually like to get DataGuard in here, but that's not the case at the moment.
Thanks for your suggestions.

-Dav
  • 1. Re: Manual Standby Database not in sync with missing archivelogs
    KuljeetPalSingh Guru
    Currently Being Moderated
    ORA-00308: cannot open archived log '/oradump/arch/PROD/PROD_arch_1_69486_736618850.arc'
    ORA-27037: unable to obtain file status
    SVR4 Error: 2: No such file or directory
    is this archive log present on above destination
    post output of
    ls -ltr /oradump/arch/PROD/PROD_arch_1_69486_736618850.arc

    also post error msg while applying incremental backup.
  • 2. Re: Manual Standby Database not in sync with missing archivelogs
    saurabh Pro
    Currently Being Moderated
    if you are using the cold backup to create the standby database, Check that have you followed the following steps or not.

    1. remove
    all the datafiles and controlfiles from the standby database.

    2. Create a new standby controlfile of the production for standby using the following cmd
    'alter database create standby controlfile as 'Location';'

    3. move the new controlfile to standby database server location as specified in initialization parameter file.

    4. Restore all the datafiles to its appropriate loaction which was taken through cold backup.

    5. startup nomount

    6. alter database mount standby database;

    7. recover standby database.
    scp the archive log sequence that is asked by the database, from production.

    You can try this steps.
  • 3. Re: Manual Standby Database not in sync with missing archivelogs
    Mihael Pro
    Currently Being Moderated
    1. check that log_archive_format is the same for primary and standby
    2. put all logs to some directory, ex. /dir1
    3. run
    alter database recover automatic from '/dir1' standby database;
  • 4. Re: Manual Standby Database not in sync with missing archivelogs
    Step_Into_Oracle_DBA Explorer
    Currently Being Moderated
    987512 wrote:
    Is there a way to re-create the standby clean and ensure that the log chain that is currently broken gets fixed or reset?
    Do Roll Forwarding of Standby Database which is the easier way to bring Primary and Standby SYNC when archive logs are not available.

    Rolling a Standby Forward using an RMAN Incremental Backup in 10g onwards [ID 290814.1]


    Mark your Post as Answered or Helpful if Your question is answered.

    Thanks & Regards,
    SID

    (StepIntoOracleDBA)

    Email : stepintooracledba@gmail.com

    http://stepintooracledba.blogspot.in/

    http://www.stepintooracledba.com/

    Edited by: Step Into Oracle DBA on Feb 12, 2013 5:16 AM
  • 5. Re: Manual Standby Database not in sync with missing archivelogs
    990515 Newbie
    Currently Being Moderated
    Thank you everyone for your responses. I've seen the roll forward article.
    I'm pretty sure I followed those directions properly before without success, but now I have it the standby up and receiving new archive logs after performing the complete cold backup and recover method.
    Question is marked as answered.
    Cheers.
    -Dav

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points