Networker

Re: [Networker] oracle backup querry

2007-09-12 05:00:36
Subject: Re: [Networker] oracle backup querry
From: Helmar Pabst <Helmar.Pabst AT SIV DOT DE>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Wed, 12 Sep 2007 10:45:17 +0200
Hi Ronny,

wanted to reply to your question regarding backing up
controlfile to disk during an sbt backup in theEMC NetWorker
Mailinglist:

You can easy achive this by opening a disk channel and do a
"backup as copy current controlfile" to specified disk location.
The DBID of the Database appears in the script in
the controlfilecopy name.

The tested script is attached.

rgds Helmar

#############################

connect target sys/xxx@prod;
run {

CONFIGURE RETENTION POLICY TO REDUNDANCY 30;
CONFIGURE CHANNEL DEVICE TYPE SBT_TAPE PARMS='ENV=(NSR_SERVER=schulung-wk01, 
NSR_DATA_VOLUME_POOL=Default)';
CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 2;
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPE;

CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'sbt_tape' to 
'controlfile_autobackup_%F/';
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 
"d:\oracle\rman_sicherungen\CTL_PROD_snap.CTL";

allocate channel ch1 type 'SBT_TAPE';
allocate channel ch2 type 'SBT_TAPE';

backup archivelog all delete input;

allocate channel ch3 device type disk ;
backup as copy current controlfile format 
'd:\oracle\rman_sicherungen\controlfilebackups\controlfilecopy_%d_%U.ctl';





release channel ch1;
release channel ch2;
release channel ch3;
}

#############################

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>
  • Re: [Networker] oracle backup querry, Helmar Pabst <=