OraFAQ Forum: Backup & Recovery » Adding datafile to Standby

Home » RDBMS Server » Backup & Recovery » Adding datafile to Standby (Oracle 10.2.0.2)

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

Adding datafile to Standby [message #354834]

Tue, 21 October 2008 08:56

preet_kumar
Messages: 204
Registered: March 2007

Senior Member

We have added 4 additional datafiles of 2GB each to 4 different tablespace on primary.
Now how can we do the same on standby.
For any change the control files gets updated,then will the command alter database add datafile and later apply archive logs will work.
Or we have to make a backup copy of primary with control file and make the standby again.

Thanks

Report message to a moderator

Re: Adding datafile to Standby [message #354839 is a reply to message #354834]

Tue, 21 October 2008 09:24

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>Or we have to make a backup copy of primary with control file and make the standby again.
In standby, First issue

recover managed standby database cancel;

alter tablespace in primary
create a new standby controlfile
transfer controlfiles and logs to standby
use "alter database create datafile" in standby.

Report message to a moderator

Re: Adding datafile to Standby [message #354851 is a reply to message #354834]

Tue, 21 October 2008 11:02

preet_kumar
Messages: 204
Registered: March 2007

Senior Member

Thanks for the reply but without doing anything only with recover with redo apply it created the datafiles on standby.No manual addition of datafile on standby.

Report message to a moderator

Re: Adding datafile to Standby [message #354855 is a reply to message #354851]

Tue, 21 October 2008 11:40

ebrian
Messages: 2794
Registered: April 2006

Senior Member

I assume you don't have STANDBY_FILE_MANAGEMENT set to AUTO ? If not, check When STANDBY_FILE_MANAGEMENT Is Set to MANUAL. Otherwise, if it is set to AUTO you don't have to do anything with the standby, Oracle does it automatically.

[Updated on: Tue, 21 October 2008 11:41]

Report message to a moderator

Previous Topic:	backup policy
Next Topic:	how to restore the backup from achive log files

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Aug 28 16:44:39 CDT 2025