火曜日, 7月 13, 2010

Restore database from backup without control files

Restore database from backup without control files

  1. sqlplus /nolog
  2. CONNECT / AS SYSDBA
  3. STARTUP NOMOUNT
  4.    CREATE CONTROLFILE DATABASE orcl NORESETLOGS NOARCHIVE
    MAXLOGFILES 32
    LOGFILE GROUP 1 '/oradata1/orcl/redo01.log' SIZE 500M
    GROUP 2 '/oradata1/orcl/redo02.log' SIZE 500M
    DATAFILE
    '/oradata1/orcl/system01.dbf',
    '/oradata1/orcl/undotbs01.dbf'
    CHARACTER SET us7ascii;
  5. ALTER DATABASE MOUNT;
  6. RECOVER DATABASE USING BACKUP CONTROLFILE;
  7. ALTER DATABASE OPEN;

More About:
Oracle 障害回復 制御ファイル バックアップファイルからの回復
Recover database without control files and redo log files

Oracle database Backup and Recovery FAQ

0 件のコメント: