Re: ora-00354 on standby site on physical database

Comments embedded.
PJP wrote:
> Hi,
>
> Hi,
>
> I am in Process of creating physical standby database with standby redo
> logs on
> 9.2.0.3 on Windows box. I am facing ora-00354 on standby database. I am
> not able
> to trace the cause of an error.
>

How, exactly, did you create this standby database? What exact steps did you follow?

> Primary Init File
>
> *._always_anti_join='OFF'
> *._always_semi_join='OFF'
> *.aq_tm_processes=1
> *.background_dump_dest='F:\oracle\admin\orcl\bdump'
> *.compatible='9.2.0.0.0'
> *.control_files='F:\oracle\oradata\orcl\CONTROL01.CTL','F:\oracle\oradata\orcl\CO
> NTROL02.CTL','F:\oracle\oradata\orcl\CONTROL03.CTL'
> *.core_dump_dest='F:\oracle\admin\orcl\cdump'
> *.db_block_size=8192
> *.db_cache_size=367001600
> *.db_domain=''
> *.db_file_multiblock_read_count=16
> *.db_name='orcl'
> *.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
> *.fast_start_mttr_target=300
> *.hash_join_enabled=TRUE
> *.instance_name='orcl'
> *.java_pool_size=33554432
> *.job_queue_processes=10
> *.large_pool_size=8388608
> *.log_buffer=10485760
> *.open_cursors=300
> *.optimizer_index_caching=90
> *.optimizer_index_cost_adj=10
> *.optimizer_max_permutations=1000
> *.pga_aggregate_target=524288000
> *.processes=150
> *.query_rewrite_enabled='FALSE'
> *.remote_login_passwordfile='EXCLUSIVE'
> *.sga_max_size=838860800
> *.shared_pool_size=367001600
> *.sort_area_size=10485760
> *.star_transformation_enabled='FALSE'
> *.timed_statistics=FALSE
> *.undo_management='AUTO'
> *.undo_retention=10800
> *.undo_tablespace='UNDOTBS1'
> *.user_dump_dest='F:\oracle\admin\orcl\udump'
>
> ### PRIMARY DATABASE PRIMARY ROLE PARAMETERS
> *.log_archive_dest_1='location=F:\payprodarchive MANDATORY'
> *.log_archive_dest_2='SERVICE=dr LGWR SYNC AFFIRM'
> *.log_archive_dest_state_1='enable'
> *.log_archive_dest_state_2='enable'
> *.log_archive_format=%d_%t_%s.arc
> *.log_archive_start=TRUE
> *.remote_archive_enable=TRUE
>
> ### PRIMARY DATABASE STANDBY ROLE PARAMETERS
> *.FAL_SERVER=dr
> *.FAL_CLIENT=orcl
> *.STANDBY_ARCHIVE_DEST=F:\payprodarchive
> *.standby_file_management=auto
>
> Standby init file
>
> *._always_anti_join='OFF'
> *._always_semi_join='OFF'
> *.aq_tm_processes=1
> *.compatible='9.2.0.0.0'
> *.db_block_size=8192
> *.db_cache_size=367001600
> *.db_domain=''
> *.db_file_multiblock_read_count=16
> *.db_name='orcl'
> *.fast_start_mttr_target=300
> *.hash_join_enabled=TRUE
> *.java_pool_size=33554432
> *.job_queue_processes=10
> *.large_pool_size=8388608
> *.log_buffer=10485760
> *.open_cursors=300
> *.optimizer_index_caching=90
> *.optimizer_index_cost_adj=10
> *.optimizer_max_permutations=1000
> *.pga_aggregate_target=524288000
> *.processes=150
> *.query_rewrite_enabled='FALSE'
> *.sga_max_size=838860800
> *.shared_pool_size=367001600
> *.sort_area_size=10485760
> *.star_transformation_enabled='FALSE'
> *.timed_statistics=FALSE
> *.undo_management='AUTO'
> *.undo_retention=10800
> *.undo_tablespace='UNDOTBS1'
>
> ### STANDBY DATABASE STANDBY ROLE PARAMETERS
> *.control_files='D:\PAYPRODDR\CONTROL09.CTL'
> *.db_file_name_convert=('f:\oracle\oradata\orcl\','d:\payproddr\')
> *.log_file_name_convert=('f:\oracle\oradata\orcl\','d:\payproddr\')
> *.log_archive_dest_1='location=d:\payproddr\Archive MANDATORY'
> *.log_archive_dest_state_1='enable'
> *.log_archive_format=%d_%t_%s.arc
> *.log_archive_start=TRUE
> *.FAL_SERVER=orcl
> *.FAL_CLIENT=dr
> *.STANDBY_ARCHIVE_DEST=d:\payproddr\Archive
> *.standby_file_management=auto
> *.background_dump_dest='c:\oracle\admin\orcldr2\bdump'
> *.core_dump_dest='c:\oracle\admin\orcldr2\cdump'
> *.user_dump_dest='c:\oracle\admin\orcldr2\udump'
> #*.remote_login_passwordfile='EXCLUSIVE'
> #*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
> *.remote_archive_enable=TRUE
> *.lock_name_space='orcldr2'
> *.instance_name='orcldr2'
>
> ### PRIMARY DATABASE STANDBY ROLE PARAMETERS
> #*.log_archive_dest_2='location=F:\payprodarchive MANDATORY'
> #*.log_archive_dest_state_2='enable'
>
> after adding standby redo logs on standby, If I do shutdown and startup
> standby
> database,

Again, what are the exact commands you're using? What precisely do you mean by 'startup standby database'?

> and do switchlog on primary then If I do switch on primay
> database, I am getting following error in alert of standby site
>
> on Nov 06 20:41:32 2006
> RFS: Successfully opened standby logfile 4:
> 'D:\PAYPRODDR\STANDBYLOGFILES\LOGFILE1.LOG'
> Mon Nov 06 20:41:32 2006
> ARC1: Evaluating archive log 4 thread 1 sequence 111
> ARC1: Beginning to archive log 4 thread 1 sequence 111
> Creating archive destination LOG_ARCHIVE_DEST_1:
> 'D:\PAYPRODDR\ARCHIVE\1133324794_1_111.ARC'
> Mon Nov 06 20:41:32 2006
> RFS: Standby redo log 4 thread 1 sequence 111 is being archived
> Mon Nov 06 20:41:32 2006
> ARC1: Log corruption near block 116 change 0 time ?
> ARC1: All Archive destinations made inactive due to error 354
> Mon Nov 06 20:41:33 2006
> Errors in file c:\oracle\admin\orcldr2\bdump\orcldr2_arc1_1384.trc:
> ORA-00354: corrupt redo log block header
> ORA-00353: log corruption near block 116 change 0 time 11/06/2006
> 20:37:02
> ORA-00312: online log 4 thread 1:
> 'D:\PAYPRODDR\STANDBYLOGFILES\LOGFILE1.LOG'
>
> ARC1: Archiving not possible: error count exceeded
> ARC1: Failed to archive log 4 thread 1 sequence 111
> Clearing standby logfile 4 thread 1 sequence 111 due to error 354
> ARCH: Archival stopped, error occurred. Will continue retrying
> Mon Nov 06 20:41:33 2006
> RFS: Successfully opened standby logfile 4:
> 'D:\PAYPRODDR\STANDBYLOGFILES\LOGFILE1.LOG'
> Mon Nov 06 20:41:33 2006
> ARCH:
> Mon Nov 06 20:41:33 2006
> ORA-16038: log 4 sequence# 111 cannot be archived
> ORA-00354: corrupt redo log block header
> ORA-00312: online log 4 thread 1:
> 'D:\PAYPRODDR\STANDBYLOGFILES\LOGFILE1.LOG'
>
> Mon Nov 06 20:41:33 2006
> Errors in file c:\oracle\admin\orcldr2\bdump\orcldr2_arc1_1384.trc:
> ORA-16038: log 4 sequence# 111 cannot be archived
> ORA-00354: corrupt redo log block header
> ORA-00312: online log 4 thread 1:
> 'D:\PAYPRODDR\STANDBYLOGFILES\LOGFILE1.LOG'
>
> Mon Nov 06 20:41:40 2006
> Media Recovery Log D:\PAYPRODDR\ARCHIVE\1133324794_1_111.ARC
> Media Recovery Waiting for thread 1 seq# 112 (in transit)
> Mon Nov 06 20:44:40 2006
> Archiver process freed from errors. No longer stopped
> Mon Nov 06 20:46:24 2006
> alter database recover managed standby database cancel
> Mon Nov 06 20:46:27 2006
> MRP0: Background Media Recovery user canceled with status 16037
> MRP0: Background Media Recovery process shutdown
> Mon Nov 06 20:46:28 2006
> Managed Standby Recovery Cancelled
> Completed: alter database recover managed standby database ca
> Mon Nov 06 20:46:44 2006
> alter database open read only
> Mon Nov 06 20:46:44 2006
> SMON: enabling cache recovery
> Mon Nov 06 20:46:45 2006
> Database Characterset is WE8MSWIN1252
> replication_dependency_tracking turned off (no async multimaster
> replication
> found)
> Completed: alter database open read only
> Mon Nov 06 20:47:00 2006
> ***Warning - Executing transaction without active Undo Tablespace
> Mon Nov 06 20:47:04 2006
> Restarting dead background process QMN0
> QMN0 started with pid=9
> Mon Nov 06 20:48:06 2006
> ***Warning - Executing transaction without active Undo Tablespace
> Mon Nov 06 20:52:16 2006
> Restarting dead background process QMN0
> QMN0 started with pid=9
> Mon Nov 06 20:53:19 2006
> ***Warning - Executing transaction without active Undo Tablespace
> ***Warning - Executing transaction without active Undo Tablespace
>
> Kindly help me regarding ora-00354 error.
>

Provide the information requested.

> thanks & regards
> PJP
David Fitzjarrell Received on Mon Nov 06 2006 - 10:38:25 CST