Page Comparison

...

You can take an online backup while  is still up and running. This backup can be used to restore   in case of a critical failure. The backup will contain a consistent snapshot of the   file system and database at a certain point of time. The snapshot may be used to recover the system to the state it had at the time of the backup.

...

1. Shut down .
    

2. Shut down the Oracle Instance.
    

3. Make a cold backup of the crashed  , including the Oracle instance.
    

4. Locate the backup to restore. That is, a directory containing a full backup and at least one incremental backup. The directory should contain one or several Oracle control files control.<id>, and a snapshot of the  file systemMZFS_<id>.
    

5. Remove all table space files, the corresponding archived redo logs, and control files. If necessary, remove the initMZ.ora file as well, and replace it with the backed up version.
    

6. Make a backup copy of the control files MZ_control1 and MZ_control2.
    

7. Replace the dynamic directories with the corresponding backup directories. An example of a dynamic directory is the storage handler directory, used by the Inter Workflow application.
    

8. Execute the following commands:

   Code Block
   language text theme Eclipse
   $ export BACKUP_DIR=/path_to_backup_to_use $ rman nocatalog RMAN> set dbid = <DBID> RMAN> connect target; RMAN> startup force mount; RMAN> run { RMAN> allocate channel SystemRestore type disk format '$BACKUP_DIR/%U'; RMAN> restore database; RMAN> restore archivelog all; RMAN> } The reply messages are: RMAN-08017: RMAN-08022: RMAN-08510: RMAN-08023: RMAN-08511: RMAN-08024: RMAN-08031: channel SystemRestore: starting archivelog... channel SystemRestore: restoring archivelog archivelog thread=1 sequence=20 channel SystemRestore: restore backup... piece handle=/tmp/backup/0feduv7h_1_1... channel SystemRestore: restore complete released channel: SystemRestore Use the last RMAN-08510 to fill in 'set until logseq NR thread NR' RMAN> run { RMAN> allocate channel SystemRestore type disk format 'BACKUP_DIR/%U'; RMAN> set until logseq 20 thread 1; RMAN> recover database; RMAN> alter database open resetlogs; RMAN>} RMAN> exit;

    

9. Restart the database instance with the following commands:

   Code Block
   language text theme Eclipse
   SQL> shutdown normal SQL> startup

    

10. Start .