## 前言
RMAN 可以直接複製一臺正在執行的資料庫到新的安裝了Oracle軟體的資料庫上。下面主要介紹相應的配置過程

### 準備工作：
1. 正在執行的源資料庫（SOURCE)，用於進行復制。
2. 僅安裝有Oracle軟體的資料庫（DESTINATION)，此資料庫不用dbca進行資料庫建立。
3. SOURCE資料庫必須開啟ARCHIVE LOG 模式。
4. SOURCE資料庫開啟listener

### 安裝配置過程：

#### SOURCE資料庫配置：
1. 配置tnsnames.ora檔案

```
DB11G-SOURCE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.0.60)(PORT = 1521))
    )
    (CONNECT_DATA =
      (ORACLE_SID = DB11G)
    )
  )
DB11G-DESTINATION =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.0.70)(PORT = 1521))
    )
    (CONNECT_DATA =
      (ORACLE_SID = DB11G)
    )
  )

```
#### DESTINATION 資料庫配置

1. DB_NAME和SID與SOURCE資料庫保持一致
2. 在$ORACLE_HOME/dbs/下建立init$DB_NAME.ora檔案，裡面只寫一行：
DB_NAME=$SOURCE_DB_NAME
3. 配置tnsnames.ora和listener.ora，用於實現SOURCE和DESTINATION的互聯互通，配置完成後執行lsnrctl reload，生效配置
$ORACLE_HOME/network/admin/tnsnames.ora

```
DB11G-SOURCE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.0.60)(PORT = 1521))
    )
    (CONNECT_DATA =
      (ORACLE_SID = DB11G)
    )
  )

DB11G-DESTINATION =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.0.70)(PORT = 1521))
    )
    (CONNECT_DATA =
      (ORACLE_SID = DB11G)
    )
  )
```

$ORACLE_HOME/network/admin/listener.ora

```
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = DB11G)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
      (SID_NAME = DB11G)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.0.70)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

```

4. 建立相應目錄，與SOURCE資料庫保持一致(oracle賬戶下）

```shell
mkdir -p /u01/app/oracle/oradata/$DB_NAME
mkdir -p /u01/app/oracle/fast_recovery_area
```
5. startup nomount
6. rman target sys/password@DB11G-SOURCE auxiliary sys/password@DB11G-DESTINATION

7. 在RMAN中執行如下命令

```
DUPLICATE DATABASE TO DB11G
  FROM ACTIVE DATABASE
  SPFILE
  NOFILENAMECHECK;
```

使用RMAN複製資料庫 active database

相關文章