Oracle full database backup script connect target backup username/password @ KFDB2; www.2cto.com connect rcvcat rman/rman @ rman; RUN {allocate channel ch00 TYPE 'sbt _ TAPE '; allocate channel ch01 TYPE 'sbt _ TAPE '; allocate channel ch02 TYPE 'sbt _ TAPE'; allocate channel ch03 TYPE 'sbt _ TAPE '; send 'ns_env = (ns_server = jcyz01, ns_client = nmkfdb2, ns_data_volume
_ POOL = NMKFDB,
Ns_compression = TRUE, ns_saveset_browse = "2 Weeks", ns_saveset _
RETENTION = "2 Weeks", ns_group = nmkf_oracle_full) '; BACKUP incremental level 0 FILESPERSET 4 FORMAT 'dbfull _ % s _ % p _ % t' DATABASE; SQL 'alter system archive log current'; RELEASE CHANNEL ch00; RELEASE CHANNEL ch01; RELEASE CHANNEL ch02; RELEASE CHANNEL ch03; ALLOCATE CHANNEL ch00 TYPE 'sbt _ TAPE '; send 'ns_env = (ns_server = jcyz01, ns_client = nmkfdb2, ns_data _
VOLUME_POOL =
NMKFDB, ns_compression = TRUE, ns_saveset_browse = "2 Weeks", NSR
_ SAVESET_RETENTION = "2 Weeks", ns_group = nmkf_oracle_full) '; backup format 'cntrl _ % s _ % p _ % t' current controlfile; release channel ch00; allocate channel ch00 TYPE 'sbt _ TAPE 'connect 'backup username/password @ kfdb1'; allocate channel ch01 TYPE 'sbt _ TAPE 'connect' backup username/password @ kfdb '; send 'ns_env = (ns_server = jcyz01, ns_data_volume_pool = NMKFDB1,
Ns_compress
ION = TRUE, ns_saveset_browse = "2 Weeks", ns_saveset_retention = "2 Weeks", ns_group = nmkf_oracle_arch )'; BACKUP filesperset 8 FORMAT 'al _ % s _ % p _ % t' archivelog all delete input; release channel ch00; release channel ch01; allocate channel D1 type disk; copy current controlfile to '/app/nsr/RMAN_BAK/KFDB_ctl_full.bak'; release channel D1; host '/app/networker/bin/save-s jcyz01-B NMKFDB-w 2 Weeks-y 2 Weeks/app/nsr/RMAN_BAK/KFDB_ctl_full.bak ';}