본문 바로가기

분류 전체보기162

[10/14] 실습 - 4 block corruption recover ================================block recover LABs================================ SYS@orcl>create tablespace bbed_test 2 datafile '/u01/app/oracle/oradata/orcl/bbed_test01.dbf' size 5m; Tablespace created. SYS@orcl>create table hr.cp_emp tablespace bbed_test 2 as select * from hr.employees; Table created. SYS@orcl>select table_name, tablespace_name from dba_tables where table_name='CP_EMP'; TAB.. 2015. 10. 14.
[10/14] 실습 - 3 FBDA ======================================Flashback Data Archive===================================== [root@lnx04 ~]# mkdir -p /u02/app/oracle/oradata/orcl[root@lnx04 ~]# chown -R oracle.oinstall /u02 SYS@orcl>create tablespace fbda1 2 datafile '/u02/app/oracle/oradata/orcl/fbda101a.dbf' size 11256k 3 autoextend on next 10m maxsize unlimited 4 ,'/u02/app/oracle/oradata/orcl/fbda101b.dbf' size 11256k.. 2015. 10. 14.
[10/14] 실습 - 2 flashback database =================================flashback database 활성화 설정================================= SYS@orcl>shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SYS@orcl>startup mount exclusive;ORACLE instance started. Total System Global Area 1707446272 bytesFixed Size 1336988 bytesVariable Size 1006635364 bytesDatabase Buffers 687865856 bytesRedo Buffers 11608064 bytesData.. 2015. 10. 14.
[10/14] 실습 - 1 Flashback Transaction BACKOUT table =================================Flashback Transaction BACKOUT================================= SYS@orcl>alter system set db_recovery_file_dest_size = 7g; System altered. SYS@orcl>alter system set db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'; System altered. SYS@orcl>alter database add supplemental log data; Database altered. SYS@orcl>alter database add supplemental log data 2 (pr.. 2015. 10. 14.

티스토리툴바