RAC做单实例备库

172.24.154.90

 

#主机名

 

[root@postmalldg2 ~]# cat /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

172.24.154.90  postmalldg2.tu.bj        postmalldg2

 

 

[root@postmalldg2 ~]# cat /etc/sysconfig/network

NETWORKING=yes

HOSTNAME=postmalldg2.tu.bj

 

 

 

#su - oracle

vim .bash_profile

 

export PATH

export TMP=/tmp;

export TMPDIR=$TMP;

export ORACLE_BASE=/data/app/oracle;

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1;

export ORACLE_UNQNAME=postmalldg2;

export ORACLE_SID=postmalldg2;

export ORACLE_TERM=xterm;

export PATH=/usr/sbin:$PATH;

export PATH=$ORACLE_HOME/bin:$PATH;

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;

if [ $USER = "oracle" ]; then

if [ $SHELL = "/bin/ksh" ];

  then ulimit -p 16384 ulimit -n 65536 else

  ulimit -u 16384 -n 65536

 fi

fi

 

 

 

source .bash_profile

 

 

 

 

 

#备库加TNS

 

cat $ORACLE_HOME/network/admin/tnsnames.ora

 

 

postmalldg2 =

     (DESCRIPTION =

        (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = 172.24.154.90)(PORT = 1521))

        )

     (CONNECT_data =

        (SERVICE_NAME = postmalldg2)

     )

     )

 

 

 

 

#主库

SQL>alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(postmall,postmalldg,postmalldg2)';

SQL>alter system set LOG_ARCHIVE_DEST_6='SERVICE=postmalldg2 lgwr async valid_for=(online_logfiles,primary_roles) DB_UNIQUE_NAME=postmalldg2';

 

alter system set log_archive_dest_state_6='enable';

 

 

 

 

 

su - oracle

cd $ORACLE_HOME/dbs

scp orapwpostmall 172.24.154.90:/data/app/oracle/product/11.2.0/db_1/dbs/orapwpostmalldg2

 

 

#备库操作

 

 

#建立目录

 

mkdir -p /data/app/oracle/archive

mkdir -p /data/app/oracle/admin/postmalldg2/adump/

mkdir -p /data/app/oracle/oradata/postmalldg2/

mkdir -p /data/app/oracle/standbylog/

mkdir -p /data/app/oracle/oradata/postmalldg2/fast_recovery_area/

 

 

 

 

#添加监听

 

 

vim /data/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

 

 

SID_LIST_LISTENER=

        (SID_LIST=

            (SID_DESC=

               (ORACLE_HOME=/data/app/oracle/product/11.2.0/db_1)

               (SID_NAME=postmalldg2)

            )

        )

 

postmalldg2=

      (DESCRIPTION_LIST =

         (DESCRIPTION =

         (ADDRESS = (PROTOCOL = TCP)(HOST = postmalldg2.tu.bj )(PORT = 1521))

         )

      )

 

ADR_BASE_LISTENER = /data/app/oracle

 

 

 

 

 

cat tnsnames.ora

 

 

postmall = 

  (DESCRIPTION = 

    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.24.154.32)(PORT = 1521)) 

    (CONNECT_data = 

      (SERVER = DEDICATED) 

      (SERVICE_NAME = postmall) 

    ) 

 ) 

 

 

postmalldg2 =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.24.154.90)(PORT = 1521))

    )

    (CONNECT_data =

      (SERVICE_NAME = postmalldg2)

    )

  )

 

 

 

#编辑参数文件

 

echo 'DB_NAME=postmall' > /data/app/oracle/product/11.2.0/db_1/dbs/initpostmalldg2.ora

 

 

#数据库启动 nomount 状态

SQL>sqlplus / as sysdba

SQL>startup nomount pfile='/data/app/oracle/product/11.2.0/db_1/dbs/initpostmalldg2.ora';

 

 

#启动监听

 

lsnrctl start

lsnrctl status

 

 

rman target sys/dba.2015@postmall auxiliary sys/dba.2015@postmalldg2;

 

run{

  allocate channel prmy1 type disk;

  allocate channel prmy2 type disk;

  allocate channel c1 type disk;

  allocate auxiliary channel stby type disk;

  duplicate target database for standby from active database dorecover nofilenamecheck

  spfile

  parameter_value_convert 'postmall','postmalldg2'

  set cluster_database='false'

  set db_unique_name='postmalldg2'

  set control_files='/data/app/oracle/oradata/postmalldg2/stbycontrol01.ctl','/data/app/oracle/oradata/postmalldg2/stbycontrol02.ctl','/data/app/oracle/oradata/postmalldg2/fast_recovery_area/stbycontrol03.ctl'

  set db_file_name_convert='+DATA/postmall/datafile/','/data/app/oracle/oradata/postmalldg2/','+DATA/postmall/','/data/app/oracle/oradata/postmalldg2/'

  set log_file_name_convert='+DATA/postmall/onlinelog/','/data/app/oracle/standbylog/'

  set log_archive_max_processes='5'

  set fal_client='postmalldg2'

  set fal_server='postmall'

  set memory_target='0'

  set sga_target='23G'

  set log_archive_config='dg_config=(postmall,postmalldg2)'

  set log_archive_dest_1='location=/data/app/oracle/archive/ db_unique_name=postmalldg2'

  set log_archive_dest_2='service=postmall lgwr async  db_unique_name=postmall'

  set log_archive_dest_state_2='ENABLE'

  set db_create_file_dest='/data/app/oracle/oradata/postmalldg2/'

  set db_create_online_log_dest_1='/data/app/oracle/standbylog/'

  set db_create_online_log_dest_2='/data/app/oracle/standbylog/'

  set log_archive_format='stbyarc_%t_%s_%r.arc'

  set audit_file_dest='/data/app/oracle/admin/postmalldg2/adump/'

  set standby_archive_dest='/data/app/oracle/archive/'

  set remote_listener=''

  set db_recovery_file_dest='/data/app/oracle/oradata/postmalldg2/fast_recovery_area/'

  set diagnostic_dest='/data/app/oracle/'

  set standby_file_management='auto';

  sql channel c1 "alter system archive log current";

}

 

 

#查看主库日志组及日志大小

SQL>  SELECT  GROUP#,THREAD# , MEMBERS,BYTES/1024/1024  FROM V$LOG;

 

在备库添加日志组文件（每个节点都要加）

alter database add standby logfile thread 1 group 50  '/data/app/oracle/standbylog/sredo50.log' size 200M;

alter database add standby logfile thread 1 group 51  '/data/app/oracle/standbylog/sredo51.log' size 200M;

alter database add standby logfile thread 1 group 52  '/data/app/oracle/standbylog/sredo52.log' size 200M;

alter database add standby logfile thread 1 group 53  '/data/app/oracle/standbylog/sredo53.log' size 200M;

alter database add standby logfile thread 1 group 54  '/data/app/oracle/standbylog/sredo54.log' size 200M;

alter database add standby logfile thread 1 group 55  '/data/app/oracle/standbylog/sredo55.log' size 200M;

alter database add standby logfile thread 1 group 56  '/data/app/oracle/standbylog/sredo56.log' size 200M;

 

 

alter database add standby logfile thread 3 group 57  '/data/app/oracle/standbylog/sredo57.log' size 200M;

alter database add standby logfile thread 3 group 58  '/data/app/oracle/standbylog/sredo58.log' size 200M;

alter database add standby logfile thread 3 group 59  '/data/app/oracle/standbylog/sredo59.log' size 200M;

alter database add standby logfile thread 3 group 60  '/data/app/oracle/standbylog/sredo60.log' size 200M;

alter database add standby logfile thread 3 group 61  '/data/app/oracle/standbylog/sredo61.log' size 200M;

alter database add standby logfile thread 3 group 62  '/data/app/oracle/standbylog/sredo62.log' size 200M;

alter database add standby logfile thread 3 group 63  '/data/app/oracle/standbylog/sredo63.log' size 200M;

 

#应用当前日志

 

alter database recover managed standby database disconnect from session;

alter database recover managed standby database cancel;

alter database open;

alter database recover managed standby database using current logfile disconnect;

 

#查看dg模式

select open_mode,database_role,db_unique_name from v$database;

 

select database_role,protection_mode,protection_level from v$database;

 

#查看当前主库日志

set linesize 1000

select * from v$logfile;

select group#, member from v$logfile where type='STANDBY';

 

 

#主更新数据，查看备库同步状态

 

 

#查看备库状态

set linesize 200

SELECT THREAD# ,SEQUENCE#,

       TO_CHAR(COMPLETION_TIME ,'DD HH24:MI:SS') COMPT_TM,

       TO_CHAR(FIRST_TIME,'DD HH24:MI:SS') FRST_TM,

       TO_CHAR(NEXT_TIME,'DD HH24:MI:SS') NEXT_TM,

       APPLIED

FROM gV$ARCHIVED_LOG WHERE FIRST_TIME>sysdate -0.5 ORDER BY SEQUENCE#;

 

 

#查看主库状态

set linesize 500

select DEST_ID ,DESTINATION ,STATUS ,ERROR,

       TO_CHAR(FAIL_DATE,'YYYY-MM-DD HH24:MI:SS')

       "FAIL DATE",d.TARGET,d.LOG_SEQUENCE,d.TRANSMIT_MODE,ARCHIVER ,PROCESS

from gv$archive_dest d

where DESTINATION is not null;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31387888/viewspace-2124313/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31387888/viewspace-2124313/