oracle数据库的datagard搭建配置物理备库-详细笔记文档总结
需积分: 5 200 浏览量
2023-06-30
22:04:09
上传
评论 1
收藏 26KB DOCX 举报
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 =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.40.128)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
ORCL2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.40.131)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
[oracle@oracle1 admin]$ lsnrctl stop
[oracle@oracle1 admin]$ lsnrctl start
[oracle@oracle1 admin]$ lsnrctl status
[oracle@oracle1 admin]$ sqlplus /nolog //测试通过 tns 配置连接正常（两台都配好才可）
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> alter database force logging; //开启强制记录日志状态
SQL> archive log list; //是归档日志模式
资源评论
