primary is working on pfile currently now.But they have used wrong pfile and started the database,because i check archive parameter.It shows only primaryDB and it doesn't shows standby path. So if i restart primarydb, archiving to standby will work i belive.But standby is not working properly now.what to do?
03-13-2007, 07:19 AM
so start again your analysis from the scratch of creating a standby db, everything that was discussed was useless.
03-13-2007, 08:24 AM
Without shutdown of primary,can i do standby? (i.e, setting everyting correctly in standbydb and can down my primary only for 15min.)if iam able to open standby in read only mode.I can restart primary with right spfile which will take only 10min.
03-13-2007, 11:34 AM
It seems as though you are executing the command used to recreate the controlfile for your primary database. To create a standby controlfile, you need to:
alter database create standby controlfile as '/path/file.ext';
Check the syntax and run it on a test system first.
03-14-2007, 01:37 AM
If there is no other go, i will do it from scratch.