oracle12c查询orapw文件,Oracle12C 单实例dataguard配置

Oracle12C 单实例dataguard配置

发布时间：2020-07-13 02:07:33

来源：51CTO

阅读：8447

作者：daibaiyang119

Oracle用户环境变量配置：

ORACLE_BASE=/orcl/app/oracle

ORACLE_HOME=$ORACLE_BASE/product/12.2.0/db_1

ORACLE_SID=orcl

export ORACLE_BASE ORACLE_HOME ORACLE_SID

PATH=$ORACLE_HOME/bin:$PATH

export PATH

export NLS_LANG=american_america.AL32UTF8

主库:

1. 将primary数据库设置为force logging模式

select force_logging from v$database;

alter database force logging;

2. 创建密码文件(如果没有)

orapwd file=$ORACLE_HOME/dbs/orapworcl password=syspassword entries=30;

3. 将主库至于归档模式

shutdown immediate;

startup mount;

alter database archivelog;

alter database open;

4. disabled selinux

cat /etc/selinux/config | grep 'SELINUX'

5. 配置standby redo log

select GROUP#,BYTES/1024/1024 size_M,STATUS,ARCHIVED from v$log;  # 查询当前日志组大小

alter database add standby logfile group 4 ('/orcl/app/oracle/oradata/orcl/standbyrd01.log') size 200M;

alter database add standby logfile group 5 ('/orcl/app/oracle/oradata/orcl/standbyrd02.log') size 200M;

alter database add standby logfi