Home » Server Options » Data Guard » Multiple datafile location in primary (oracle 10GR2 CentOS)
Multiple datafile location in primary [message #665021] Thu, 17 August 2017 18:20 Go to next message
bank_master
Messages: 73
Registered: April 2007
Location: Guyana
Member

Client has a physical server that is running out of space on the mount point that has the datafiles is running out of space however they have other mount points that can accommodate datafile creation as well as migration to these new drives. The database has a physical standby, usually when a new datafile is added it needs to be added to the standby database, since this is a new location would it be the same or would changes be needed to the init files.

Thanks
Re: Multiple datafile location in primary [message #665023 is a reply to message #665021] Fri, 18 August 2017 00:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Set the standby_file_management to AUTO and the db_file_name_convert parameter to the conversion of the files from primary to standby file systems and no more care about this kind of issue.

Re: Multiple datafile location in primary [message #665080 is a reply to message #665023] Mon, 21 August 2017 09:06 Go to previous messageGo to next message
bank_master
Messages: 73
Registered: April 2007
Location: Guyana
Member

Michel,

Thanks for the response, if i am moving the current datafiles to a new drive just so as to free up some space on the current drive to allow for growth. How would that work with regards to the standby database?

Thanks
Re: Multiple datafile location in primary [message #665081 is a reply to message #665080] Mon, 21 August 2017 09:22 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
bank_master wrote on Mon, 21 August 2017 07:06
Michel,

Thanks for the response, if i am moving the current datafiles to a new drive just so as to free up some space on the current drive to allow for growth. How would that work with regards to the standby database?

Thanks
files on the standby need to move, too.
Re: Multiple datafile location in primary [message #665088 is a reply to message #665080] Mon, 21 August 2017 11:11 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

There is (or may be) no relation between primary and standby storage.
You set and manage this relationship using the 2 parameters I gave you.

Previous Topic: sync between Dc and Dr archive
Next Topic: Impact and risk during data guard implementation
Goto Forum:
  


Current Time: Thu Mar 28 14:08:27 CDT 2024