Home » RDBMS Server » Backup & Recovery » Backup Archivelog with standby (9.2.0.8)
Backup Archivelog with standby [message #474709] Wed, 08 September 2010 06:35 Go to next message
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
Re: Backup Archivelog with standby [message #474766 is a reply to message #474709] Wed, 08 September 2010 13:07 Go to previous messageGo to next message
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 Go to previous message
eigeneachse
Messages: 37
Registered: July 2008
Member
Hi LKBrwn_DBA,
thank you for your input. I will try your solution.

Regards

Ralph
Previous Topic: SCN on Read only Tablespace
Next Topic: About MAXSETSIZE
Goto Forum:
  


Current Time: Fri Mar 29 07:22:16 CDT 2024