概述
软件架构
启动流程
环境准备过程
oracle
创建目录
mkdir -p /opt/dmhs
环境变量设置。
cat >>/home/oracle/.bash_profile<<EOF
#oracle 端新增加环境变量配置
export PATH=\$ORACLE_HOME/bin:/usr/local/sbin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin
export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib
export DMHS_HOME=/opt/dmhs
export LD_LIBRARY_PATH=\$LD_LIBRARY_PATH:\$DMHS_HOME/bin:\$DMHS_HOME/odbc/lib:\$DMHS_HOME/bin/stat
EOF
创建需要同步的用户
grant resource to dmhs;
grant select any dictionary to dmhs;
grant create session to dmhs;
grant create trigger to dmhs;
grant connect to dmhs;
grant select any table to dmhs;
grant select any dictionary to dmhs;
grant create table to dmhs;
grant create session to dmhs;
grant lock any table to dmhs;
grant execute on dbms_flashback to dmhs;
grant administer database trigger to dmhs;
grant create trigger to dmhs;
grant select on sys.obj$ to dmhs;
grant select on sys.user$ to dmhs;
grant select on sys.user$ to dmhs;
grant select on sys.obj$ to dmhs;
grant select on sys.tab$ to dmhs;
归档检查
下面的情况就是已经开启了归档的状态。
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/arch
Oldest online log sequence 11
Next log sequence to archive 13
Current log sequence 13
SQL>
开启归档
如果没有开启归档,要求其开启归档,且对归档的要求需要和 DBA 明确提出 (归档放置的目录,归档保留以及归档的处理方式(保留,移除还是删除) ,开 启归档需要重启数据库,所以会中断业务(切记)。如果是需要自己开启归档,最好放置到 ASM 环境中。
下面是开启归档的过程。
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 943718400 bytes
Fixed Size 8799512 bytes
Variable Size 683674344 bytes
Database Buffers 243269632 bytes
Redo Buffers 7974912 bytes
Database mounted.
SQL> alter database archivelog;
Database alt