스터디북125 [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. [10/14] 정리 Admin2 C7 일부 ~ C11 복습 및 정리 clear admin1 기본 연습 정리 2 HOST 2DB duplication 정리 next SQL script인 $ORACLE_HOME/sqlplus/admin/pupbld.sql은 Product와 User Profile table을 만들기 위해서 사용자 SYSTEM으로서 실행될 것이다. SYS@orcl>select flashback_on from v$database; FLASHBACK_ON------------------YES RMAN> list backup of database by file; List of Datafile Backups======================== File Key TY LV S Ckp SCN Ckp Time #Piec.. 2015. 10. 14. 이전 1 ··· 20 21 22 23 24 25 26 ··· 32 다음