Restore dari Offline Backup

Berikut ini step-step restore dengan memakai instance yang sama.

1. Siapkan file-file yang akan direstore File-file tersebut adalah control, log, data, dan temp file
2. Pastikan instance sudah mati

SQL> shutdown immediate;

3. Restore file-file backup ke directory asalnya

$ cp /backup/ts/control01.ctl /oradata/ts/control01.ctl

$ cp /backup/ts/control02.ctl /oradata/ts/control02.ctl

$ cp /backup/ts/control03.ctl /oradata/ts/control03.ctl

$ cp /backup/ts/redo04.log /oradata/ts/redo04.log

$ cp /backup/ts/redo05.log /oradata/ts/redo05.log

$ cp /backup/ts/redo06.log /oradata/ts/redo06.log

$ cp /backup/ts/sysaux01.dbf /oradata/ts/sysaux01.dbf

$ cp /backup/ts/system01.dbf /oradata/ts/system01.dbf

$ cp /backup/ts/temp01.dbf /oradata/ts/temp01.dbf

$ cp /backup/ts/undotbs01.dbf /oradata/ts/undotbs01.dbf

$ cp /backup/ts/users01.dbf /oradata/ts/users01.dbf

4. Nyalakan databaseSQL> startup;

Jika karena suatu hal, tidak bisa dilakukan restore ke direktori asalnya, maka bisa dilakukan restore ke tempat (direktori) lain. Step 1 dan 2 masih seperti yang di atas. Step 3 dan seterusnya adalah berikut ini:

1. Siapkan file-file yang akan direstore File-file tersebut adalah control, log, data, dan temp file

2. Pastikan instance sudah mati

SQL> shutdown immediate;

3. Restore ke directory baru Control file

$ cp /backup/ts/control01.ctl /newdir/ts/control01.ctl

$ cp /backup/ts/control02.ctl /newdir/ts/control02.ctl

$ cp /backup/ts/control03.ctl /newdir/ts/control03.ctlLog file

$ cp /backup/ts/redo04.log /newdir/ts/redo04.log

$ cp /backup/ts/redo05.log /newdir/ts/redo05.log

$ cp /backup/ts/redo06.log /newdir/ts/redo06.logData file

$ cp /backup/ts/sysaux01.dbf /newdir/ts/sysaux01.dbf

$ cp /backup/ts/system01.dbf /newdir/ts/system01.dbf

$ cp /backup/ts/undotbs01.dbf /newdir/ts/undotbs01.dbf

$ cp /backup/ts/users01.dbf /newdir/ts/users01.dbfTemp file

$ cp /backup/ts/temp01.dbf /newdir/ts/temp01.dbf

4. Ubah konfigurasi control file. Edit init (instance parameter) file.

Filenya di $ORACLE_HOME/dbs/init[NAMAINSTANCE].ora

Ganti lokasi control file dari yang lama ke yang baru.

Value yang lama:

control_files='/oradata/ts/control01.ctl', '/oradata/ts/control02.ctl','/oradata/ts/control03.ctl'Value yang baru:

control_files='/newdir/ts/control01.ctl', '/newdir/ts/control02.ctl','/newdir/ts/control03.ctl'

5. Ubah konfigurasi file yang lainnya (log, data, dan temp file)
   SQL> startup mountSQL> alter database rename file '/oradata/ts/redo04.log' to '/newdir/ts/redo04.log';
SQL> alter database rename file '/oradata/ts/sysaux01.dbf' to '/newdir/ts/sysaux01.dbf';
SQL> alter database rename file '/oradata/ts/temp01.dbf' to '/newdir/ts/temp01.dbf';
dan seterusnya ...
6. Open database

SQL> alter database open;

Error yang terkait

1. Jika control file tidak ada, atau ada tapi direktorinya berubah dan init file belum diedit

SQL> startup

ORACLE instance started.Total System Global Area 1610612736 bytes

Fixed Size 2177912 bytes

Variable Size 396149896 bytes

Database Buffers 1207959552 bytes

Redo Buffers 4325376 bytes

ORA-00205: error in identifying control file, check alert log for more info

2. Jika ada data file yang kelewatan, atau ada tapi direktorinya berubah dan belum di-alter/rename
   SQL> startup

ORACLE instance started.Total System Global Area 1610612736 bytes

Fixed Size 2177912 bytes

Variable Size 396149896 bytes

Database Buffers 1207959552 bytes

Redo Buffers 4325376 bytes

Database mounted.

ORA-01157: cannot identify/lock data file 4 - see DBWR trace file

ORA-01110: data file 4: '/oradata/ts/users01.dbf'