This discussion is archived
6 Replies Latest reply: Nov 19, 2013 8:49 PM by Jibu RSS

Creating physical standby

Jibu Newbie
Currently Being Moderated

HI,

 

I am trying to create a new physical standby for my production database.

I have taken a copy of database.

Then i created backup control file... This was created when database was open... Should create it when primary database is mounted ( not open )...

 

I am getting following error while trying to apply archive files...

 

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: 'O:\ORADATA\NEFT\SYSTEM01.DBF'

 

Regards,

Jibu

  • 1. Re: Creating physical standby
    Fran Guru
    Currently Being Moderated

    how to create physical standby database --> Creating a Physical Standby Database

     

    to solve your proble, did you tried?

     

    sqlplus / as sysdba

    SQL> alter database open resetlogs

    ? you will open a NOT standby database. to do that you should read the first link, where explain how to create a backup for standby database and how to create it.

     

    Next time to do a Point in time recovery you should read first how to do it --> 7.6 Performing Database Point-In-Time Recovery

  • 2. Re: Creating physical standby
    MahirM.Quluzade Guru
    Currently Being Moderated

    Jibu wrote:

     

    HI,

     

    I am trying to create a new physical standby for my production database.

    I have taken a copy of database.

    Then i created backup control file... This was created when database was open... Should create it when primary database is mounted ( not open )...

     

    I am getting following error while trying to apply archive files...

     

    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: 'O:\ORADATA\NEFT\SYSTEM01.DBF'

     

    Regards,

    Jibu

    Hi,

     

    What is your version?

     

    Did you sure you are create backup  control file for standby?

    Please check on Standby side: select database_role from v$database;

     

    If you database is created successfully, then you must start  Apply process on standby database

    for recover managed standby.

     

    alter database recover managed standby database disconnect from session; 

    OR

    alter database recover managed standby database using current logfile disconnect from session;  -- real time apply (after 11g)

     

    Regards

    Mahir M. Quluzade

  • 3. Re: Creating physical standby
    Anar Godjaev Expert
    Currently Being Moderated

    Hi,

     

    Please check Oracle support id :

     

    While Duplicating the Database ,Rman Errors ora-1547,ora-1152,ora-1110 During Recovery (Doc ID 274118.1)

    Step By Step Guide To Create Physical Standby Database Using RMAN Backup and Restore (Doc ID 469493.1)

     

    Thank you


  • 4. Re: Creating physical standby
    nagulan.selvakumar Journeyer
    Currently Being Moderated
    Then i created backup control file... This was created when database was open... Should create it when primary database is mounted ( not open )...

     

    Not necessarily the primary to be mounted as there is no downtime needed to create a physical standby database. Did you create a controlfile for standby?

     

    Alter database create standby controlfile as '/location/of/file/name.ctl';

     

    Use this controlfile to recover your cloned standby and don't attempt to open it; just start media recovery using MRP. Check the status of your log apply on standy.

     

    Thank you!!

  • 5. Re: Creating physical standby
    Jibu Newbie
    Currently Being Moderated

    Yes.. Standby control file was created from primary ( primary was OPEN for readwrite)...

     

    Database mode is PHYSICAL STANDBY...

     

    Reagards,

    Jibu

  • 6. Re: Creating physical standby
    MahirM.Quluzade Guru
    Currently Being Moderated

    Hi,

     

    It is good.

     

    Please check my before reply and  after restore database, don't open database.

    Check data guard configuration parameters is setting correctly.

     

    Check transport service is running, Apply process is started, Redo  changes received by standby.

     

    select max(sequence#) from v$archived_log;  -- on both side

    select max(sequence#) from v$archived_log where applied='YES';  -- on standby side

     

    Regards

    Mahir M. Quluzade

Legend

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