Standby Database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Standby Database

  1. #1
    Join Date
    Oct 2001
    Posts
    5

    Question

    When I attempt to start up my standby database after activating it, I receive the following error:

    ORA-01190: controlfile or data file 1 is from before the last RESETLOGS.
    ORA-01110: data file 1: '/v01/oradata/prod/system01.dbf'

    I suppose the data files on the standby would be older then the last RESETLOGS since it does a RESETLOG logs automatically when you issue the ACTIVATE STANDBY command.

    Does something need to be done to the datafiles on the standby before you can activate the standby? I do have all of the archived redo logs applied.

    Any insight would be greatly appreciated.

  2. #2

    Wink Inconsistent controlfile and datafile

    Try to generate one more redolog file from the master database and apply into the standby.
    See and tell me what error message are you going to get?
    (I'm interested in the message.)
    Since the controlfile is inconsistent with the system datafile,
    I believe you'll have to recreate your controlfile using the backup script of controlfile creation.

    Queyon
    Queyon Zeng

  3. #3
    Join Date
    Sep 2000
    Posts
    384
    Once you have activated the standby Nothing more you can do .You cannot apply redo or archive from the primary site .

    check by

    select * from v$recover_file;

    if no rows means .. recreate your controlfile and open the database ....

    Pls post your findings ...
    Radhakrishnan.M

  4. #4
    Join Date
    Oct 2001
    Posts
    5
    Thanks for the help, I got it working.

    I did an "ALTER DATABASE BACKUP CONTROLFILE TO TRACE" command from the primary and moved the output generated in the trace file to the standby as a sql file. Then, after I activated the standby database, I ran the script on the standby, recreating the standby control files. After that, it worked beautifully.

    Thanks again,
    Dan

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