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' （编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |