Re: [Networker] oracle backup querry
2007-09-12 05:00:36
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 <=
|
|
|