lec:oracle:11gadmin2

차이

문서의 선택한 두 판 사이의 차이를 보여줍니다.

차이 보기로 링크

--- lec:oracle:11gadmin2 [2016/11/09 08:42] – [15] starlits
+++ lec:oracle:11gadmin2 [2025/10/03 22:30] (현재) – 바깥 편집 127.0.0.1
@@ 줄 13: / 줄 13: @@
 ===== 04 =====
+| 4 | sqlplus system/oracle@orcl \\ select * from V$RMAN_CONFIGURATION; |
 | 16 | [[dbms:oracle:concept:highwatermark | HWM (High Water Mark) ]] |
 ===== 05 =====
-| 3 | [[http://doc.adminschool.net/oracle/db112en/backup.112/e10643/rcmsubcl010.htm#i82206| Backup and Recovery Reference > Summary of RMAN Subclauses > formatSpec ]] |
+| 3 | [[http://doc.adminschool.net/oracle/db112en/backup.112/e10643/rcmsubcl010.htm#i82206| Backup and Recovery Reference > Summary of RMAN Subclauses > formatSpec ]] \\ RMAN> backup as backupset format '/install/rman/df_%d_%s_%p.bus' tablespace users; |
+| 4 | RMAN> backup as copy datafile '+DATA/orcl/datafile/example.265.933811767'; |
+| 15 | RMAN> backup device type disk as backupset database plus archivelog;  |
 ===== 06 =====
-| 6. | tempfile recovery |
+| 06. | tempfile recovery |
-| 9. | relog clear |
+| 07. | redolog \\ SQL> SELECT GROUP#, STATUS, ARCHIVED FROM V$LOG; \\ SQL> ALTER DATABASE CLEAR LOGFILE GROUP 3; |
-| 11. | index re-create \\ create table tb_all_columns as select owner,table_name,column_name from all_tab_columns; |
+| 09. | * |
-| 14. | orapwd  |
+| 11. | index re-create \\ create table tb_all_columns as select owner,table_name,column_name from all_tab_columns; \\ \\ CREATE INDEX SCOTT.EMP_IDX1 ON SCOTT.EMP (ENAME) TABLESPACE USERS PARALLEL 2 ; |
+| 14. | orapwd file=$ORACLE_HOME/dbs/orapworcl password=ora entries=5 |
 ===== 07 =====
+| 03. | RMAN> sql 'alter tablespace example offline immediate'; \\ RMAN> restore tablespace example; \\ RMAN> recover tablespace example; \\ RMAN> sql 'alter tablespace example online'; |
 | 05. | EM에서 Complete Recovery 수행 |
 | 14. | PIT Recovery |
@@ 줄 36: / 줄 41: @@
 | 07. | orcl 에서 모니터링 |
 | 10. | RMAN DEBUG 옵션 |
+| 14. | * |
 ===== 09 =====
 | 04. | Data Recovery Advisor |
@@ 줄 56: / 줄 61: @@
 ===== 13 =====
+===== 14 =====
+| 10 | SQL> exec dbms_stats.gather_schema_stats('HR'); \\ SQL> exec DBMS_STATS.GATHER_TABLE_STATS(ownname=>'HR',tabname=>'EMP'); \\ SQL> exec dbms_stats.gather_index_stats(ownname=>'HR',indname=>'EMP_NAME_IX'); |
+| 23 | SQL> EXECUTE DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT; \\  SQL> @?/rdbms/admin/awrrpt.sql |
 ===== 15 =====
 | SQL Tuning Advisors | 통계,인덱스,프로파일 등을 이용한 SQL 전체적인 advisor |
@@ 줄 67: / 줄 75: @@
 | [[dbms:oracle:admin:schedule:01 | schedule 등록예제 ]] |
+===== 18 =====
+| 12 | 세그먼트 없이 테이블 생성 |
+| 28 | 세그먼트 축소 (shrink) |
+===== 19 =====
+| 14 | 플랫폼의 엔디언 형식 확인 |
 ===== etc =====
   - http://www.dbasamples.com/showoraerror.php?id=1

lec/oracle/11gadmin2.1478650371.txt.gz · 마지막으로 수정됨: 2025/10/03 22:30 (바깥 편집)