Thursday, April 16, 2009

USER MANAGED whole database BACKUP

USER MANAGED whole database BACKUP

1- Compilation (check the location of datafiles,controlfiles and log files)
2- Shutdown normal / immediate / transactional
3- Copy all required files to backup location
4- Open the database (Startup)
OPEN DATABASE BACKUP
1- Compilation
2- ALTER TABLESPACE SYSTEM BEGIN BACKUP
3- Copy all system tablespace related files to Backup Folder
4- ALTER TABLESPACE SYSTEM END BACKUP
5- ALTER SYSTEM SWITCH LOGFILE

1 comment:

Unknown said...

Sir Thanks for providing such Simple and Easy Steps to follow which in turn help students alot .
THANKS.