[10/08] 정리

fail 

장애 발생시

1. alert log trace 장애 진단 어떤 유형의 장애?

2. restore scn 101 

3. recover scn 147 동기화

4. archive && online redo log 

5. complete recovery

디스크 손상

SYS@orcl>!vi dd.sql

SYS@orcl>!vi reco_scan.sql

disk access x

  1  create table recover_test (id number(10), create_date date default sysdate)

  2* tablespace users

SYS@orcl>/

Table created.

SYS@orcl>insert into recover_test (id) values (1000);

1 row created.

SYS@orcl>commit;

Commit complete.

SYS@orcl>alter system switch logfile;

System altered.

SYS@orcl>alter system checkpoint;

System altered.

SYS@orcl>insert into recover_test (id) values (1000);

1 row created.

SYS@orcl>commit;

Commit complete.

SYS@orcl>alter system switch logfile;

System altered.

SYS@orcl>alter system checkpoint;

System altered.

SYS@orcl>insert into recover_test (id) values (1000);

1 row created.

SYS@orcl>commit;

Commit complete.

SYS@orcl>alter system switch logfile;

System altered.

SYS@orcl>alter system checkpoint;

System altered.

SYS@orcl>!rm /u01/app/oracle/oradata/orcl/users01.dbf

SYS@orcl>@reco_scan.sql

no rows selected

SYS@orcl>@reco_scan.sql

no rows selected

SYS@orcl>select file#, error from v$recover_file;

no rows selected

SYS@orcl>select archive_name from v$recovery_log;

no rows selected

SYS@orcl>alter tablespace users offline;

alter tablespace users offline

*

ERROR at line 1:

ORA-01116: error in opening database file 4

ORA-01110: data file 4: '/u01/app/oracle/oradata/orcl/users01.dbf'

ORA-27041: unable to open file

Linux Error: 2: No such file or directory

Additional information: 3

SYS@orcl>alter tablespace users offline immediate;

Tablespace altered.

SYS@orcl>!cp  /BACKUP/close/users01.dbf    /u01/app/oracle/oradata/orcl/

SYS@orcl>recover tablespace users;

ORA-00279: change 913028 generated at 10/10/2015 09:31:07 needed for thread 1

ORA-00289: suggestion : /ARC/ORCL_892658623_1_12.arc

ORA-00280: change 913028 for thread 1 is in sequence #12

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00279: change 934660 generated at 10/10/2015 11:09:12 needed for thread 1

ORA-00289: suggestion : /ARC/ORCL_892658623_1_13.arc

ORA-00280: change 934660 for thread 1 is in sequence #13

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

auto

ORA-00279: change 973170 generated at 10/12/2015 08:17:43 needed for thread 1

ORA-00289: suggestion : /ARC/ORCL_892658623_1_14.arc

ORA-00280: change 973170 for thread 1 is in sequence #14

Log applied.

Media recovery complete.

SYS@orcl>alter tablespace users online;

Tablespace altered.

SYS@orcl>select * from recover_test;

        ID CREATE_DA

---------- ---------

      1000 12-OCT-15

      1000 12-OCT-15

      1000 12-OCT-15