描述:
主库(bumch_primary 存储为ASM)已经有一个正常运行的ACTIVE DATAGUARD(bumch_standby 存储为FS) ,现在要增加一个异地ACTIVE DATAGUARD(bumch_standby_tt 存储为FS)
备库的参数文件,密码文件,监听文件,本地命名文件,及dump目录都创建好了之后通过RMAN拷贝主库到备库时报错
环境:solaris小型机
主库
================
版本:11.2.0.1.5
存储:ASM
参数文件
-bash-3.00$ strings spfilebumch.ora
bumch.__db_cache_size=5100273664
bumch.__java_pool_size=939524096
bumch.__large_pool_size=268435456
bumch.__oracle_base='/u01/oracle'#ORACLE_BASE set from environment
bumch.__pga_aggregate_target=28051505152
bumch.__sga_target=16508780544
bumch.__shared_io_pool_size=0
bumch.__shared_pool_size=9663676416
bumch.__streams_pool_size=268435456
*.audit_file_dest='/u01/oracle/admin/bumch/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='+DATA/bumch/controlfile/current.260.750421765','/backup/bumchdb/bumch/controlfile/o1_mf_6w6q85k2_.ctl'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_file_name_convert='/u01/app/oradata/bumch/','+DATA/bumch/datafile','/u01/app/oradata/bumch/','+DATA/bumch/tempfile'
*.db_name='bumch'
*.db_recovery_file_dest='/backup/bumchdb/'
*.db_recovery_file_dest_size=1073741824000
*.db_unique_name='bumch_primary'
*.diagnostic_dest='/u01/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=bumchXDB)'
*.fal_client='bumch_primary'
*.fal_server='bumch_standby'
*.log_archive_config='DG_CONFIG=(bumch_primary,bumch_standby)'
*.log_archive_dest_1='LOCATION=/backup/bumchdb/bumch/archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=bumch_primary'
*.log_archive_dest_2='SERVICE=bumch_standby LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=bumch_standby'
*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='enable'
*.log_file_name_convert='/u01/app/oradata/bumch/','+DATA/bumch/onlinelog/','/u01/app/oradata/backup/bumchdb/bumch/onlinelog/','/backup/bumchdb/bumch/onlinelog/'
*.memory_target=44463816704
*.nls_language='SIMPLIFIED CHINESE'
*.nls_territory='CHINA'
*.open_cursors=300
*.processes=3000
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=3305
*.undo_tablespace='UNDOTBS1'
备库
==============
版本:11.2.0.1.5
存储:文件系统
参数文件
bumch.__db_cache_size=603979776
bumch.__java_pool_size=16777216
bumch.__large_pool_size=16777216
bumch.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
bumch.__pga_aggregate_target=671088640
bumch.__sga_target=1509949440
bumch.__shared_io_pool_size=0
bumch.__shared_pool_size=838860800
bumch.__streams_pool_size=0
*.audit_file_dest='/u01/oracle/admin/bumch/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oradata/bumch/control01.ctl'
*.db_block_size=8192
*.db_create_file_dest='/u01/app/oradata/bumch/'
*.db_file_name_convert='+DATA/bumch/datafile','/u01/app/oradata/bumch/','+DATA/bumch/tempfile','/u01/app/oradata/bumch/','+DATA/bumch_primary/datafile/','/u01/app/oradata/bumch/','+DATA/bumch_primary/tempfile/','/u01/app/oradata/bumch/'
*.db_files=1000
*.db_name='bumch'
*.db_recovery_file_dest='/u01/app/oradata/backup/bumchdb'
*.db_recovery_file_dest_size=1073741824000
*.db_unique_name='bumch_standby_tt'
*.diagnostic_dest='/u01/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=bumchXDB)'
*.fal_client='bumch_standby_tt'
*.fal_server='bumch_primary'
*.log_archive_config='DG_CONFIG=(bumch_primary,bumch_standby_tt)'
*.log_archive_dest_1='LOCATION=/u01/app/oradata/backup/bumchdb/bumch/archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=bumch_standby_tt'
*.log_archive_dest_2='SERVICE=bumch_primary LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=bumch_primary'
*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='enable'
*.log_file_name_convert='+DATA/bumch/onlinelog/','/u01/app/oradata/bumch/','/backup/bumchdb/bumch/onlinelog/','/u01/app/oradata/backup/bumchdb/bumch/onlinelog/'
*.memory_target=2181038080
*.nls_language='SIMPLIFIED CHINESE'
*.nls_territory='CHINA'
*.open_cursors=300
*.processes=3000
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=3305
*.standby_file_management='AUTO'
*.undo_tablespace='UNDOTBS1'
Dataguard 搭建过程(相同的搭建过程在虚拟机上成功,但是在生产上失败了)
===============
1,主库操作
修改主库参数
====================bumch=================
alter system set log_archive_config='DG_CONFIG=(bumch_primary,bumch_standby,bumch_standby_tt)';
alter system set log_archive_dest_3='SERVICE=bumch_standby_tt LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=bumch_standby_tt';
alter system set log_archive_dest_state_3=enable;
2,备库起到NOMOUNT后进行RMAN duplicate
=====================bumch=================================
-bash-3.00$ rman target sys/passwd@bumch_primary auxiliary sys/passwd@bumch_standby_tt log=bumch_dpl.log
RMAN> duplicate target database for standby from active database;
这一步报错了
=======================
备库RMAN报错信息:
RMAN>
Starting Duplicate Db at 24-AUG-12
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=3399 device type=DISK
allocated channel: ORA_AUX_DISK_2
channel ORA_AUX_DISK_2: SID=3966 device type=DISK
allocated channel: ORA_AUX_DISK_3
channel ORA_AUX_DISK_3: SID=3 device type=DISK
allocated channel: ORA_AUX_DISK_4
channel ORA_AUX_DISK_4: SID=568 device type=DISK
contents of Memory Script:
{
backup as copy reuse
targetfile '/u01/oracle/product/11.2.0/db_1/dbs/orapwbumch' auxiliary format
'/u01/app/oracle/product/11.2.0/db_1/dbs/orapwbumch' ;
}
executing Memory Script
Starting backup at 24-AUG-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1422 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=1566 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=1708 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=1850 device type=DISK
Finished backup at 24-AUG-12
contents of Memory Script:
{
backup as copy current controlfile for standby auxiliary format '/u01/app/oradata/bumch/control01.ctl';
}
executing Memory Script
Starting backup at 24-AUG-12
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
channel ORA_DISK_1: starting datafile copy
copying standby control file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/24/2012 19:15:56
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/24/2012 19:15:56
ORA-17628: Oracle error 19505 returned by remote Oracle server
主库alert报错信息:
Fri Aug 24 19:16:04 2012
Clearing standby activation ID 3277937203 (0xc3615a33)
The primary database controlfile was created using the
'MAXLOGFILES 16' clause.
There is space for up to 11 standby redo logfiles
Use the following SQL commands on the standby database to create
standby redo logfiles that match the primary database:
ALTER DATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE 536870912;
ALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE 536870912;
ALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 536870912;
ALTER DATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE 536870912;
ALTER DATABASE ADD STANDBY LOGFILE 'srl5.f' SIZE 536870912;
ALTER DATABASE ADD STANDBY LOGFILE 'srl6.f' SIZE 536870912;
WARNING: OMF is enabled on tbumch database. Creating a physical
standby controlfile, when OMF is enabled on the primary
database, requires manual RMAN intervention to resolve OMF
datafile pathnames.
NOTE: Please refer to the RMAN documentation for procedures
describing how to manually resolve OMF datafile pathnames.
Errors in file /u01/oracle/diag/rdbms/bumch_primary/bumch/trace/bumch_ora_11400.trc:
ORA-17628: Oracle error 19505 returned by remote Oracle server
Fri Aug 24 19:16:49 2012
Errors in file /u01/oracle/diag/rdbms/bumch_primary/bumch/trace/bumch_arc0_10827.trc:
ORA-16058: 未装载备用数据库实例
PING[ARC0]: Heartbeat failed to connect to standby 'bumch_standby_tt'. Error is 16058.