Home » Server Options » Data Guard » BAcking up primary and physical standby
BAcking up primary and physical standby [message #260800] Mon, 20 August 2007 23:49 Go to next message
kum187ar
Messages: 4
Registered: August 2007
Junior Member
We have a DG setup with a single instance primary node and a physical standby db. They both use their own FRA's and their own disks. Nothing is shared. Also the datafiles use OMF on both the db's. My questions are
1. Can i register the primary with the rman catalog and still backup the standby?
2. Should i backup the archive logs on primary? If so what rman settings should i use on both for the archive logs?
3. We wanted to back up both the dbs as it will be faster to restore since we wont have to convert filenames (cause of OMF) when we have to resotore backup taken on primary to standby or vice versa.

Any advise related to this scenario is highly appreciated.

Thanks.
Re: BAcking up primary and physical standby [message #260919 is a reply to message #260800] Tue, 21 August 2007 04:53 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
1. Yes
2. Either the primary or the standby's archive logs.
3. Not really necessary to backup both. Converting filenames is seamless and not time consuming.
Re: BAcking up primary and physical standby [message #260988 is a reply to message #260919] Tue, 21 August 2007 08:06 Go to previous messageGo to next message
kum187ar
Messages: 4
Registered: August 2007
Junior Member
What if you have 50-100 datafiles? You still have to maually plug a cumbersome number in correct? How can that be done easily.
Re: BAcking up primary and physical standby [message #261057 is a reply to message #260988] Tue, 21 August 2007 12:05 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Set the appropriate DB_CREATE_FILE_DEST parameter.
Re: BAcking up primary and physical standby [message #261070 is a reply to message #261057] Tue, 21 August 2007 13:45 Go to previous messageGo to next message
kum187ar
Messages: 4
Registered: August 2007
Junior Member
That parameter is set ot the same on both dbs but since oracle creates unique file names they are not the same name on both the servers when using OMF. Any suggestions?
Re: BAcking up primary and physical standby [message #261113 is a reply to message #261070] Tue, 21 August 2007 19:49 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
No worries, Oracle will assign a new name automatically to the restored datafiles.

Maybe I'm missing what you are asking?
Re: BAcking up primary and physical standby [message #261141 is a reply to message #261113] Wed, 22 August 2007 00:22 Go to previous messageGo to next message
kum187ar
Messages: 4
Registered: August 2007
Junior Member
You said converting filenames is seamless. How so?
The question I have is that if we backup say the primary and that has many datafiles with unique names and we have to restore it on the standby then we will have to do a set newname for all the datafiles as the standby controlfile will have different names for the datafiles because it is using OMF.
Say i create a datafile on primary today and it is created as o1_mf_lo_12s34t.dbf, when it goes to the standby it will get created as o1_mf_lo_34d56y.dbf.
They are the same file but OMF gives it a unique name. How do you hanle those during restores.


Re: BAcking up primary and physical standby [message #261299 is a reply to message #261141] Wed, 22 August 2007 05:11 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
kum187ar wrote on Wed, 22 August 2007 01:22
... have to restore it on the standby...

I have no idea what you mean by this.

As I mentioned, the file names are essentially handled transparently by Oracle, that's the beauty of OMF.
Previous Topic: DG and multiplexing
Next Topic: Using Data Broker -- Observation
Goto Forum:
  


Current Time: Thu Mar 28 04:13:33 CDT 2024