분류 전체보기162 [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. [10/13] admin 기본 연습 DBA group oracle os user 확인 [oracle@lnx04 dbs]$ cat /etc/group | grep dbadba:x:5000:oracle [oracle@lnx04 dbs]$ cat /etc/passwd | grep oracleoracle:x:500:5001::/home/oracle:/bin/bash [oracle@lnx04 dbs]$ ps -ef |grep ora_oracle 922 1 0 17:30 ? 00:00:00 ora_arc0_orcloracle 945 1 0 17:30 ? 00:00:00 ora_arc1_orcloracle 949 1 0 17:30 ? 00:00:00 ora_arc2_orcloracle 953 1 0 17:30 ? 00:00:00 ora_arc3_orc.. 2015. 10. 13. [10/13] 실습 - 4 Flashback query, versions query, transaction query versions_xid ~ versions_operstion 11g WS2.ch11 Flashback -----------------------------■ Flashback Query ----------------------------- HR@orcl>select salary from employees where employee_id = 100; SALARY---------- 24000 HR@orcl>update employees set salary = 30000 where employee_id = 100; 1 row updated. HR@orcl>commit; Commit complete. HR@orcl>select salary from employees where employee_id = 100; .. 2015. 10. 13. [10/13] 실습 - 3 Backupset의 병렬화 ===============================backupset의 병렬화=============================== RMAN> create script parall_backup {allocate channel c1 device type disk;allocate channel c2 device type disk;allocate channel c3 device type disk;backupincremental level = 0format '/BACKUP/df_%d_%s_%p.bak'(datafile 1 channel c1)(datafile 2 channel c2)(datafile 3,4,5,6 channel c3);sql 'alter system archive log current';r.. 2015. 10. 13. 이전 1 ··· 21 22 23 24 25 26 27 ··· 41 다음