[RMAN] Take the archives during the backup

#11

On Aug 30, 7:41*am, Vinni <hea... (AT) gmail (DOT) com> wrote:

Quote:

On Aug 29, 11:51*pm, John Hurley <hurleyjo... (AT) yahoo (DOT) com> wrote:

heald:

Using RMAN the most practical and safest approach to me would be to
backup all the archives that have not been backed up, then backup the
database plus the archives logs and then you would just copy the files
from the time of the second backup which you could get from the
listing the backups to know which files to copy and you still have
your archives backed up from before.

Something like:

SQL 'ALTER SYSTEM CHECKPOINT'';
SQL 'ALTER SYSTEM SWITCH LOGFILE'';
backup archivelog all;
SQL 'ALTER SYSTEM CHECKPOINT'';
backup database plus archivelog;

If you go down this path you probably want to do the backup database
then switch archivelogs then backup the archivelogs.

You want to make sure you have an archivelog after the backup in other
words.

RMAN automatically switches them out making sure you have all the logs
used during the backup(well its supposed to), however i've been using
this particular backup script below for years, tested it countless
times and had to depend on backups taken with it on several occasions
and I put the archive log backup separately for some reason which may
be the same reason your talking about, despite oracle saying the plus
archivelog option should work.

:

connect target /
run
{
crosscheck archivelog all;
crosscheck backup;
crosscheck copy;
backup database;
backup archivelog all not backed up 2 times;
restore database validate;
delete noprompt archivelog all completed before 'SYSDATE -7';
delete noprompt obsolete;
sql "create pfile from spfile";
sql "alter database backup controlfile to trace";

}

If that's the case i'de change the original script to I posted to this
to make sure im using stuff i've tested myself for time:

SQL 'ALTER SYSTEM CHECKPOINT'';
SQL 'ALTER SYSTEM SWITCH LOGFILE'';
backup archivelog all;
SQL 'ALTER SYSTEM CHECKPOINT'';
backup database;
backup archivelog all not backed up 2 times;

Please show rman configuration changes. It can make a difference.

jg
--
@home.com is bogus.
http://www.signonsandiego.com/news/2010/aug/29/covario/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

[RMAN] Take the archives during the backup

comp.databases.oracle.server comp.databases.oracle.server

Re: Take the archives during the backup - 08-30-2010 , 10:41 AM