반응형
1. 백업 전, DB 상태확인 (Archive log mode)
Node1, Nod2 Archive log
1) 두 노드 모두 Archive log Mode 확인
2) 두 누드 모두 Archive log file 경로 ASM에 같은 경로를 사용중
ASMCMD> pwd
+DATA/ORCL/ARCHIVELOG_FILE
ASMCMD> ls -alrt
Type Redund Striped Time Sys Name
ARCHIVELOG UNPROT COARSE JUN 13 16:00:00 N 2_3_1095025428.dbf => +DATA/ORCL/ARCHIVELOG/2022_06_13/thread_2_seq_3.281.1107277053
ARCHIVELOG UNPROT COARSE JUN 13 17:00:00 N 1_12_1095025428.dbf => +DATA/ORCL/ARCHIVELOG/2022_06_13/thread_1_seq_12.288.1107278017
ARCHIVELOG UNPROT COARSE JUN 16 14:00:00 N 1_13_1095025428.dbf => +DATA/ORCL/ARCHIVELOG/2022_06_16/thread_1_seq_13.293.1107526843
ARCHIVELOG UNPROT COARSE JUN 16 14:00:00 N 2_4_1095025428.dbf => +DATA/ORCL/ARCHIVELOG/2022_06_16/thread_2_seq_4.289.1107526837
ARCHIVELOG UNPROT COARSE JUN 16 14:00:00 N 2_5_1095025428.dbf => +DATA/ORCL/ARCHIVELOG/2022_06_16/thread_2_seq_5.290.1107526839
ARCHIVELOG UNPROT COARSE JUN 16 14:00:00 N 2_6_1095025428.dbf => +DATA/ORCL/ARCHIVELOG/2022_06_16/thread_2_seq_6.291.1107526841
ARCHIVELOG UNPROT COARSE JUN 16 14:00:00 N 2_7_1095025428.dbf => +DATA/ORCL/ARCHIVELOG/2022_06_16/thread_2_seq_7.292.1107526841
2. 백업
- ORACLE Version : 19c
- CDB, PDB 구조로 설치되어, rman을 통해 database 전체 backup을 받게되면 CDB$ROOT, PDB$SEED, PDB가 전부 백업된다.
RMAN> list backupset;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 303.80M DISK 00:00:32 16-JUN-22
BP Key: 2 Status: AVAILABLE Compressed: YES Tag: TAG20220616T155430
Piece Name: /home/oracle/rman_backup/dbf_021076lm_1_1_20220616
List of Datafiles in backup set 2
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
1 Full 3015369 16-JUN-22 NO +DATA/ORCL/DATAFILE/system.259.1095025267
3 Full 3015369 16-JUN-22 NO +DATA/ORCL/DATAFILE/sysaux.260.1095025303
4 Full 3015369 16-JUN-22 NO +DATA/ORCL/DATAFILE/undotbs1.261.1095025327
7 Full 3015369 16-JUN-22 NO +DATA/ORCL/DATAFILE/users.262.1095025329
9 Full 3015369 16-JUN-22 NO +DATA/ORCL/DATAFILE/undotbs2.271.1095026407
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 121.06M DISK 00:00:13 16-JUN-22
BP Key: 3 Status: AVAILABLE Compressed: YES Tag: TAG20220616T155430
Piece Name: /home/oracle/rman_backup/dbf_031076mq_1_1_20220616
List of Datafiles in backup set 3
Container ID: 3, PDB Name: PDB
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
10 Full 2677722 28-JAN-22 NO +DATA/ORCL/D67D04B961F748DFE0536638A8C021CE/DATAFILE/system.276.1095027437
11 Full 2677722 28-JAN-22 NO +DATA/ORCL/D67D04B961F748DFE0536638A8C021CE/DATAFILE/sysaux.277.1095027437
12 Full 2677722 28-JAN-22 NO +DATA/ORCL/D67D04B961F748DFE0536638A8C021CE/DATAFILE/undotbs1.275.1095027437
13 Full 2677722 28-JAN-22 NO +DATA/ORCL/D67D04B961F748DFE0536638A8C021CE/DATAFILE/undo_2.279.1095027491
14 Full 2677722 28-JAN-22 NO +DATA/ORCL/D67D04B961F748DFE0536638A8C021CE/DATAFILE/users.280.1095027553
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 115.05M DISK 00:00:11 16-JUN-22
BP Key: 4 Status: AVAILABLE Compressed: YES Tag: TAG20220616T155430
Piece Name: /home/oracle/rman_backup/dbf_041076na_1_1_20220616
List of Datafiles in backup set 4
Container ID: 2, PDB Name: PDB$SEED
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
5 Full 2146499 26-JAN-22 NO +DATA/ORCL/86B637B62FE07A65E053F706E80A27CA/DATAFILE/system.267.1095025965
6 Full 2146499 26-JAN-22 NO +DATA/ORCL/86B637B62FE07A65E053F706E80A27CA/DATAFILE/sysaux.268.1095025965
8 Full 2146499 26-JAN-22 NO +DATA/ORCL/86B637B62FE07A65E053F706E80A27CA/DATAFILE/undotbs1.269.1095025965
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Full 18.89M DISK 00:00:01 16-JUN-22
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20220616T155537
Piece Name: /u01/app/oracle/product/19/db_1/dbs/c-1622806160-20220616-00
SPFILE Included: Modification time: 16-JUN-22
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 3015425 Ckp time: 16-JUN-22
3. TEST
-. Test table
1. USERS Tablespace를 사용하는 test123 table에 위와 같이 데이터를 insert
2. alter system switch logfile; -> Archive log file로 떨굼
-. 장애발생
asmcmd로 접속하여 USERS Tablespace 삭제 [데이터 유실이나 정합성이 틀어져 파일을 날렸다고 가정]
ASMCMD> rm USERS.262.1095025329
ASMCMD> ls -alrt
Type Redund Striped Time Sys Name
DATAFILE UNPROT COARSE JUN 16 22:00:00 Y none => SYSAUX.260.1095025303
DATAFILE UNPROT COARSE JUN 16 22:00:00 Y none => SYSTEM.259.1095025267
DATAFILE UNPROT COARSE JUN 16 22:00:00 Y none => UNDOTBS1.261.1095025327
DATAFILE UNPROT COARSE JUN 16 22:00:00 Y none => UNDOTBS2.271.1095026407
4. 복구
1) shutdown abort
2) 1번노드만 mount로 기동
3) rman restore
RMAN> restore database;
Starting restore at 17-JUN-22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=63 instance=orcl1 device type=DISK
skipping datafile 5; already restored to file +DATA/ORCL/86B637B62FE07A65E053F706E80A27CA/DATAFILE/system.267.1095025965
skipping datafile 6; already restored to file +DATA/ORCL/86B637B62FE07A65E053F706E80A27CA/DATAFILE/sysaux.268.1095025965
skipping datafile 8; already restored to file +DATA/ORCL/86B637B62FE07A65E053F706E80A27CA/DATAFILE/undotbs1.269.1095025965
skipping datafile 10; already restored to file +DATA/ORCL/D67D04B961F748DFE0536638A8C021CE/DATAFILE/system.276.1095027437
skipping datafile 11; already restored to file +DATA/ORCL/D67D04B961F748DFE0536638A8C021CE/DATAFILE/sysaux.277.1095027437
skipping datafile 12; already restored to file +DATA/ORCL/D67D04B961F748DFE0536638A8C021CE/DATAFILE/undotbs1.275.1095027437
skipping datafile 13; already restored to file +DATA/ORCL/D67D04B961F748DFE0536638A8C021CE/DATAFILE/undo_2.279.1095027491
skipping datafile 14; already restored to file +DATA/ORCL/D67D04B961F748DFE0536638A8C021CE/DATAFILE/users.280.1095027553
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 +DATA/ORCL/DATAFILE/system.259.1095025267
channel ORA_DISK_1: restoring datafile 00003 to +DATA/ORCL/DATAFILE/sysaux.260.1095025303
channel ORA_DISK_1: restoring datafile 00004 to +DATA/ORCL/DATAFILE/undotbs1.261.1095025327
channel ORA_DISK_1: restoring datafile 00007 to +DATA/ORCL/DATAFILE/users.262.1095025329
channel ORA_DISK_1: restoring datafile 00009 to +DATA/ORCL/DATAFILE/undotbs2.271.1095026407
channel ORA_DISK_1: reading from backup piece /home/oracle/rman_backup/dbf_021076lm_1_1_20220616
channel ORA_DISK_1: piece handle=/home/oracle/rman_backup/dbf_021076lm_1_1_20220616 tag=TAG20220616T155430
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:55
Finished restore at 17-JUN-22
4) recover database;
RMAN> recover database;
Starting recover at 17-JUN-22
using channel ORA_DISK_1
starting media recovery
archived log for thread 1 with sequence 15 is already on disk as file +DATA/orcl/archivelog_file/1_15_1095025428.dbf
archived log for thread 1 with sequence 16 is already on disk as file +DATA/orcl/archivelog_file/1_16_1095025428.dbf
archived log for thread 1 with sequence 17 is already on disk as file +DATA/orcl/archivelog_file/1_17_1095025428.dbf
archived log for thread 1 with sequence 18 is already on disk as file +DATA/orcl/archivelog_file/1_18_1095025428.dbf
archived log for thread 2 with sequence 9 is already on disk as file +DATA/orcl/archivelog_file/2_9_1095025428.dbf
archived log file name=+DATA/orcl/archivelog_file/1_15_1095025428.dbf thread=1 sequence=15
archived log file name=+DATA/orcl/archivelog_file/1_16_1095025428.dbf thread=1 sequence=16
media recovery complete, elapsed time: 00:00:18
Finished recover at 17-JUN-225) alter database open;
6) 2번노드 기동
반응형
'Database > Oracle' 카테고리의 다른 글
| [ORACLE] PAGING 처리 (0) | 2022.08.18 |
|---|---|
| [ORACLE] RAC Patch (0) | 2022.06.27 |
| [ORACLE] ASM 접속 및 용량 조회 (0) | 2022.06.13 |
| [ORACLE] RAC SCAN (0) | 2022.06.13 |
| [ORACLE] RMAN Recovery (Control file, Spfile, datafile 모두 유실) (0) | 2022.06.13 |