RE: RMAN/DG - delete *ONLY* archive logs "already shipped to thestandby DataGuard database"?

From: Marquez, Chris <CMarquez_at_aarp.org>
Date: Mon, 10 Jan 2005 17:54:22 -0500
Message-ID: <7E412C164E6ECB468834A39F31E6E0D406688FDB@mbs06dc.na.aarp.int>

Carel-Jan Engel
>>But, AFAIK, RMAN is not DG-aware.

Yes, I believe you are right...and based on the answers (from Oracle Employees)
I have seen on "Forums" @ Metalink, I sure of it. :O| Actually Oracle Employees on the forum, never really answers the question...

>>when you dynamically generate your RMAN script based on the
Ah...the beatuy of RMAN...no "dynamic" scripts needed for the primary db backup,
but just like the old HOT Bakcup days I think I'm going to have to write shell, Perl,
maybe even pl/sql code to aovid delecting log needed by the standyby. Sad, but maybe it will be *fixed* in Oracle 11XL. :o)

Thanks,

Chris Marquez
Oracle DBA
HEYMONitor(tm) - heymonitor.com
"Oracle Monitoring & Alerting Solution"    

 ----Original Message-----
From: Carel-Jan Engel [mailto:cjpengel.dbalert_at_xs4all.nl] Sent: Monday, January 10, 2005 5:07 PM
To: Marquez, Chris
Cc: oracle-l_at_freelists.org
Subject: Re: RMAN/DG - delete *ONLY* archive logs "already shipped to thestandby DataGuard database"?

        Chris,         

        I'm not an experienced RMAN user, others will have better advice on that topic. But, AFAIK, RMAN is not DG-aware. You might be able to achieve this when you dynamically generate your RMAN script based on the , and use the V$ARCHIVED_LOG view to determine what change# needs to be applied in the 'BACKUP ARCHIVELOG UNTIL SCN <last forwarded SCN>' command.                  

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok) ===

Upcoming appearances:

• Jan 27, 2005: London, UKOUG Unix SIG: Data Guard Best Practices
• Feb 9-10, 2005: Denver, RMOUG Training Days: Data Guard Performance Issues
• Mar 6-10, 2005: Dallas, Hotsos Symposium: Data Guard Performance Issues

        On Mon, 2005-01-10 at 18:08, Marquez, Chris wrote:

                Hi All,                 

                My Oracle-DB is Oracle 9205.                 

		We use RMAN to backup databases and archive logs.
		Once archive logs are backed up we also use RMAN to
delete them.=20
		We implement standby using DataGuard.=20
		Sometimes RMAN backs up archive logs and deletes them
before DataGuard
		ships the archive logs to stand by site.
		
		Is there any way I can instruct RMAN to backup all the
archive logs=20
		BUT delete *ONLY* archive logs "already shipped to the
standby DataGuard
		database".
		
		Notice that I did not say delete logs older than "n"
time/date...no, I
		want to delete logs shipped not matter what the

date/time is.                 

                Thanks in advance.                 

                PS Please respond directly to me as well as to the list.                 

		Chris
		Oracle DBA
		HEYMONitor(tm) - heymonitor.com
		"Oracle Monitoring & Alerting Solution"
		--
		http://www.freelists.org/webpage/oracle-l

<http://www.freelists.org/webpage/oracle-l>         

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jan 10 2005 - 16:54:19 CST