Step ini dapat digunakan jika terdapat kondisi: Memulihkan backup di server yang baru, dan control file yang dimiliki rusak atau hilang
RMAN> SET DBID 12345;
RMAN> STARTUP NOMOUNT;
RMAN> RESTORE CONTROLFILE FROM "/backup/rman/ctl_c-12345-20141003-03";
RMAN> ALTER DATABASE MOUNT;
RMAN> RESTORE CONTROLFILE FROM TAG 'WEEKLY_FULL_BKUP';
RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP;
2. Memulihkan database
Anda dapat memulihkan database secara default dengan cara
RMAN> restore database;
Tapi sedang menemukan error ini
 |
| Gambar 1. error restore database |
Oleh karena itu berikut step yang benar
a. close rman terlebih dahulu
b. masuk ke rman dengan seperti ini
-bash-4.1$ rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Tue Nov 14 11:11:13 2017
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
c. Selanjutnya mount database, kondisi database jalan
RMAN> startup nomount;
Oracle instance started
Total System Global Area 784334848 bytes
Fixed Size 2929304 bytes
Variable Size 541068648 bytes
Database Buffers 234881024 bytes
Redo Buffers 5455872 bytes
RMAN> startup mount
database is already started
database mounted
d. Selanjutnya jalankan kembali step awal tadi, voila sudah selesai
 |
| Gambar 2. Restore database berhasil |
3. Jika anda melakukan step 1 atau memulihkan control file. Anda perlu melakukan
RMAN> RECOVER DATABASE;
RMAN> ALTER DATABASE OPEN RESETLOGS;
4. Anda juga dapat memulihkan tablespace sebelumnya dengan cara
RMAN> RESTORE TABLESPACE DIMAS_TABLESPACE;
Starting restore at 14-NOV-17
using channel ORA_DISK_1
skipping datafile 2; already restored to file /u01/app/oracle/product/12.1.0.2/db_1/dbs/dimas01
restore not done; all files read only, offline, or already restored
Finished restore at 14-NOV-17
5. Setelah anda melakukan restore anda dapat melakukan recover
RMAN> RECOVER DATABASE;
Starting recover at 14-NOV-17
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:01
Finished recover at 14-NOV-17
6. Anda juga dapat melakukan restore dengan database file
RMAN> RESTORE DATAFILE '/u01/app/oracle/oradata/cdb1/system01.dbf' ;
Starting restore at 14-NOV-17
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=21 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/cdb1/system01.dbf
channel ORA_DISK_1: reading from backup piece /backup/rman/full_devdb_bk_0vsjhmvu_31_1
channel ORA_DISK_1: piece handle=/backup/rman/full_devdb_bk_0vsjhmvu_31_1 tag=TAG20171114T102046
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:15
Finished restore at 14-NOV-17
Selanjutnya anda dapat melakukan recover
RMAN> RECOVER DATAFILE '/u01/app/oracle/oradata/cdb1/system01.dbf';
Starting recover at 14-NOV-17
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:00
Finished recover at 14-NOV-17