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