1. connect as admin -> connect / as sysdba
2. Shutdown the instance -> shutdown IMMEDIATE/NORMAL/TRANSACTIONAL
3. Copy all necessary files -> This is operating system level copy. Data files, Control files, Redolog files, password file, and paramater files must be included
4. Restart the instance -> Startup
If this is a clean restore, procedure is as simple as its backup.
1. connect as admin -> connect / as sysdba
2. Shutdown the instance -> shutdown IMMEDIATE/NORMAL/TRANSACTIONAL
3. Copy all necessary files back into the original place
4. Restart the instance -> Startup
|