| SNAP SHOT for Oracle System datasets [message #113772] |
Fri, 16 November 2001 11:58  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
