本文件不包含以下內容：

主資料庫配置、引數、建立相關目錄、監聽器配置、tnsnames.ora配置、密碼檔案配置等，只列出主要步驟

一、主：

建立/u01/oracle_backup目錄：
備份引數檔案：
SQL> create pfile='/u01/oracle_backup/initlis.ora' from spfile;
備份資料：
rman target /
run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;

allocate channel c5 type disk;

backup as compressed backupset format '/u02/orabackup/level0/ncf_db%U' database plus archivelog;

release channel c1;
release channel c2;
release channel c3;
release channel c4;
release channel c5;
}
備份控制檔案：
run{

allocate channel c1 type disk;

backup format '/u02/orabackup/level0/control%U' current controlfile for standby;

release channel c1;

}

二、複製備份檔案到備庫主機，也就是/u01/oracle_backup

三、備：

按需修改目標端引數檔案

rman target /
RMAN> startup nomount;
RMAN> restore standby controlfile from '/u01/oracle_backup/control1bqgo42a_1_1';
RMAN> sql 'alter database mount standby database';
restore資料庫
run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;
allocate channel c5 type disk;
restore database;
release channel c1;
release channel c2;
release channel c3;
release channel c4;
release channel c5;
}

recover資料庫
RMAN> list backup of archivelog all;
找到要恢復到的最大序列號，比如有36的話，那就應該until 37
RMAN> recover database until sequence 37;
RMAN> exit

sqlplus / as sysdba;
SQL> alter database recover managed standby database using current logfile disconnect;
SQL> alter database recover managed standby database cancel;
SQL> alter database open;
SQL> alter database recover managed standby database using current logfile disconnect;

在主庫上多切換幾次日誌，使用以下命令檢查備庫狀態：

select process,status from v$managed_standby;

使用RMAN backup和restore方式部署物理備庫

相關文章