oracle10g_rman_語法測試_3

--恢復資料檔案2的塊12,13,你可以指定多少資料檔案
BLOCKRECOVER DATAFILE 2 BLOCK 12, 13 DATAFILE 3 BLOCK 5, 98, 99 DATAFILE 4 BLOCK 19;
---恢復資料檔案多個塊,表空間多個塊(tablespace多個塊,以dba為標記)
RUN
{
  BLOCKRECOVER DATAFILE 3 BLOCK 2,3,4,5 TABLESPACE sales DBA 4194405, 4194409, 4194412
  FROM DATAFILECOPY;
}
----從標記,恢復表空間system相關塊

BLOCKRECOVER TABLESPACE SYSTEM DBA 4194404, 4194405 FROM TAG "weekly_backup";
---從2天前開始恢復system表空間資料塊(相關)

BLOCKRECOVER TABLESPACE SYSTEM DBA 4194404, 4194405 RESTORE UNTIL TIME 'SYSDATE-2';
----驗證是否可以備份資料庫,恢復利用v$database_block_corruption所有的損壞塊
The following example runs a backup validation to populate V$DATABASE_BLOCK_CORRUPTION, then repairs any corrupt blocks recorded in the view:

BACKUP VALIDATE DATABASE;
BLOCKRECOVER CORRUPTION LIST;




---catalog 一系列的歸檔日誌到rman的資料庫
CATALOG ARCHIVELOG '?/oradata/archive1_30.dbf', '?/oradata/archive1_31.dbf',
                   '?/oradata/archive1_32.dbf';
---catalog資料檔案映象作為level 0的基礎

CATALOG DATAFILECOPY '?/oradata/users01.bak' LEVEL 0;

Note that you can create datafile copies either using the RMAN BACKUP AS COPY command, or by using operating system utilities in conjunction with ALTER TABLESPACE BEGIN/END BACKUP.
---catalog (模糊匹配)以/tmp/arch為型別的檔案
CATALOG START WITH '/tmp/arch_logs';
---catalog恢復區域,並不提示

CATALOG RECOVERY AREA NOPROMPT;
---catalog備份片
CATALOG BACKUPPIECE '?/oradata/01dmsbj4_1_1.bcp';



list backup;--以預設方式顯示所有的備份
list backup summary;--以概要方式顯示所的備份
list backup by file;---以不同的檔案備份型別顯示所有的備份(資料檔案,歸檔日誌,spfile,控制檔案)
list copy of database;--顯示資料庫的所有複製
list copy of archivelog all;---顯示歸檔日誌的複製
list backup of datafile 3 summary;--顯示資料檔案備份的概要
list incarnation;--顯示儲存在恢復目錄中的資料庫版本資訊記錄
list all script. names;---顯示所有的儲存指令碼,必須是rman catalog

---讓備份集100為不可用(一般用於是這個備份集找不到了,所以為了更新rman配置庫中的資訊
CHANGE BACKUPSET 100 UNAVAILABLE;
CHANGE BACKUP OF SPFILE COMPLETED BEFORE 'SYSDATE-1' UNAVAILABLE;

You do not need to allocate a maintenance channel.

---利用mv移動了歸檔日誌,然後從rman資料庫中nocatalog,最後加入rman資料庫
HOST 'mv $ORACLE_HOME/oradata/trgt/arch/* /fs2/arch';
CHANGE ARCHIVELOG ALL UNCATALOG;
CATALOG START WITH '/fs2/arch';
---改變以標記consi為永遠不過期,永遠儲存,不刪除
CHANGE BACKUP TAG 'consistent_db_bkup'
  KEEP FOREVER NOLOGS;