[10/12] 정리 그리고 실습

이력서 수정 update

실습 정리 update

Touch Count 이제부터..... 줄이기.... 시작 START

====================================================================================

장애 발생 가정하의 복구 수행시에는 항상 백업을 한 후 진행해야 한다.

복구시 필요한건 결국 원본과 아카이브인데 이 두 파일만 잘 관리하면 된다

U-MAN EM에서 안됨

RMAN 기법은 EM에서 됨 구현해봐야 함 이력서 기입 가능

본인이 알고 있는 복구 절차를 기술해봐라

복구 실패시를 대비하기 위해 장애발생시 COLD BACKUP 수행

v$log_history는 마운트상태에서도 조회가 됨

mount parallel option 활용

open

다 침

drop tablespace users 이후

using backup controlfile 물리적 구조 정보가 바뀌었기 때문에

과거의 컨트롤 팡리은 users를 담고 있기 때문에 지금의 컨트롤 파일이

최신의 구조 정보를 담지 않고 있기 때문에 사용한다

system undo mount단계에서만 복구 할 수 있다 critical

oltp하나 만들어서 sample 스키마를 넣는다 그걸로 실습

rcatdb를 운영한다면 rtc가 먹힌다

================================================================

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

SYS@orcl>!ls //u01/app/oracle/oradata/orcl/

control01.ctl redo01.log redo03.log sysaux01.dbf temp01.dbf

example01.dbf redo02.log rman_tbs.dbf system01.dbf undotbs01.dbf

SYS@orcl>alter tablespace users offline immediate;

Tablespace altered.

SYS@orcl>@reco_scan.sql

6 ;

FILE#

----------

DF_NAME

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

TBSP_NAME STATUS ERROR CHANGE# TIME

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

/u01/app/oracle/oradata/orcl/users01.dbf

USERS RECOVER FILE NOT FOUND 0

SYS@orcl>SELECT file#, error FROM v$recover_file;

FILE# ERROR

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

4 FILE NOT FOUND

SYS@orcl>SELECT archive_name FROM v$recovery_log;

no rows selected

=================================================

user-managed incomplete recovery(Time-Base)

=================================================

10/12 실습

http://cafe.naver.com/ocmkorea/4491

vi incom.sql

create table insa(id number, name varchar2(10), hdate date);

alter system switch logfile;

alter system checkpoint;

insert into insa values(10, 'harry', sysdate);

commit;

alter system switch logfile;

alter system checkpoint;

insert into insa values(20, 'porter', sysdate);

commit;

alter system switch logfile;

alter system checkpoint;

insert into insa values(30, 'merry', sysdate);

commit;

alter system switch logfile;

alter system checkpoint;

insert into insa values(40, 'chris', sysdate);

commit;

alter system switch logfile;

alter system checkpoint;

insert into insa values(50, 'ron', sysdate);

commit;

alter system switch logfile;

SELECT SYSTIMESTAMP FROM DUAL;

alter system checkpoint;

SYSTIMESTAMP

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

12-OCT-15 10.28.32.667924 AM +09:00

SYS@orcl>insert into insa values(60,'devil',sysdate);

1 row created.

SYS@orcl>commit;

Commit complete.

SYS@orcl>select id, name, to_char(hdate, 'YYYY-MM-DD:HH24:HH:SS')time from insa;

ID NAME TIME

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

10 harry 2015-10-12:10:10:32

20 porter 2015-10-12:10:10:32

30 merry 2015-10-12:10:10:32

40 chris 2015-10-12:10:10:32

50 ron 2015-10-12:10:10:32

60 devil 2015-10-12:10:10:40

6 rows selected.

SYS@orcl>drop table insa purge;

Table dropped.

SYS@orcl>shutdown immmediate;

SP2-0717: illegal SHUTDOWN option

SYS@orcl>shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SYS@orcl>exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@lnx04 ~]$ cp /BACKUP/close/*.dbf $ORACLE_BASE/oradata/orcl/

[oracle@lnx04 ~]$ ss

SQL*Plus: Release 11.2.0.1.0 Production on Mon Oct 12 10:31:15 2015

Connected to an idle instance.

SYS@orcl>startup mount

ORACLE instance started.

Total System Global Area 1707446272 bytes

Fixed Size 1336988 bytes

Variable Size 1006635364 bytes

Database Buffers 687865856 bytes

Redo Buffers 11608064 bytes

Database mounted.

SYS@orcl>recover database until time '2015-10-12:10:10:36';

ORA-00283: recovery session canceled due to errors

ORA-19907: recovery time or SCN does not belong to recovered incarnation

SYS@orcl>recover database until time '2015-10-12:10:14:36';

ORA-00283: recovery session canceled due to errors

ORA-19907: recovery time or SCN does not belong to recovered incarnation

SYS@orcl>recover database until time '2015-10-12:10:28:40';

ORA-00279: change 915520 generated at 10/12/2015 10:22:26 needed for thread 1

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

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