oracle 16058,11g 通过 RMAN duplicate 搭建 active standby报错

描述:

主库(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.

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值