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.
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.
Once you have activated the standby Nothing more you can do .You cannot apply redo or archive from the primary site .
select * from v$recover_file;
if no rows means .. recreate your controlfile and open the database ....
Pls post your findings ...
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.
Click Here to Expand Forum to Full Width