OraFAQ Forum: Data Guard » Multiple datafile location in primary

Home » Server Options » Data Guard » Multiple datafile location in primary (oracle 10GR2 CentOS)

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

Multiple datafile location in primary [message #665021]

Thu, 17 August 2017 18:20

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

Report message to a moderator

Re: Multiple datafile location in primary [message #665023 is a reply to message #665021]

Fri, 18 August 2017 00:41

Michel Cadot
Messages: 68550
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.

Report message to a moderator

Re: Multiple datafile location in primary [message #665080 is a reply to message #665023]

Mon, 21 August 2017 09:06

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

Report message to a moderator

Re: Multiple datafile location in primary [message #665081 is a reply to message #665080]

Mon, 21 August 2017 09:22

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.

Report message to a moderator

Re: Multiple datafile location in primary [message #665088 is a reply to message #665080]

Mon, 21 August 2017 11:11

Michel Cadot
Messages: 68550
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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 02 14:44:54 CST 2023