Oracle datagurad 实现步骤：

1.在源端数据库生成控制文件及全备
su - oracle
mkdir /backup/standby
cp $ORACLE_HOME/dbs/orapw* /backup/standby/.
sqlplus / as sysdba <<EOF
alter system set archive_lag_target=7200;
alter database force logging;
alter database create standby controlfile as '/backup/standby/standby.ctl';
exit;
EOF
rman target / <<EOF
backup  full database format '/backup/standby/%D%u%s%U.dbf';
exit
EOF
cd /backup
gzip /backup/standby/*.dbf


2、目标端新建目录：
su - oracle
mkdir -p /data/test200/


3、将备份文件，控制文件传到目标端的/data/test200目录下
scp /backup/standby/* oracle@10.231.42.200:/data/test200/.


4.新的os调整异步IO
echo fs.aio-max-nr = 4867876 >>/etc/sysctl.conf
sysctl -p


chown oracle:dba /data
su - oracle
mkdir /data/database


5.目标端新建目录cp密码文件及控制文件
su - oracle
cp /data/test200/orapwprimary $ORACLE_HOME/dbs/orapwtest200_stdy


mkdir /data/database/test200_stdy
cp /data/test200/standby.ctl /data/database/test200_stdy/control01.ctl
cp /data/test200/standby.ctl /data/database/test200_stdy/control02.ctl




mkdir -p /opt/oracle/app/oracle/admin/test200_stdy


mkdir -p /opt/oracle/app/oracle/admin/test200_stdy/adump
mkdir -p /opt/oracle/app/oracle/admin/test200_stdy/bdump
mkdir -p /opt/oracle/app/oracle/admin/test200_stdy/cdump
mkdir -p /opt/oracle/app/oracle/admin/test200_stdy/trace
gunzip /data/test200/*.gz


6.从源端cp wallet
scp -r /opt/oracle/app/oracle/admin/primary/wallet oracle@10.231.4.52:/opt/oracle/app/oracle/admin/test200_stdy/.


7.源端查询
sqlplus / as sysdba <<EOF
select distinct bytes/1024/1024 from v\$log;
show parameter db_unique_name
exit
EOF




8.修改源端、目标端tnsnames.ora
echo "
test200 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.231.42.200)(PORT = 1522))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = primary)
    )
  )
test200_stdy =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.231.154.208)(PORT = 1522))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = test200_stdy)
    )
  )
" >>$ORACLE_HOME/network/admin/tnsnames.ora


修改目标端edit listener.ora
vi $ORACLE_HOME/network/admin/listener.ora


lsnrctl stop
lsnrctl start


9.将primary数据库上的/opt/oracle/app/oracle/admin/primary/pfile.ora拷贝到standby的/opt/oracle/app/oracle/admin/test200_stdy/目录下,并且添加如下参数：



10.启动目标数据库
export ORACLE_SID=test200_stdy
export ORACLE_UNQNAME=test200_stdy
sqlplus / as sysdba <<EOF
create spfile from pfile='/data/test200/pfile.ora';
startup mount
EOF


11.恢复目标端数据库
rman target /
catalog start with '/data/test200';
yes
restore database;


12.修改源端数据库参数
alter system set log_archive_config='dg_config=(primary,test200_stdy)';


#alter system set log_archive_config='dg_config=(wfmstandby,test200_stdy)';
alter system set log_archive_config='dg_config=(primary,test200_stdy)';
alter system set log_archive_max_processes=6;
alter system set log_archive_dest_4='service=test200_stdy async reopen=15 valid_for=(online_logfiles,primary_role) db_unique_name=test200_stdy compression=enable';
alter system set log_archive_dest_state_2='defer';
alter system set log_archive_dest_state_4='enable';
alter system set fal_client= 'test200_stdy';


13.创建目标端standby日志文件
alter database clear logfile group 1;
alter database clear logfile group 2;
alter database clear logfile group 3;
alter database clear logfile group 4;
alter database clear logfile group 5;
alter database clear logfile group 6;
alter database clear logfile group 7;
alter database clear logfile group 8;
alter database clear logfile group 9;
alter database clear logfile group 10;
alter database clear logfile group 11;
alter database clear logfile group 12;
alter database clear logfile group 13;
alter database clear logfile group 14;
alter database clear logfile group 15;

alter database clear logfile group 16;

alter database clear logfile group 17;

alter database add standby logfile '/data/database/test200_stdy/redo01.dbf' size 256M;
alter database add standby logfile '/data/database/test200_stdy/redo02.dbf' size 256M;
alter database add standby logfile '/data/database/test200_stdy/redo03.dbf' size 256M;
alter database add standby logfile '/data/database/test200_stdy/redo04.dbf' size 256M;
alter database add standby logfile '/data/database/test200_stdy/redo05.dbf' size 256M;
alter database add standby logfile '/data/database/test200_stdy/redo06.dbf' size 256M;
alter database add standby logfile '/data/database/test200_stdy/redo07.dbf' size 256M;
alter database add standby logfile '/data/database/test200_stdy/redo08.dbf' size 256M;
alter database add standby logfile '/data/database/test200_stdy/redo09.dbf' size 256M;
alter database add standby logfile '/data/database/test200_stdy/redo10.dbf' size 256M;
alter database add standby logfile '/data/database/test200_stdy/redo11.dbf' size 256M;
alter database add standby logfile '/data/database/test200_stdy/redo12.dbf' size 256M;
alter database add standby logfile '/data/database/test200_stdy/redo13.dbf' size 256M;
alter database add standby logfile '/data/database/test200_stdy/redo14.dbf' size 256M;
alter database add standby logfile '/data/database/test200_stdy/redo15.dbf' size 256M;
alter database add standby logfile '/data/database/test200_stdy/redo16.dbf' size 256M;
alter database add standby logfile '/data/database/test200_stdy/redo17.dbf' size 256M;


14.启动目标端standby模式
#RECOVER MANAGED STANDBY DATABASE cancel;
#startup mount force;
RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;


select sequence#,process,status from v$managed_standby where process='MRP0';




15.查看数据库警告日志
tail -f  /opt/oracle/app/oracle/diag/rdbms/*standby/*/trace/a*.log
tail -f  /opt/oracle/app/oracle/diag/rdbms/test200_stdy/*/trace/a*.log


orapki wallet create -wallet /opt/oracle/app/oracle/admin/test200_stdy/wallet -auto_login

primary_tde_001

其中的pfile文件如下：

test200_stdy.__db_cache_size=209715200

test200_stdy.__java_pool_size=4194304
test200_stdy.__large_pool_size=4194304
test200_stdy.__oracle_base='/opt/oracle/app/oracle'#ORACLE_BASE set from environment
test200_stdy.__pga_aggregate_target=255852544
test200_stdy.__sga_target=771751936
test200_stdy.__shared_io_pool_size=0
test200_stdy.__shared_pool_size=524288000
test200_stdy.__streams_pool_size=0
*.archive_lag_target=1800
*.audit_file_dest='/opt/oracle/app/oracle/admin/test200_stdy/adump'
*.audit_sys_operations=TRUE
*.audit_trail='DB'
*.compatible='11.2.0.3.0'
*.control_files='/data/database/test200_stdy/control01.ctl','/data/database/test200_stdy/control02.ctl'#Restore Controlfile
*.cursor_sharing='FORCE'
*.db_block_size=8192
*.db_domain=''
*.DB_FILE_NAME_CONVERT='/oradata/primary/','/data/database/test200_stdy/'
*.db_files=2048
*.db_name='primary'
*.db_recovery_file_dest_size=4517265408
*.db_recovery_file_dest=''
*.db_unique_name='test200_stdy'
*.fal_client='test200_stdy'
*.fal_server='test200'
*.local_listener='(address=(protocol=tcp)(host=linux)(port=1522))'
*.log_archive_config='dg_config=(primary,test200_stdy)'
*.LOG_ARCHIVE_DEST_1='LOCATION=/data/database/test200_stdy/archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES)   DB_UNIQUE_NAME=test200_stdy'
*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
*.log_archive_format='%t_%s_%r.dbf'
*.log_archive_max_processes=4
*.log_archive_start=TRUE
*.log_file_name_convert='/oradata/primary/','/data/database/test200_stdy/'
*.memory_max_target=1024000000
*.memory_target=1024000000
*.open_cursors=300
*.parallel_force_local=TRUE
*.pga_aggregate_target=0
*.processes=1500
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=280
*.sga_target=768000000
*.shared_servers=0
*.standby_file_management='auto'
*.undo_tablespace='UNDOTBS1'