oracle数据库datagard搭建物理备库（主动切换）-详细笔记文档总结

oracle 数据库 datagard 搭建物理备库（主动切换）

主库：192.168.40.128 备库：192.168.40.131

1.oracle1 机器操作：（主库）

[oracle@oracle1 ~]$ cd /u01/app/oracle/product/11.2.0/db_1/network/admin/

[oracle@oracle1 admin]$ ls

listener.ora samples shrept.lst tnsnames.ora

[oracle@oracle1 admin]$ vim tnsnames.ora

ORCL1 =

(DESCRIPTION =

)

)

ORCL2 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.40.131)(PORT = 1521))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

SQL> conn system/oracle@orcl2

Connected.

SQL> conn system/oracle@orcl1

Connected.

SQL> exit

[oracle@oracle1 admin]$ cd /u01/app/oracle/product/11.2.0/db_1/dbs/

[oracle@oracle1 dbs]$ ls

hc_DBUA0.dat hc_orcl.dat init.ora lkORCL orapworcl spfileorcl.ora

[oracle@oracle1 dbs]$ sqlplus /nolog

SQL> conn / as sysdba

SQL> create pfile from spfile;

SQL> exit

[oracle@oracle1 dbs]$ ls

hc_DBUA0.dat hc_orcl.dat init.ora initorcl.ora lkORCL orapworcl spfileorcl.ora

[oracle@oracle1 dbs]$ mv orapworcl orapworcl.bak

[oracle@oracle1 dbs]$ ls

[oracle@oracle1 dbs]$ vim initorcl.ora //修改 pfile 文件

……………………//最下面添加

log_archive_dest_1='LOCATION=/u01/app/oracle/oradata/archive'

log_archive_dest_state_1=enable

log_archive_dest_2='SERVICE=ORCL2'

log_archive_dest_state_2=enable

log_archive_start=true

log_archive_format='%t_%s_%r.arc'

log_archive_max_processes=2

fal_server=ORCL2

fal_client=ORCL1

[oracle@oracle1 dbs]$ ls /u01/app/oracle/oradata/

archive orcl

[oracle@oracle1 dbs]$ sqlplus /nolog

SQL> conn / as sysdba

SQL> shutdown immediate;

SQL> startup mount;

SQL> alter database create standby controlfile as '/u01/app/oracle/oradata/orcl/standby.ctl';

//以上是创建 standby 控制文件

SQL> alter database open;

SQL> shutdown immediate;

SQL> exit

[oracle@oracle1 dbs]$ cd /u01/app/oracle/oradata/

control01.ctl redo01.log redo03.log sysaux01.dbf temp01.dbf users01.dbf

control02.ctl redo02.log standby.ctl system01.dbf undotbs01.dbf

[oracle@oracle1 oradata]$ scp -r orcl/ 192.168.40.131:/u01/app/oracle/oradata/

输入的是备库 oracle 用户的密码，密码也是 oracle。 //将主库的整个数据库 cp 过去

[oracle@oracle1 oradata]$ ls ../

admin cfgtoollogs checkpoints diag oradata oraInventory product

orcl

[oracle@oracle1 admin]$ scp -r orcl 192.168.40.131:/u01/app/oracle/admin/

//输入备库 oracle 用户的密码，也是 oracle,是 cp 主库一些 pfile 和一些垃圾文件，目录结构

[oracle@oracle1 admin]$ cd /u01/app/oracle/product/11.2.0/db_1/dbs/

[oracle@oracle1 dbs]$ ls

hc_DBUA0.dat init.ora lkORCL orapworcl.bak

hc_orcl.dat initorcl.ora orapworcl spfileorcl.ora

[oracle@oracle1 dbs]$ //主库 cp 参数文件和密码文件到备库

scp initorcl.ora orapworcl 192.168.40.131:/u01/app/oracle/product/11.2.0/db_1/dbs/

输入备库 oracle 用户的密码，也是 oracle

ORCL1 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.40.128)(PORT = 1521))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

(DESCRIPTION =