OraFAQ Forum: Backup & Recovery » Backup Archivelog with standby

Home » RDBMS Server » Backup & Recovery » Backup Archivelog with standby (9.2.0.8)

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

Backup Archivelog with standby [message #474709]

Wed, 08 September 2010 06:35

eigeneachse
Messages: 37
Registered: July 2008

Member

Hi,
i have an database and an physical standby database.
I want to take archivelog backups from my primary database with

backup archivelog all delete input;

Is there any command that rman will only delete these archives, that are also applied on the standby database? The only informations i found on this was for oracle 10g and above.

If you have any hints for that, please be so kind to let me know.

Regards

Ralph

Report message to a moderator

Re: Backup Archivelog with standby [message #474766 is a reply to message #474709]

Wed, 08 September 2010 13:07

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

You will need to query ARCHIVED_SEQ# column of V$ARCHIVE_DEST_STATUS for the standby destination and dynamically set it in rman:

backup archivelog until scn=$QUERIED_SCN
       delete input;

[Updated on: Wed, 08 September 2010 13:18] by Moderator

Report message to a moderator

Re: Backup Archivelog with standby [message #474802 is a reply to message #474766]

Thu, 09 September 2010 01:17

eigeneachse
Messages: 37
Registered: July 2008

Member

Hi LKBrwn_DBA,
thank you for your input. I will try your solution.

Regards

Ralph

Report message to a moderator

Previous Topic:	SCN on Read only Tablespace
Next Topic:	About MAXSETSIZE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 18:07:47 CST 2024