oracle12c dg搭建最大性能模式已验证文档.pdf

落枫0907

359

18页

2次

2022-08-08

100墨值下载

1 .环境说明

源数据库

目标数据库

IP 地址

192.168.

137.133 192.168.137.135

数据库 SID

rclp 注：instance_name orcls

DB_UNIQUE_NAME

rcl_p Oral_s

数据文件路径

/u01/app/oracle/oradata

归档路径

/home/oracle

2.主库启动 FORCE LOGGING

SQL> col name for a20

SQL> select name,open_mode from v$database;

SQL> alter database force logging; --开启强制归档关闭 nologging

Database altered.

3. 主库启动归档模式

SQL> archive log list;

Database log mode No Archive Mode

Automatic archival Disabled

Archive destination USE_DB_RECOVERY_FILE_DEST

SQL> show parameter log_archive_dest_1

SQL> alter system set log_archive_dest_1='location=/home/oracle/'

scope=spfile;

System altered.

SQL> show parameter db_recovery_file_dest

NAME TYPE VALUE

------------------------------------ ----------- --------------------

----------

db_recovery_file_dest string /home/oracle

db_recovery_file_dest_size big integer 4560M

SQL>alter system set db_recovery_file_dest='location=/home/oracle/'

scope=spfile;

SQL> show parameter log_archive_format

SQL>alter system set log_archive_format='arch_%t_%s_%r.arc'

scope=spfile;

System altered.

SQL> shutdown immediate --关闭需要干净的关闭不能使用 abort

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount --在 mount 状态下开启归档

Database mounted.

SQL> alter database archivelog; --开启归档

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list;

of 18

100墨值下载

关注

评论