|
-
I have a physical standby with standby redo logs ( SRLs )running here in my basement lab. I have one in production at work that needs SLRs and their staging standby pair they had to disable. I will be fixing them but had to stop when I noticed there were no backups being taken!
Next week I will be all over this subject again so I'll check back on this thread.
Did you do this for the new standby?
SQL> ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/disk1/oracle/oradata/payroll/standby/payroll2.ctl'
SQL> CREATE PFILE='GLBL3STDBY.ORA' FROM SPFILE
and this..
CREATE SPFILE FROM PFILE=’initpayroll2.ora’;
SQL> STARTUP NOMOUNT;
SQL> ALTER DATABASE MOUNT STANDBY DATABASE;
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
Did you copy all the datafiles over from the primary?
I am going to put a doc together next week on how to manually set one up and verify it so I'll be sure to post it.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|