| 失效链接处理 |
|
Oracle 19.1.0.4+ogg搭徏指南 PDF 下蝲
本站整理下蝲Q?/strong>
链接Q?a target="_blank">https://pan.baidu.com/s/1UodSs96-CWyl0vyTc1qE7A
提取码：(x)enp1
相关截图Q?/strong>
主要内容Q?/strong>
二、源端和目标端目录创?/div>
mkdir /ogg
chown -R oracle:oinstall /ogg
mkdir /u01/arch
chown -R oracle:oinstall /u01/arch
三?源端和目标端 数据库设|ؓ(f) 归档模式
sqlplus / as sysdba
alter system set log_archive_dest_1='location=/u01/arch';
alter system set log_archive_format = "lfoadb_%t_%s_%r.arc" scope=spfile;
shutdown immediate;
startup mount;
alter database archivelog;
alter database open;
更多数据库资源请讉K 河学习(fn)在线 www.eimhe.com
四、Oracle 环境变量 讄
源端Q?/div>
[oracle@jcogg01 ~]$ vi .bash_profile
ORACLE_BASE=/u01
ORACLE_HOME=$ORACLE_BASE/oracle
OGG_HOME=/ogg
ORACLE_SID=lfoadb
PATH=$ORACLE_HOME/bin:$OGG_HOME:$PATH
export ORACLE_BASE ORACLE_HOME ORACLE_SID OGG_HOME PATH
alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'
alias ggsci='rlwrap ggsci'
NLS_LANG="simplified chinese"_china.AL32UTF8
export NLS_LANG
export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'
export NLS_TIMESTAMP_FORMAT='yyyy-mm-dd HH24:MI:SSXFF'
export NLS_TIMESTAMP_TZ_FORMAT='yyyy-mm-dd HH24:MI:SSXFF TZR'
目标端：(x)
ORACLE_BASE=/u01
ORACLE_HOME=$ORACLE_BASE/oracle
OGG_HOME=/ogg
ORACLE_SID=tsoadb
PATH=$ORACLE_HOME/bin:$OGG_HOME:$PATH
export ORACLE_BASE ORACLE_HOME ORACLE_SID OGG_HOME PATH
alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'
alias ggsci='rlwrap ggsci'
NLS_LANG="simplified chinese"_china.AL32UTF8
export NLS_LANG
export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'
export NLS_TIMESTAMP_FORMAT='yyyy-mm-dd HH24:MI:SSXFF'
export NLS_TIMESTAMP_TZ_FORMAT='yyyy-mm-dd HH24:MI:SSXFF TZR'
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
|
| Java1234官方?5Q?/td> | 
|
| Java1234官方?5Q?/td> | 838462530 |
苏公|安?32061202001004?/p>
