HOME → Manual Cold Backups with RMAN

Taken from 'Portable DBA Oracle'

ISBN: 0-07-222980-2
Chapter 11, Pages 240-241

Manual Cold Backups with RMAN

1. Start RMAN from the command prompt:

   Rman target =/

2. Perform a checkpoint on the database (optional, but this can reduce the overall outage):

   RMAN>SQL 'ALTER SYSTEM CHECKPOINT';

3. Shut down the database, and then mount it from RMAN:

   RMAN>SHUTDOWN IMMEDIATE
   RMAN>STARTUP MOUNT

4. Back up the database and archived redo logs. Also back up the control file after the backup: Oracle 9i and Oracle Database 10g is not using a flash recovery area:

   RMAN>BACKUP DATABASE FORMAT 'c:\oracle\dbbackup\back_%U.dbf' PLUS ARCHIVELOG;
   RMAN>BACKUP CURRENT CONTROLFILE FORMAT 'c:\oracle\dbbackup\back_ctl_%U.dbf';

   If using a flash recover area in Oracle Database 10g and later (RMAN in Oracle Database 10g uses a configured flash recovery area by default):

   RMAN>BACKUP DATABASE PLUS ARCHIVELOG;
   RMAN>BACKUP CURRENT CONTROLFILE;

5. Open the database:

   RMAN>SQL 'ALTER DATABASE OPEN';

6. Exit RMAN; your backup is complete.