Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ora-00354 on standby site on physical database

ora-00354 on standby site on physical database

From: PJP <parag9i_at_gmail.com>
Date: 6 Nov 2006 07:37:05 -0800
Message-ID: <1162827425.126093.26960@f16g2000cwb.googlegroups.com>


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.

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, 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.

thanks & regards
PJP Received on Mon Nov 06 2006 - 09:37:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US