스터디북125 [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. [10/13] 실습 - 2 RMAN을 이용한 Duplicate 복제 DB 생성 ============================================RMAN을 이용한 Duplicate 복제 DB 생성============================================ [root@lnx04 /]# mkdir -p /data/reorcl[root@lnx04 /]# chown -R oracle.oinstall /data/ SYS@orcl>create pfile from spfile 2 ; File created. vi tnsnames.ora reorcl = (description = (address_list = (address = (protocol=tcp)(host=lnx04.ocmkorea.com)(port=1521)) (load_balance = yes) ) (c.. 2015. 10. 13. 이전 1 ··· 21 22 23 24 25 26 27 ··· 32 다음