Home » Server Options » Data Guard » Standby Database
Standby Database [message #187278] Fri, 11 August 2006 11:12 Go to next message
manish mendiratta
Messages: 110
Registered: May 2002
Senior Member
Hi,

Is it possible to create physical standby database with diff file structure than Master(Primary) database? For example i have master database files spread over two volumes /u1/orcl/oradata/ and u2/orcl/oradata/ and standby database has only one volumn /u1/orcl/oradata.

If yes then what's going to happend if I add a new datafile in Master database in /u2 volumne how it going to work.
Has got to do something with INIT.ora parameter on Standby?

Thanks
Manish
Re: Standby Database [message #187283 is a reply to message #187278] Fri, 11 August 2006 12:11 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Yes it's possible. You'll need to specify DB_FILE_NAME_CONVERT.
Re: Standby Database [message #187284 is a reply to message #187278] Fri, 11 August 2006 12:23 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
mkdir -p /u2/orcl
ln -s /u1/orcl/oradata /u2/orcl/oradata
Re: Standby Database [message #187287 is a reply to message #187278] Fri, 11 August 2006 12:47 Go to previous messageGo to next message
manish mendiratta
Messages: 110
Registered: May 2002
Senior Member
Hi,
Do i need to create a link for the volumn? Shouldn't DB_FILE_NAME_CONVERT should work?

Thanks
M
Re: Standby Database [message #187602 is a reply to message #187287] Mon, 14 August 2006 11:45 Go to previous message
SQLAREA
Messages: 21
Registered: January 2006
Location: Belgium
Junior Member
Hi

As said here above appropriate configuration of DB_FILE_NAME_CONVERT is what you are looking for.
You may want to consider the initialization parameter standby_file_management as well.

Regards
Guy
Previous Topic: RMAN backup in Standby site
Next Topic: data guard gap monitoring script ASAP
Goto Forum:
  


Current Time: Thu Mar 28 17:10:43 CDT 2024