–##::MANAGEMENT UNTUK BACKUP AND RECOVERY SISTEM::##–
–> yang perlu di perhatikan dalam backup dan recovery yaitu :
- control file, redo log grup, dan archivelog
- kita minimal harus memiliki 2 controlfile,
- pada masisng2 redolog grub, minimal harus memiliki 2 di masing2 redolog grub
- seting enable pada archivelog, dan tambahkan 1 dir lagi untuk backup archive log. dengan format .dbf
misal di : /u01/app/oracle/backup

.::##CREATE CONTROLFILE BARU##::.
–> lihat control file dan letak control file
SQL> select * from v$controlfile;

STATUS
——-
NAME
——————————————————————————–
IS_ BLOCK_SIZE FILE_SIZE_BLKS
— ———- ————–

/u01/app/oracle/oradata/ORCL/controlfile/o1_mf_42tqms1d_.ctl
NO 16384 430

/u01/app/oracle/flash_recovery_area/ORCL/controlfile/o1_mf_42tqmsc1_.ctl
YES 16384 430

–> matikan database
SQL> shut immediate

–> nyalakan database dalam keadaan no mount
SQL> startup nomount

–> copykan file controlfile, ke dir yang sudah kita buat untuk backup
[oracle@oracle3 ~]$ cd /u01/app/oracle/oradata/ORCL/controlfile/
[oracle@oracle3 controlfile]$ ls
o1_mf_42tqms1d_.ctl
[oracle@oracle3 controlfile]$ mkdir /u01/app/oracle/backup
[oracle@oracle3 controlfile]$ cp /u01/app/oracle/oradata/ORCL/controlfile/o1_mf_42tqms1d_.ctl /u01/app/oracle/backup/control01.ctl

–> seting patch, agar file controlfile kita yang sudah kita dambah tadi di daftarkan sebagai controlfile baru
SQL> alter system set control_files = ‘/u01/app/oracle/flash_recovery_area/ORCL/controlfile/o1_mf_42tqmsc1_.ctl’,'/u01/app/oracle/oradata/ORCL/controlfile/o1_mf_42tqms1d_.ctl’,'/u01/app/oracle/backup/control01.ctl’ scope=spfile;

–> nyalakan database dalam keadaan mount
SQL> alter database mount;

–> nyalakan database dalam keadaan open
SQL> alter database open;
SQL> select * from v$controlfile;

.::##CREATE REDOLOG MENGGUNAKAN EM##::.
–> pada menu administration -> Database Administration -> Storage -> Redo Log Groups -> create grup pertama lalu pilih edit dan -> add ->
file name : redo0101.log
file directory : /u01/app/oracle/backup
lakukan ke semua grup

–> TEMPAT FILE REDOLOG GRUB
/u01/app/oracle/oradata/ORCL/onlinelog/
/u01/app/oracle/flash_recovery_area/ORCL/onlinelog/

–> AKTIFKAN ARCHIVELOG Mode
pada menu -> Related Links -> Advisor Central -> MTTR Advisor ->
centang pada pilihan ARCHIVELOG Mode*

–##::MANAGEMENT UNTUK BACKUP AND RECOVERY DATA::##–
–> BACKUP SETING
Menggunakan EM
maintenance > high avaliable > backup/recofery seting > BACKUP SETING
–> Disk Backup Location : /u01/app/oracle/flash_recovery_area
masukan username dan password
click : test disk backup
dan click ok

–> ARCHIVELOG
maintenance > high avaliable > backup/recofery seting > Recovery Settings
–> centang pada pilihan : ARCHIVELOG Mode*
Number Archive Log Destination
1 /u01/app/oracle/backup

–> SETING SCHEDULE BACKUP
maintenance > high avaliable > backup/recofery > Schedule Backup
–> pilih : Whole Database
- masukan username dan password
- click scedule costumized backup
- click Full Backup pada Backup Type, dan centang Use as the base of an incremental backup strategy
- select Online Backup pada Backup Mode,
- select Also back up all archived logs on disk pada Advanced NEXT
- pilih disk NEXT
- dan pada pilihan terakhir biarkan default semuanya + submit job + view job

–> SETING SCHEDULE BACKUP NEXT
maintenance > high avaliable > backup/recofery > Schedule Backup
–> pilih : Whole Database
- masukan username dan password
- click scedule costumized backup
- click Incremental Backup (Level 1) pada Backup Type
- * Job Name : Nightly_Backup
Start : pilih Later pilih date and time 11.00 pm
Repeat : pilih Interval pilih Frequency : 1 weeks
Repeat Until : Indefinite

–> RECOFERY DATAFILE
maintenance > high avaliable > backup/recofery > Perform Recovery
- Object Type : data file
Operation Type : Recover to current time
masukan : username dan password + next
- select : data file yang ingin anda restore
pilih : No. restore the files to the default location + next
- Submit

–> CARA RESTORE CONTROL FILE
sqlplus sys as sysdba
–lihat status database
SQL> select status from v$instance;
–testing apakah database bisa di mount
SQL> alter database mount;
–lihat apa yang membuat eror oracle
SQL> host tail -20 $ORACLE_BASE/admin/orcl/bdump/aler*
–ORA-00202: control file: ‘/u01/app/oracle/oradata/ORCL/controlfile/o1_mf_42tqms1d_.ctl’
–masuk lagi ke sys
–matikan database
SQL> shutdown immediate
exit
–copykan file yang eror tadi sesuai dengan file control file yang hilang
–catatan : copy file control file dalam keadaan database mati
$ cp /u01/app/oracle/flash_recovery_area/ORCL/controlfile/o1_mf_42tqmsc1_.ctl /u01/app/oracle/oradata/ORCL/controlfile/o1_mf_42tqms1d_.ctl
SQL> startup

–> CARA RESTORE LOG FILE
sama seperti di atas
ORA-00312: online log 2 thread 1: ‘/u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_2_42tqn0qn_.log’
$ cp /u01/app/oracle/flash_recovery_area/ORCL/onlinelog/o1_mf_2_42tqn2×6_.log /u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_2_42tqn0qn_.log

–> RECOFERY DATAFILE
SQL> @lab_16_03.sql
SQL> select count(*) from hr.countries;
maintenance > high avaliable > backup/recofery > Perform Recovery
- Object Type : data file
Operation Type : Recover to current time
masukan : username dan password + next
- select : data file yang ingin anda restore
pilih : No. restore the files to the default location + next
- Submit