주 콘텐츠로 건너뛰기

검색

Welcome to Tibero GTS!

DROP TABLE 명령으로 삭제된 테이블 복구 예제 (2)

문서유형ㅣ기술정보

분야ㅣ백업/복구

문서번호ㅣTBATI032

 

개요

삭제된 테이블을 RECYCLEBIN을 이용해 복구하고 상태를 확인합니다.
 

실행 순서

  1. 테이블 복구
  2. RECYCLEBIN 조회
  3. 오브젝트 조회
  4. 복구 테이블조회
 
 

방법

1. 테이블 복구
SQL> FLASHBACK TABLE EDU.T100 TO BEFORE DROP;
Flashbacked.

2. RECYCLEBIN 조회
SQL> COL OWNER FOR A10
SQL> COL TS_NAME FOR A10
SQL> SELECT OWNER, OBJECT_NAME, TYPE, TS_NAME, DROPTIME FROM DBA_RECYCLEBIN WHERE ORIGINAL_NAME='T100';

0 row selected.

3. 오브젝트 조회
SQL> CONN SYS/TIBERO
Connected to Tibero.

SQL>
SQL> COL TABLE_NAME FOR A20
SQL> SELECT TABLE_NAME FROM DBA_TABLES WHERE TABLESPACE_NAME='TBS_EDU' ORDER BY TABLE_NAME;

TABLE_NAME
------------------------
T10
T100

2 rows selected.

SQL>
SQL> COL TABLE_NAME FOR A20
SQL> COL INDEX_NAME FOR A20
SQL> SELECT TABLE_NAME, INDEX_NAME, STATUS FROM DBA_INDEXES WHERE TABLESPACE_NAME='TBS_EDU' ORDER BY TABLE_NAME,INDEX_NAME;

TABLE_NAME  INDEX_NAME      STATUS
----------  --------------  -------
T10         PK_T10          VALID
T100        EDU_IDX285700   VALID
T100        EDU_IDX285800   VALID

3 rows selected.

SQL>
SQL> COL OBJECT_NAME FOR A20 SQL> COL OBJECT_TYPE FOR A12
SQL> SELECT O.OBJECT_NAME,O.OBJECT_TYPE, O.OBJECT_ID, O.STATUS
       2 FROM DBA_OBJECTS O
       3 WHERE O.OWNER='EDU'
       4 ORDER BY O.STATUS, O.OBJECT_TYPE, OBJECT_NAME;

OBJECT_NAME      OBJECT_TYPE   OBJECT_ID   STATUS
---------------  ------------  ----------  -------
EDU_IDX285700    INDEX         2857        VALID
EDU_IDX285800    INDEX         2858        VALID
PK_T10           INDEX         2855        VALID
T10              TABLE         2854        VALID
T100             TABLE         2856        VALID

5 rows selected.

SQL>
SQL> SET LINESIZE 120
SQL> COL CONSTRAINT_NAME FOR A22
SQL> COL TABLE_NAME FOR A20
SQL> COL INDEX_NAME FOR A20
SQL> SELECT CONSTRAINT_NAME, CON_TYPE, STATUS, TABLE_NAME, INDEX_NAME FROM DBA_CONSTRAINTS WHERE OWNER='EDU';

CONSTRAINT_NAME     CON_TYPE      STATUS    TABLE_NAME   INDEX_NAME
------------------  ------------  --------  -----------  ----------------
PK_T1               PRIMARY KEY   ENABLED   T10          PK_T10
EDU_CON45400856     PRIMARY KEY   ENABLED   T100         EDU_IDX285700
EDU_CON45300010     NOT NULL      ENABLED   T100         

3 rows selected.

4. 복구 테이블 조회
SQL> SELECT * FROM EDU.T100 ORDER BY C1;

   C1     C2  C3
-----  -----  --------
    1      1  TIBERO
    2      2  TIBERO
    3      3  TIBERO
    4      4  TIBERO
    5      5  TIBERO
    6      6  TIBERO
    7      7  TIBERO
    8      8  TIBERO
    9      9  TIBERO
   10     10  TIBERO
   
10 rows selected.

 

 
 

관련 대상