p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Oracle (http://p2p.wrox.com/forumdisplay.php?f=105)
-   -   Cold Backup & RMAN (http://p2p.wrox.com/showthread.php?t=4816)

Walden October 10th, 2003 06:43 AM

Cold Backup & RMAN
 
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

tamtekin October 13th, 2003 04:48 PM

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



All times are GMT -4. The time now is 09:32 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.