I was wondering if anyone out there could help me such as how to take a cold backup and restore it. Also any RMAN scripts to take cold/hot backup as well as to restore them? I would very much be grateful.

Regards,

CarlWalden

__________________
CarlWalden

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