RE: rman - backup plus archivelog
- From: "Walker, Jed S" <Jed_Walker@xxxxxxxxxxxxxxxxx>
- To: "tkiernan@xxxxxxxxxxx" <tkiernan@xxxxxxxxxxx>, "peter.schauss@xxxxxxx" <peter.schauss@xxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 7 Jul 2011 17:01:43 +0000
Or simply
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of TJ Kiernan
Sent: Thursday, July 07, 2011 9:14 AM
To: peter.schauss@xxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Schauss, Peter (ESS)
Sent: Thursday, July 07, 2011 10:04 AM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
