Home » RDBMS Server » Backup & Recovery » Adding datafile to Standby (Oracle 10.2.0.2)
Adding datafile to Standby [message #354834] Tue, 21 October 2008 08:56 Go to next message
preet_kumar
Messages: 195
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
Re: Adding datafile to Standby [message #354839 is a reply to message #354834] Tue, 21 October 2008 09:24 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: Adding datafile to Standby [message #354851 is a reply to message #354834] Tue, 21 October 2008 11:02 Go to previous messageGo to next message
preet_kumar
Messages: 195
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.
Re: Adding datafile to Standby [message #354855 is a reply to message #354851] Tue, 21 October 2008 11:40 Go to previous message
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:
  


Current Time: Wed Dec 07 08:30:58 CST 2016

Total time taken to generate the page: 0.09557 seconds