RMAN REFERENCE 2

=======================================
RESTORE CONTROL FILE
=======================================
Untuk mengembalikan control file yang hilang atau rusak,
shutdown dulu database lalu hapus semua control file yang ada.
SQL> STARTUP FORCE;

RMAN> STARTUP NOMOUNT FORCE;
RMAN> SET DBID 343333333;  ==> DBID DIKETAHUI SAAT koneksi ke 
                               target melalui RMAN
RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP;
atau

RMAN> RESTORE CONTROLFILE FROM 'D:\ORACLE\backup
      \control_pajak_239534.bkp';
RMAN> ALTER DATABASE MOUNT;
RMAN> RESTORE DATABASE;
RMAN> RECOVER DATABASE;
RMAN> ALTER DATABASE OPEN RESETLOGS;


RMAN> RESTORE SPFILE FROM 'D:\ORACLE\backup\spfile_pajak_239534.bkp';



========================================
ENABLE BLOCK CHANGE TRACKING
=========================================
Kegunaan dari Block Change Tracking adalah untuk 
mempercepat proses Incremental Backup
SQL> SHOW PARAMETER DB_CREATE_FILE_DEST;
SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
atau jika tidak memakai OMF
SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE 
     'D:\ORACLE\PRODUCT\10.2.0\ORADATA\PAJAK\BLOCK_CHG_TRC.ORA';
SQL> SELECT status,filename,bytes FROM v$block_change_tracking;


==========================================
BACKUP INCREMENTAL
========================================
RMAN> BACKUP INCREMENTAL LEVEL 0 TAG 'incr_update' database;
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY TAG 
      'incr_update' database;

klausa FOR RECOVER OF COPY TAG.. berarti incremental level 1 
akan mencari backup level 0 dgn tag 'incr_update.
jika ditemukan maka akan backup secara incremental dgn level 1.

RMAN> RECOVER COPY OF DATABASE WITH TAG 'incr_update';

RMAN> RESTORE DATAFILE 1;
RMAN> RECOVER TABLESPACE SYSTEM;

RMAN> BACKUP DATAFILE 1,4;