ORACLE_DG_搭建.pdf - 墨天轮文档

ORACLE_DG_搭建.pdf

默人

321

36页

9次

2023-10-24

5墨值下载

ORACLE DG 搭建

dataguard:

DG(同步数据)－－从主机上把归档传输到备机上，分为：

物理：把物理的归档日志文件备份过来了，使用 recover 恢复。

逻辑：把归档日志逻辑上备份过来，先做日志挖掘，把 SQL 语句

选择出来，再选择。

搭建 DG （我这里的主库和备库的目录是一样的）

1，主从的 ORACLE 的版本要一致

2，主从的环境变量要一致

3，配置 hosts 文件

vim /etc/hosts

# Do not remove the following line, or various programs

# that require network functionality will fail.

127.0.0.1 localhost.localdomain localhost

::1 localhost6.localdomain6 localhost6

10.1.1.243 station243.cluster.com station243

10.1.1.172 station172.cluster.com station172

4，在主库上（primary）

修改 force logging ,archivelog mode

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area 603979776 bytes

Fixed Size 1268872 bytes

Variable Size 213910392 bytes

Database Buffers 381681664 bytes

Redo Buffers 7118848 bytes

Database mounted.

SQL> alter database force logging;

Database altered.

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /u01/app/oracle/archivelog/emrep

Oldest online log sequence 18

Next log sequence to archive 20

Current log sequence 20

of 36

5墨值下载

关注

评论