rman 建立ftp standby-优快云博客

1.首先在standby機器上建制空庫,名字一樣.(該步可選,不一定要完全建制,不建制的話,後續需要手動創建目錄)
2.必須確保主數據庫處於歸檔模式
3.確定RMAN產生的文件放置的位置,這裡指定為/data/backup.
4.在主數據庫上執行:
$rman target /
5.
RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2048 M FORMAT '/data/rmanbak/%U';

6.
configure controlfile autobackup on;
7.
show all;
8.
BACKUP DATABASE INCLUDE CURRENT CONTROLFILE FOR STANDBY PLUS ARCHIVELOG;
如缺少歸檔，則在rman下执行如下语句：change archivelog all crosscheck ;一切搞定
9.
RMAN> exit

10.
standby數據庫上配置監聽類似:

SID_LIST_LISTENER =
(SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/product/oracle)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = beipin)
      (ORACLE_HOME = /u01/product/oracle)
      (SID_NAME = beipin)
    )
)

LISTENER =
(DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.161.26.12)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
)

然後啟動監聽
12.
如果兩邊內存大小一致,則可以直接拷貝主數據庫的spfile和密碼文件至standby數據庫對應位置
如果內存不一致,則對比進行修正
13.
拷貝主庫產生的備份集至standby服務器對應位置,這裡為/data/backup
14.
在主庫上的tnsnames.ora文件中添加standby數據庫的連接:
STANDBY =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.161.26.12)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = beipin)
    )
)
并測試可以在主庫tnsping備庫