Hey all,

Doing some testing with NMO and Oracle 9i.  Legato documentation is pretty
weak on creating solid RMAN backup and recovery scripts (for instance, a
sample script to backup a database is given but only a sample script to
restore a table is provided.)

Does anyone have any example scripts that they've used for RMAN backups and
recoveries?

Backup:
--------------------------------------------
set echo on;
connect target <user>/<password>@<database>;
run {
allocate channel tape01 type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=<nwservername>,NSR_DATA_VOLUME_POOL=<pool>)';
configure controlfile autobackup on;
configure controlfile autobackup format for device type 'SBT_TAPE' to
'/controlfile_%d_%f/'
backup full database plus archivelog tag = 'full' format '/full_%d_%u/'
force;
release channel tape01;
}

Recovery:
--------------------------------------------
In the process of building one/some.



--Shannon L. Ward

--
Note: To sign off this list, send a "signoff networker" command via email
to listserv AT listmail.temple DOT edu or visit the list's Web site at
http://listmail.temple.edu/archives/networker.html where you can
also view and post messages to the list.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=