This content has been marked as final. Show 5 replies
This is not good. It points to an issue with the Standby control file(s). I never seen this in Oracle 11. The thought is to recreate the control file, but I don't like to advise on something I have not tested.
I think before I did anything I would shutdown the Standby and startup mount and try starting apply again.
Which method did you finally use to create the Standby? Maybe this will offer a greater clue.
RMAN should handle the DBID. Any chance a duplicate was done instead of a duplicate for standby?
Found similar issue here but not much help I'm thinking :
Edited by: mseberg on Jun 29, 2012 10:32 AM
Thanks for the speedy reply.
duplicate target database for standby from active database NOFILENAMECHECK;
I also have done shutdown; startup mount; alter database recover managed standby database disconnect from session; previously to raising this thread.
I do have a fear that the duplicate target database didn't fully complete though as due to the setup here my session stopped. I monitored the end of the rman process before continuing though but there is still a big question mark over did it get any further than datafile 1 the system file.
Do you think if I tried to repeat the duplicate this might resolve the issue or just makes things worse?
Do you think if I tried to repeat the duplicate?
Yes I think you should do this.
Give me a few minutes and I will review my Word document and provide a step by step overview here as insurance.
I always cleanup the standby before trying another dup
Step 1 - Password file fro standby - Copy from primary and rename
Step 2 - Directory Structure on the remote server - Make sure noting is missing
Step 3 - Oracle Net Setup - entry for the CLONE in your TNSNAMES.ORA on both servers
Step 4 - SID_LIST_LISTENER addition ( assumes listener named LISTENER )
Step 5 - Timeouts set in listener.ora and sqlnet.ora Both Servers
Step 6 - Initialization Parameter File for the Auxiliary Instance
Step 7 - Set SID for Auxiliary Instance
Step 8 - Create an SPFILE for the new database by using a pfile with the INIT settings
Step 9 - Shutdown and startup nomount on new Spfile ( Auxiliary Instance )
Step 10 - Start RMAN and run the DUPLICATE Command
SID_LIST_LISTENER Example from mine
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/app/oracle/product/18.104.22.168) (PROGRAM = extproc) ) (SID_DESC = (global_dbname = CLONE.hostname) (ORACLE_HOME = /u01/app/oracle/product/22.214.171.124) (sid_name = CLONE) ) )
Add these to both servers To listener.ora INBOUND_CONNECT_TIMEOUT_ = 120 To sqlnet.ora SQLNET.INBOUND_CONNECT_TIMEOUT = 120 Then stop and start the listener.
$ORACLE_HOME/bin/rman target=sys/@primary auxiliary=sys/@standby
Connect should return something like this
RMAN>duplicate target database for standby from active database NOFILENAMECHECK;
connected to target database: RECOVER9 (DBID=3806912436) connected to auxiliary database: CLONE (not mounted)
To avoid ORA-09925 make sure the PFILE has audit_file_dest and core_dump_dest set
Edited by: mseberg on Jun 29, 2012 11:12 AM