RE: rman - backup plus archivelog

backup database plus archivelog delete input;

This will delete the archivelogs that were backed up. If you're running DataGuard then this, in my experience, won't work and you have to use commands like T.J. provided.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of TJ Kiernan Sent: Thursday, July 07, 2011 9:14 AM
To: peter.schauss_at_ngc.com; oracle-l_at_freelists.org Cc: TJ Kiernan
Subject: RE: rman - backup plus archivelog

RMAN will back up any archivelogs it expects to see. If you want to delete archivelogs after you've backed them up, do it with RMAN. Add something like this to your backup script:

delete noprompt archivelog all backed up <N> times;

Thanks,
T. J.
 

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Schauss, Peter (ESS) Sent: Thursday, July 07, 2011 10:04 AM
To: oracle-l_at_freelists.org
Subject: rman - backup plus archivelog

Oracle 11.2.0.1.0 on AIX 5.3

I am backing up a database with rman in nocatalog mode.

When I tried to test my backups using the rman DUPLICATE command I got a message that the backup contained no archivelogs. The information on Metalink suggested using the command BACKUP DATABASE PLUS ARCHIVELOG. When I ran that rman asked for all of the archivelogs created since the database was created (luckily only a week and a half ago). This despite the fact that that I had been backing it up daily without the PLUS ARCHIVELOG option.

Now that rman has backed up the archivelogs, what will determine which ones it asks for the next time I run it?

Ideally all that I need to restore a backup is the archivelogs which were created during and after the backup.

Thanks,
Peter Schauss
--

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

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jul 07 2011 - 12:01:43 CDT