Networker

Re: [Networker] Oracle backup query [SOLVED]

2007-09-12 04:53:38
Subject: Re: [Networker] Oracle backup query [SOLVED]
From: Vince Howard <V.Howard AT WANSBECK.GOV DOT UK>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Wed, 12 Sep 2007 09:50:52 +0100
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";
}

 
Best Regards,

Vince
 


Vince Howard
Programmer/UNIX System Administrator
IT Section
Wansbeck District Council
Front Street West
Bedlington
Northumberland
NE22 5TU
UK

Tel (DDI): +44 (0)1670 843472
Fax:       +44 (0)1670 843484
e-mail:    v.howard AT wansbeck.gov DOT uk
Web:       www.wansbeck.gov.uk <http://www.wansbeck.gov.uk/> 



Please consider the environment before printing this email. Thank you.
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

This e-mail and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom
they are addressed.  If you have received this e-mail in error please
notify the originator of the message.

Any views expressed in this message are those of the individual
sender, except where the sender specifies and with authority,
states them to be the views of Wansbeck District Council.

This footer also confirms that this e-mail message has been scanned
for the presence of computer viruses.

Wansbeck District Council Web Site is: www.wansbeck.gov.uk


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>