My original question follows:
> Managers,
>
> We are new Oracle users & I am looking at setting hot & cold backups for
> Oracle using NetWorker Save & Restore (NSR) 4.2A. I was wondering if
> anyone out there had a sample script that is executed by using the
"Backup
> command:" field in the client setup they would be willing to share.
>
Sorry for the late summary, but I received no responses with any
information, only others requesting any info be passed along. After some
thought, I came to the conclusion that executing a script from the "Backup
command:" field may not work in my case because the data files for one
tablespace are on multiple file sets. I ended up writing a hot backup
script, executed from cron, that follows the following basic procedure:
For tablespace perform the following:
alter tablespace NAME begin backup;
perform backup using NSR save command
alter tablespace NAME end backup;
Backup the control file
Switch logfile
Backup the archives
Stop logging
Perform backup using NSR save command
Start logging
Switch logfile (verify logging is working OK)
Backup Oracle admin files
I also wrote a cold backup script as follows:
Shutdown the database
Backup the tablespaces, log files, control files & archive files
Backup Oracle admin files
Startup the database
I have not yet tested the cold backup. Oracle was installed for use by a
third party application & I am waiting for the DBA for that company to tell
me it is OK to shutdown the DB. He wanted it up for a while to get
statistics.
[=================================
[ Randy Rodgers
[ rrodgers_at_fwi.com
[ System Administrator
[ Allen County/City of Fort Wayne
[ Information Systems
[ (219)449-7660
[=================================
Received on Wed Mar 05 1997 - 14:58:04 NZDT