) ) CNDBA_P = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.3)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = cndba) ) ) [ora12c@dave admin]$ tnsping cndba_s [ora12c@dave admin]$ tnsping cndba_p

7 在备库创建必要的目录

可以参考主库的pfile中的路径：

[ora12c@dave admin]$ mkdir -p /home/ora12c/app/oracle/fast_recovery_area

[ora12c@dave admin]$ mkdir -p/home/ora12c/app/oracle/oradata

[ora12c@dave admin]$ mkdir -p/home/ora12c/app/oracle/admin/cndba/adump

8 在主库创建pfile 文件并修改pfile 内容

SQL> create pfile from spfile;

File created.

在pfile中添加如下内容：

#add for primary dg

*.db_name='cndba'

*.db_unique_name='cndba_p'

*.log_archive_config='dg_config=(cndba_p,cndba_s)'

*.log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DESTvalid_for=(all_logfiles,all_roles) db_unique_name=cndba_p'

*.log_archive_dest_2='service=cndba_s valid_for=(online_logfiles,primary_role) lgwr affirmsync db_unique_name=cndba_s'

*.log_archive_dest_state_1=enable

*.log_archive_dest_state_2=enable

*.standby_file_management='auto'

*.fal_server='cndba_s'

如果主备库CDB名称不同，还需要加如下参数：

*.DB_FILE_NAME_CONVERT='cndba','dave'

*.LOG_FILE_NAME_CONVERT='cndba','dave'

用新参数重启数据库：

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.



SQL> create spfile from pfile;

File created.



SQL> startup

ORACLE instance started.



Total System Global Area 1620115456 bytes

Fixed Size 2288920 bytes

Variable Size 1040188136 bytes

Database Buffers 570425344 bytes

Redo Buffers 7213056 bytes

Database mounted.

Database opened.

SQL>

9 将主库的口令文件copy到备库

我这里主备库的CDB实例相同，如果不同，可以使用orapwd命令重建。

[ora12c@dave dbs]$ scp orapwcndba192.168.56.4:`pwd`

ora12c@192.168.56.4's password:

orapwcndba 100% 7680 7.5KB/s 00:00

[ora12c@dave dbs]$

10 将主库的参数文件copy到备库并修改

[ora12c@dave dbs]$ scp initcndba.ora192.168.56.4:`pwd`

ora12c@192.168.56.4's password:

initcndba.ora 100% 1593 1.6KB/s 00:00

[ora12c@dave dbs]$



修改如下内容，在重新生成spfile：

#add for standby dg

*.db_unique_name='cndba_s'

*.log_archive_config='dg_config=(cndba_p,cndba_s)'

*.log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DESTvalid_for=(all_logfiles,all_roles) db_unique_name=cndba_s'

*.log_archive_dest_2='service=cndba_pvalid_for=(online_logfiles,primary_role) lgwr affirm sync db_unique_name=cndba_p'

*.log_archive_dest_state_1=enable

*.log_archive_dest_state_2=enable

*.standby_file_management='auto'

*.fal_server='cndba_p'

注意修改控制文件的路径，也使用新路径。

SQL> create spfile from pfile;

File created.

11 用spfile 将备库启动到nomount 状态


SQL> startup nomount

ORACLE instance started.



Total System Global Area 1620115456 bytes

Fixed Size 2288920 bytes

Variable Size 1040188136 bytes

Database Buffers 570425344 bytes

Redo Buffers 7213056 bytes

SQL>

12 开始进行Active duplicate

[ora12c@dave network-scripts]$ rman targetsys/oracle@cndba_p auxiliary sys/oracle@cndba_s;



Recovery Manager: Release 12.1.0.1.0 -Production on Wed Aug 6 20:41:02 2014



Copyright (c) 1982,

Oracle12c Data Guard搭建手册(四)