안녕? 나야 :)

■ 복제 Database 운영 data file, redo log file을 이용해서 DB를 생성 # backup 본 위치 확인 [oracle1@oracle ~]$ cd backup/arch/cold_20240117 [oracle1@oracle cold_20240117]$ ls backup.log data01.dbf insa_tbs01.dbf redo09.log temp01.dbf backup.sh example01.dbf redo07.log sysaux01.dbf undo01.dbf control01.ctl initora11g_20240117.ora redo08.log system01.dbf users01.dbf [oracle1@oracle cold_20240117]$ pwd /home/oracle1/..

# 테이블 스페이스 생성 SQL> create tablespace insa_tbs datafile '/u01/app/oracle/oradata/ora11g/insa_tbs01.dbf' size 10m autoextend on next 1m maxsize 20m extent management local uniform size 1m segment space management auto; # 확인 select a.file#, a.name file_name, b.name file_name, b.name tbs_name, a.status, a.checkpoint_change# from v$datafile a, v$tablespace b where a.ts# = b.ts#; # trace 생성 SQL> alter..

SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC ---------- ---------- ---------- ---------- ---------- ---------- --- STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME ---------------- ------------- --------- ------------ --------- 7 1 1 104857600 512 1 NO CURRENT 837442 18-JAN-24 2.8147E+14 8 1 0 104857600 512 1 YES UNUSED 0 0 9 1 0 104857600 512 1 YES UNUSED ..

SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC ---------- ---------- ---------- ---------- ---------- ---------- --- STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME ---------------- ------------- --------- ------------ --------- 7 1 1 104857600 512 1 NO CURRENT 834109 18-JAN-24 2.8147E+14 8 1 0 104857600 512 1 YES UNUSED 0 0 9 1 0 104857600 512 1 YES UNUSED ..

1. 테이블 생성 create table hr.new_202401 as select * from hr.employees; 2) 조회 SELECT f.file_name FROM dba_extents e, dba_data_files f WHERE f.file_id = e.file_id AND e.segment_name = 'NEW_202401' AND e.owner='HR'; => users01 TBS에 저장됨 2. 장애발생 SQL> ! rm /home/oracle/arch1/*.* SQL> ! rm /home/oracle/arch2/*.* SQL> ! rm /u01/app/oracle/oradata/ora11g/users01.dbf --> user01 TBS, 아카이브정보 삭제 3. 가정) 업무때문에 DB..

[oracle1@oracle ~]$ cd arch1 [oracle1@oracle arch1]$ ls arch_1_1_1158542235.arc arch_1_3_1158542235.arc arch_1_5_1158542235.arc arch_1_2_1158542235.arc arch_1_4_1158542235.arc arch_1_6_1158542235.arc [oracle1@oracle arch1]$ rm *.* [oracle1@oracle arch1]$ ls SQL> select * from v$log; SQL> select a.file#, a.name file_name, b.name file_name, b.name tbs_name, a.status, a.checkpoint_change# from v$da..

=> 백업 완료 SQL> select * from v$log; SQL> select a.file#, a.name file_name, b.name file_name, b.name tbs_name, a.status, a.checkpoint_change# from v$datafile a, v$tablespace b where a.ts# = b.ts#; SQL> drop table hr.emp_50 purge; SQL> create table hr.emp_50 as select * from hr.employees where department_id = 50; SQL> select count(*) from hr.emp_50; SQL> select * from v$log; SQL> alter system switc..

[oracle1@oracle cold_20240117]$ ls [oracle1@oracle cold_20240117]$ pwd /home/oracle1/backup/arch/cold_20240117/ SQL> select * from v$log; SQL> select a.file#, a.name file_name, b.name file_name, b.name tbs_name, a.status, a.checkpoint_change# from v$datafile a, v$tablespace b where a.ts# = b.ts#; SQL> create table hr.emp_50 as select * from hr.employees where department_id = 50; SQL> select coun..

SQL> select * from v$log; select a.file#, a.name file_name, b.name file_name, b.name tbs_name, a.status, a.checkpoint_change# from v$datafile a, v$tablespace b where a.ts# = b.ts#; # 테이블 생성 및 확인 SQL> create table hr.emp_30 as select * from hr.employees where department_id = 30; SQL> select count(*) from hr.emp_30; # 장애 발생 # => control01.ctl 지우기, log switch 발생 SQL> ! rm /u01/app/oracle/oradata/or..

select * from v$datafile; select * from v$log; => 백업 이후의 아카이브 확인 select * from v$logfile; select a.file#, a.name, a.checkpoint_change#, b.status, b.change#, b.time from v$datafile a, v$backup b where a.file# = b.file#; select name from v$controlfile; S! ls /home/oracle1/arch1 SQL> create table hr.emp_20 as select * from hr.employees where department_id = 20; Table created. SQL> select count(*) f..