[TIBERO] HOT Backup & Recovery

Backup 1. HOT Backup 1.1 begin backup alter system switch logfile; alter database begin backup; 1.2 datafile copy - archive_log도 copy 해두기 1.3 endbackup alter database end backup / alter system switch logfile / alter system switch logfile / alter system switch logfile / alter database backup controlfile to trace as 'C:/tibero/con_bak_20221110.sql'; Recovery 1. 데이터 정합성이나, file삭제 이슈로 Online Backup ..

• format_list_bulleted Database/Tibero
• · 2022. 11. 10.
• textsms

[ORACLE] RMAN Recovery (Control file, Spfile, datafile 모두 유실)

1. Full backup 본으로 Recovery 수행 1) backup list 확인 RMAN> list backupset; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 9 Full 346.03M DISK 00:00:36 13-JUN-22 BP Key: 9 Status: AVAILABLE Compressed: YES Tag: TAG20220613T111152 Piece Name: /home/oracle/rman_backup/dbf_090vuovo_1..

• format_list_bulleted Database/Oracle
• · 2022. 6. 13.
• textsms

[ORACLE] RMAN Recovery (Datafile 삭제되었을 경우)

1. Fullbackup 본으로 Recovery 수행 1) backup list 확인 RMAN> list backupset; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 9 Full 346.03M DISK 00:00:36 13-JUN-22 BP Key: 9 Status: AVAILABLE Compressed: YES Tag: TAG20220613T111152 Piece Name: /home/oracle/rman_backup/dbf_090vuovo_1_..

• format_list_bulleted Database/Oracle
• · 2022. 6. 13.
• textsms

[ORACLE] Control file Bakcup&Recovery

1. Controlfile Backup #Controlfile Backup Trace 형식 백업 alter database backup controlfile to trace as '/home/oracle/con_bak/c1.trc'; -> 재생성 스크립트가 생성 된다 . Binary 형식 백업 alter database backup controlfile to '/home/oracle/con_bak/c1.bkg.20220603'; 2. 테스트 시나리오 이중화된 Controlfile 포함하여 전부 유실됬을 때 상황1. 운영중 controlfile 삭제됨 1. Controlfile 유실로 인해 정상적인 Shutdown 불가 2. shutdown abort 3. startup nomount 4. trace 백업..

• format_list_bulleted Database/Oracle
• · 2022. 6. 3.
• textsms