Networker

Re: [Networker] Oracle backup query [SOLVED]

2007-09-12 06:08:57
Subject: Re: [Networker] Oracle backup query [SOLVED]
From: Ronny Egner <Ronny.Egner AT SIV DOT DE>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Wed, 12 Sep 2007 12:06:00 +0200
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

<Prev in Thread] Current Thread [Next in Thread>