OraFAQ Forum: Data Guard » standby control file..

Home » Server Options » Data Guard » standby control file.. (oracle 10g2 , linux rh3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

standby control file.. [message #386190]

Fri, 13 February 2009 01:35

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

Report message to a moderator

Re: standby control file.. [message #386433 is a reply to message #386190]

Sat, 14 February 2009 20:19

trantuananh24hg
Messages: 747
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.

Report message to a moderator

Re: standby control file.. [message #386447 is a reply to message #386433]

Sun, 15 February 2009 01:34

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.

Report message to a moderator

Previous Topic:	Physical standby database backup issue
Next Topic:	General Question about DG

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 04 07:25:53 CST 2026