Vince Howard schrieb:
Hi,
Many thanks to everyone who took the time to reply, especially Ronny
Egner and Curtis Preston - I was aware that I needed to backup archive
logs, but the redo log switch was a news to me and the 'backup to trace'
could prove to be a life saver at some point too! My revised script now
reads as follows:
run {
set command id to 'DBTRAIN1_INCR';
allocate channel t1 type 'SBT_TAPE';
allocate channel t2 type 'SBT_TAPE';
backup incremental level = 1
filesperset 2
format '%d_INCR_%s_%t'
(database include current controlfile);
backup archivelog all delete all input;
release channel t1;
release channel t2;
sql "alter database backup controlfile to
''D:\oradb\ControlFileBackups\RCVCAT_BACKUP.CTL'' reuse";
sql "alter database backup controlfile to trace as
''D:\oracle\admin\rcvcat\bdump\RCVCAT_CTRLFILE.trc'' reuse";
alter database open;
sql "alter system switch logfile";
}
Vince,
*first* switch the redo and after that backup the
archive logs, i.e.
..
backup incremental level = 1
filesperset 2
format '%d_INCR_%s_%t'
(database include current controlfile);
sql "alter system switch logfile";
backup archivelog all delete all input;
....
--
Mit freundlichen Grüßen
Ronny Egner
Diplom-Ingenieur (BA)
Systeme & Service
Oracle DBA
Telefon: +49 381 2524-422
Telefax: +49 381 2524-399
mailto:ronny.egner AT siv DOT de
http://www.siv.de
***************************************************************************************
Aus Rechtsgründen ist die in dieser E-Mail gegebene Information nicht
rechtsverbindlich. Eine rechtsverbindliche Bestätigung reichen wir Ihnen
auf
Anforderung in schriftlicher Form nach. Diese Nachricht ist
ausschließlich für den
bezeichneten Adressaten oder dessen Vertreter bestimmt.
The information contained in this email is not legally binding. At your
request,
we will provide you with a legally binding confirmation in written form.
This
message is intended solely for the addressee, entity to which the email
is addressed or the authorised agent.
***************************************************************************************
To sign off this list, send email to listserv AT listserv.temple DOT edu and type
"signoff networker" in the body of the email. Please write to networker-request
AT listserv.temple DOT edu if you have any problems with this list. You can access the
archives at http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER
|