OraFAQ Forum: Data Guard » BAcking up primary and physical standby

Home » Server Options » Data Guard » BAcking up primary and physical standby

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

BAcking up primary and physical standby [message #260800]

Mon, 20 August 2007 23:49

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.

Report message to a moderator

Re: BAcking up primary and physical standby [message #260919 is a reply to message #260800]

Tue, 21 August 2007 04:53

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.

Report message to a moderator

Re: BAcking up primary and physical standby [message #260988 is a reply to message #260919]

Tue, 21 August 2007 08:06

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.

Report message to a moderator

Re: BAcking up primary and physical standby [message #261057 is a reply to message #260988]

Tue, 21 August 2007 12:05

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Set the appropriate DB_CREATE_FILE_DEST parameter.

Report message to a moderator

Re: BAcking up primary and physical standby [message #261070 is a reply to message #261057]

Tue, 21 August 2007 13:45

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?

Report message to a moderator

Re: BAcking up primary and physical standby [message #261113 is a reply to message #261070]

Tue, 21 August 2007 19:49

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?

Report message to a moderator

Re: BAcking up primary and physical standby [message #261141 is a reply to message #261113]

Wed, 22 August 2007 00:22

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.

Report message to a moderator

Re: BAcking up primary and physical standby [message #261299 is a reply to message #261141]

Wed, 22 August 2007 05:11

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.

Report message to a moderator

Previous Topic:	DG and multiplexing
Next Topic:	Using Data Broker -- Observation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 16:59:49 CST 2025