OraFAQ Forum: Data Guard » Rman backup in Dataguard

Home » Server Options » Data Guard » Rman backup in Dataguard (11gR2, Redhat 5.5)

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

Rman backup in Dataguard [message #547832]

Sat, 17 March 2012 02:24

ganesh_gvn
Messages: 26
Registered: February 2012
Location: PUNE

Junior Member

Dear All,

I have following query in Dataguard ..

If I want to take Rman archive log backup with delete input command , how the archive logs will be copied to standby database

For eg

I am taking archive backup as

RMAN>backup archivelog all delete input;

here consider few archives are not copied to standby database (due to nw issue) then how standby will receives these missing archives as those are deleted by rman backup at primary side.

Please clear my doubt. I am not getting any document related to above query.

Report message to a moderator

Re: Rman backup in Dataguard [message #547836 is a reply to message #547832]

Sat, 17 March 2012 02:46

Michel Cadot
Messages: 54161
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

RMAN does not delete archived logs that are not shipped.

Regards
Michel

[Updated on: Sat, 17 March 2012 02:47]

Report message to a moderator

Re: Rman backup in Dataguard [message #547842 is a reply to message #547836]

Sat, 17 March 2012 03:21

ganesh_gvn
Messages: 26
Registered: February 2012
Location: PUNE

Junior Member

thanks Michel .... This is very useful information for me.

Regards,
Ganesh

Report message to a moderator

Re: Rman backup in Dataguard [message #547851 is a reply to message #547842]

Sat, 17 March 2012 04:09

Michel Cadot
Messages: 54161
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Unfortunately I tried to search for any reference about this and didn't find any.
I have no test Data Guard configuration for the moment (and no time to build one) so I can't confirm with a test what I said then take it carefully and make a test yourself.

It's easy to do if you have a Data Guard configuration:
1/ Remove the network link between the primary and standby servers
2/ Make some log switches (and make sure they are archived them using ALTER SYSTEM ARCHIVE LOG ALL) on the primary
3/ Copy in another location these archived logs (to save them)
4/ Backup with "delete input" option and see if the archived logs are removed or not.
5/ If so, I was wrong and you just have to put them back from the location you saved them in step 3.
If not, I was right.

Now, RMAN behaviour may depend on the options you give on LOG_ARCHIVE_DEST parameter for the standby database destination.
Anyway, if you make the test, please post the result here.

Regards
Michel

Report message to a moderator

Re: Rman backup in Dataguard [message #547913 is a reply to message #547851]

Sun, 18 March 2012 23:16

smunir362
Messages: 217
Registered: September 2007

Senior Member

Yes rman backup does not delete archive logs which are not applied on standby site; If u create rman log file and later see it there is clearly logged that "archive log 1234 cannot be deleted because it is not yet applied at standby site"

But I want to ask some thing.....
I have a physical standby and a primary database in 10g....
I want to configure it in dataguard environment... means dgrmgrl> or dataguard manager GUI....
What are the steps....

Report message to a moderator

Re: Rman backup in Dataguard [message #547919 is a reply to message #547913]

Mon, 19 March 2012 00:21

Michel Cadot
Messages: 54161
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Those described in the documentation?

Regards
Michel

Report message to a moderator

Re: Rman backup in Dataguard [message #547932 is a reply to message #547919]

Mon, 19 March 2012 02:01

ganesh_gvn
Messages: 26
Registered: February 2012
Location: PUNE

Junior Member

Dear Michel .... You are rite....

I did following steps as per your instruction
1. Defered the LOG_ARCHIVE_DEST_2 parameter ... generated few archive by logswitch.
2. and tried to user rman command RMAN>backup archive log all delete input...

and hers is the output...

archived log file name=/u02/primary/arch/1_182_777823656.dbf RECID=245 STAMP=778335090
archived log file name=/u02/primary/arch/1_183_777823656.dbf RECID=247 STAMP=778335373
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/u02/primary/arch/1_184_777823656.dbf thread=1 sequence=184
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/u02/primary/arch/1_185_777823656.dbf thread=1 sequence=185
Finished backup at 19-MAR-12
RMAN>

Means here archives which are copied to standby side are deleted but those who are not copied to standby side ...are not deleted. . . .

Thanks Michel....

Report message to a moderator

Re: Rman backup in Dataguard [message #547941 is a reply to message #547932]

Mon, 19 March 2012 02:49

Michel Cadot
Messages: 54161
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Thanks to give us the result of your test.

Regards
Michel

Report message to a moderator

Previous Topic:	how to get sql plan in standby database
Next Topic:	stopping log shipping

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 21 09:04:15 CDT 2013

Total time taken to generate the page: 0.13424 seconds