Home » Server Options » Data Guard » standby control file.. (oracle 10g2 , linux rh3)
standby control file.. [message #386190] Fri, 13 February 2009 01:35 Go to next message
mmee
Messages: 38
Registered: July 2007
Member

hai..
im preparing manual physical standby database.i need few clarification...

1)i want to know this below command when i fired primary database, what exactly do this?
ALTER DATABASE CREATE STANDBY CONTROL FILE

2) primary database, suppose when i fired that command it will create any problem in future .(while backup or restore)



Regards
Re: standby control file.. [message #386433 is a reply to message #386190] Sat, 14 February 2009 20:19 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
When you create standby controlfile, the production database must be in mounted mode, not open
sys@meta> select open_mode from v$database;

OPEN_MODE
----------
MOUNT

sys@meta> alter database create standby controlfile as
  2       '/db2/metastd/datafiles/control01.dbf';

Database altered. 
Re: standby control file.. [message #386447 is a reply to message #386433] Sun, 15 February 2009 01:34 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Quote:
2) primary database, suppose when i fired that command it will create any problem in future .(while backup or restore


NO Issue in future.
Previous Topic: Physical standby database backup issue
Next Topic: General Question about DG
Goto Forum:
  


Current Time: Thu Mar 28 14:13:21 CDT 2024