Home » Infrastructure » Other Operating Systems » SNAP SHOT for Oracle System datasets
SNAP SHOT for Oracle System datasets [message #113772] Fri, 16 November 2001 11:58 Go to next message
Pablo Campanini
Messages: 13
Registered: January 2001
Junior Member
I am testing SNAP SHOT on Oracle datasets (Application VSAM files, and module
SIBBATCH for SNAP SHOT).
I first run an ALTER TABLESPACE XXX BEGIN BACKUP command, then I run the SNAP
SHOT step for all the Application data VSAM datasets, and finally a third step
to ALTER TABLESPACE xxx END BACKUP.
Question is:
I also need to SNAP SHOT Oracle SYSTEM VSAM datasets, so I am including in the
SNAP SHOT step (so it can be in SYNC with the Appl. data), but DO I ALTER THE
SYSTEM TABLESPACE BEGIN BACKUP????? or any other Oracle SYSTEM datasets??? or
how do I SNAP SHOT the SYSTEM datasets??
Please help
Re: SNAP SHOT for Oracle System datasets [message #113775 is a reply to message #113772] Mon, 19 November 2001 09:05 Go to previous message
John Jones
Messages: 6
Registered: March 2001
Junior Member
: I am testing SNAP SHOT on Oracle datasets (Application VSAM files, and module
: SIBBATCH for SNAP SHOT).
: I first run an ALTER TABLESPACE XXX BEGIN BACKUP command, then I run the SNAP
: SHOT step for all the Application data VSAM datasets, and finally a third step
: to ALTER TABLESPACE xxx END BACKUP.
: Question is:
: I also need to SNAP SHOT Oracle SYSTEM VSAM datasets, so I am including in the
: SNAP SHOT step (so it can be in SYNC with the Appl. data), but DO I ALTER THE
: SYSTEM TABLESPACE BEGIN BACKUP????? or any other Oracle SYSTEM datasets??? or
: how do I SNAP SHOT the SYSTEM datasets??
: Please help

Hi Pablo,
Our script generates a BEGIN BACKUP and END BACKUP for every tablespace in DBA_DATA_FILES. This includes SYSTEM.

CONNECT INTERNAL
SPOOL /DSN/'ORACLE.ORAP.BEGALL'
SELECT DISTINCT 'ALTER TABLESPACE '||TABLESPACE_NAME||' BEGIN BACKUP;'
FROM DBA_DATA_FILES;
SPOOL OFF
EXIT

The usual caveat applies, create the backup and test recovery to ensure all the scripts, steps, etc. are OK.
John
Previous Topic: Sending e-mail's with a database procedure
Next Topic: Converting Oracle to DB2
Goto Forum:
  


Current Time: Fri Oct 24 18:30:24 CDT 2014

Total time taken to generate the page: 0.07882 seconds