차이

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

--- study:oracle:10gadminii:usingrecoverymanager [2008/03/30 13:20] – starlits
+++ study:oracle:10gadminii:usingrecoverymanager [2025/10/03 22:30] (현재) – 바깥 편집 127.0.0.1
@@ 줄 4: / 줄 4: @@
   - RMAN 백업명령으로 backup sets 과 image copies 를 만든다.
   - RMAN을 통해 backups과 image copies를 관리한다.
 ===== Issuing Recovery Manager Commands   =====
 ^ interactive client | RMAN  명령어 직접 이용 \\ analysis, reports, stored scripts 사용 |
-^ Bactch mode | 자동화된 작업이용 \\ RMAN 시작시 명령파일 실행 \\ 정보를 로그파일로 설정 |
+^ Batch mode | 자동화된 작업이용 \\ RMAN 시작시 명령파일 실행 \\ 정보를 로그파일로 설정 |
 ^ Pipe interface | PIPE 명령어 이용하기 \\ RMAN 세션과 외부 어플리케이션을 이용하여 데이타 통신하기 |
@@ 줄 24: / 줄 25: @@
 ^ Job | RUN 의 괄호를 이용해야 한다 \\ 그룹 실행이 가능하다 |
 ^ Stand-alone 또는 job | RMAN 프롬프트와 RUN 을 이용하여 실행할 수 있다 \\ RUN의 괄호와 그룹 실행을 할 수 있다 |
@@ 줄 32: / 줄 34: @@
 <code>
 RMAN> RUN {
 > BACKUP AS BACKUPSET
 > FORMAT '/u01/db01/backup/%d_%s_%p'
 > DURATION 10:00 MINIMIZE LOAD
 > (DATABASE);
 > SQL 'alter system archive log current';
 > }
 </code>
@@ 줄 64: / 줄 66: @@
 {{study:oracle:10gadminii:parallelizationofbackupsets.jpg|}}
@@ 줄 70: / 줄 73: @@
 {{study:oracle:10gadminii:compressedbackups.jpg|}} <code>
 RMAN> CONFIGURE DEVICE TYPE
 > DISK PARALLELISM 2
 > BACKUP TYPE TO
 > COMPRESSED BACKUPSET;
 </code>
@@ 줄 175: / 줄 178: @@
 > REUSE;
 </code>
 ===== Incrementally Updating Backups   =====
+{{study:oracle:10gadminii:incrementalupdatingbackups.jpg|}}
 ===== LIST Command Operations   =====
-===== The REPORT Command   =====
+  - 복사된 데이타파일 백업셋 정보 <code>
+RMAN> LIST BACKUP OF DATABASE;
+</code> <code>
+RMAN> LIST BACKUP OF DATAFILE
+> "/db01/ORADATA/u03/users01.dbf";
+</code>
+  - 지정한 테이블스페이스의 데이타파일 백업셋 정보 <code>
+RMAN> LIST COPY OF TABLESPACE "SYSTEM";
+</code>
+  - 특정기간의 archive log 를 포함한 백업셋 정보 <code>
+RMAN> LIST COPY OF DATABASE ARCHIVELOG
+> FROM TIME='SYSDATE-7';
+</code>
+===== The REPORT Command =====
+  - Repository에 저장되어 있는 상세정보를 보여준다.
+  - Reports can be produced for a variety of questions, such as:
+    - What is the structure of the database? <code> RMAN> REPORT SCHEMA; </code>
+    - Which files need to be backed up? <code> RMAN> REPORT NEED BACKUP ...; </code>
+    - Which backups can be deleted (that is, are obsolete)? <code> RMAN> REPORT OBSOLETE; </code>
+    - Which files are not recoverable because of unrecoverable operations? <code> RMAN> REPORT UNRECOVERABLE ...; </code>
 ===== The REPORT NEED BACKUP Command   =====
+  - Lists all data files that require a backup
+  - Assumes the most recent backup is used during a restore
+  - Provides four options
+    * Incremental
+    * Days
+    * Redundancy
+    * Recovery window
+  - Uses the current retention policy configuration if no options are specified
 ===== REPORT NEED BACKUP: Examples   =====
-===== REPORT OBSOLETE and DELETE OBSOLETE   =====
+  - Files needing three or more incremental backups for recovery <code> RMAN> REPORT NEED BACKUP incremental 3; </code>
+  - Files have not been backed up for three days <code> RMAN> REPORT NEED BACKUP days 3; </code>
+  - Backup needed if there are not two or more <code> RMAN> REPORT NEED BACKUP redundancy 2; </code>
+  - Backup needed to recover 3 days past <code>
+RMAN> REPORT NEED BACKUP
+> recovery window of 3 days;
+</code>
+===== REPORT OBSOLETE and DELETE OBSOLETE =====
+  - Find all obsolete recovery files using the current retention policy settings <code>
+RMAN> REPORT OBSOLETE REDUNANCY 2;
+</code>
+  - List the obsolete recovery files, if no more than two backup copies are needed <code>
+RMAN> REPORT OBSOLETE;
+</code>
+  -  Delete the backup set with a backup set key of 4 <code>
+RMAN> DELETE BACKUPSET 4;
+</code>
+  - Delete the recovery files considered obsolete, because they have more than two backups <code>
+RMAN> DELETE OBSOLETE REDUNDANCY 2;
+</code>
 ===== Managing Backups with EM   =====
+{{study:oracle:10gadminii:managingbackupswithem.jpg|}}
 ===== RMAN Dynamic Views   =====
+  - V$ARCHIVED_LOG
+  - V$BACKUP_CORRUPTION
+  - V$BACKUP_DEVICE
+  - V$BACKUP_FILES
+  - V$BACKUP_PIECE
+  - V$BACKUP_REDOLOG
+  - V$BACKUP_SET
+  - V$BACKUP_SPFILE
+  - V$COPY_CORRUPTION
+  - V$RMAN_CONFIGURATION
 ===== Monitoring RMAN Backups   =====
-===== Summary   =====
+  - Correlate server sessions with channels using the SET COMMAND ID command.
+  - Query V$PROCESS and V$SESSION to determine which sessions correspond to which RMAN channels.
+  - Query V$SESSION_LONGOPS to monitor the progress of backups and copies.
+  - Use an operating system utility to monitor the process or threads.
+===== Summary =====
+  - RMAN 백업명령으로 백업셋과 image copies를 만들 수 있다.
+  - RMAN을 통해 백업과 image copies를 관리할 수 있다.
 ===== Practice Overview: Using RMAN   =====

adminschool.net wiki

사용자 도구

사이트 도구

차이

문서 도구