Home » Server Options » Data Guard » Rman backup in Dataguard (11gR2, Redhat 5.5)
Rman backup in Dataguard [message #547832] Sat, 17 March 2012 02:24 Go to next message
ganesh_gvn
Messages: 28
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.


Re: Rman backup in Dataguard [message #547836 is a reply to message #547832] Sat, 17 March 2012 02:46 Go to previous messageGo to next message
Michel Cadot
Messages: 59427
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 Go to previous messageGo to next message
ganesh_gvn
Messages: 28
Registered: February 2012
Location: PUNE
Junior Member

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


Regards,
Ganesh
Re: Rman backup in Dataguard [message #547851 is a reply to message #547842] Sat, 17 March 2012 04:09 Go to previous messageGo to next message
Michel Cadot
Messages: 59427
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
Re: Rman backup in Dataguard [message #547913 is a reply to message #547851] Sun, 18 March 2012 23:16 Go to previous messageGo to next message
smunir362
Messages: 261
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....
Re: Rman backup in Dataguard [message #547919 is a reply to message #547913] Mon, 19 March 2012 00:21 Go to previous messageGo to next message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Those described in the documentation?

Regards
Michel
Re: Rman backup in Dataguard [message #547932 is a reply to message #547919] Mon, 19 March 2012 02:01 Go to previous messageGo to next message
ganesh_gvn
Messages: 28
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....
Re: Rman backup in Dataguard [message #547941 is a reply to message #547932] Mon, 19 March 2012 02:49 Go to previous message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks to give us the result of your test.

Regards
Michel
Previous Topic: how to get sql plan in standby database
Next Topic: stopping log shipping
Goto Forum:
  


Current Time: Fri Oct 24 15:53:04 CDT 2014

Total time taken to generate the page: 0.13214 seconds