| ORA-00308: cannot open archived log [message #626077] |
Mon, 20 October 2014 07:54  |
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
|
Senior Member |
|
|
Dear All,
In alert-log of primary database (node1),below error occurred.
Mon Oct 20 14:17:56 IST 2014
Errors in file /u01/oracle/product/admin/genconf/bdump/genconf1_arc1_1349.trc:
ORA-00308: cannot open archived log '/oltp2_arch2/genconf/arch/log_7628d0a0_2_24792_765657634.arc'
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3
Below is the pfile of node1,
genconf2.__db_cache_size=25602031616
genconf1.__db_cache_size=25602031616
genconf2.__java_pool_size=117440512
genconf1.__java_pool_size=117440512
genconf1.__large_pool_size=16777216
genconf2.__large_pool_size=16777216
genconf2.__shared_pool_size=6442450944
genconf1.__shared_pool_size=6442450944
genconf1.__streams_pool_size=0
genconf2.__streams_pool_size=0
*._gc_defer_time=0
*.audit_file_dest='/u01/oracle/product/admin/genconf/adump'
*.background_dump_dest='/u01/oracle/product/admin/genconf/bdump'
*.cluster_database_instances=2
*.cluster_database=true
*.compatible='10.2.0.5.0'
*.control_files='+REDOCTLDG/genconf/controlfile/current.258.765657633','+REDOCTLDG/genconf/controlfile/current.257.765657633'
,'+REDOCTLDG/genconf/controlfile/current.256.765657633'
*.core_dump_dest='/u01/oracle/product/admin/genconf/cdump'
*.cursor_sharing='SIMILAR'
*.db_block_size=8192
*.db_cache_size=30064771072
*.db_create_file_dest='+DATA1DG'
*.db_create_online_log_dest_1='+REDOCTLDG'
*.db_create_online_log_dest_2='+REDOCTLDG'
*.db_create_online_log_dest_3='+REDOCTLDG'
*.db_domain=''
*.db_file_multiblock_read_count=8
*.db_name='genconf'
*.db_recovery_file_dest='+FLASHDG'
*.db_recovery_file_dest_size=504658657280
*.db_unique_name='genconf'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=genconfXDB)'
*.fal_client='genconf'
*.fal_server='gendr'
*.global_names=FALSE
genconf1.instance_number=1
genconf2.instance_number=2
*.job_queue_processes=10
genconf1.local_listener='(address=(protocol=tcp)(port=1521)(host=uigcdb01-vip))'
genconf2.local_listener='(address=(protocol=tcp)(port=1521)(host=uigcdb02-vip))'
*.log_archive_config='dg_config =(genconf,genstby,gendr)'
genconf1.log_archive_dest_1='LOCATION=/oltp1_arch1/genconf/arch valid_for=(online_logfiles,all_roles) db_unique_name=genconf'
genconf2.log_archive_dest_1='LOCATION=/oltp2_arch2/genconf/arch valid_for=(online_logfiles,all_roles) db_unique_name=genconf'
*.log_archive_dest_2='SERVICE=genstby LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=genstby'
genconf1.log_archive_dest_3='location=/oltp1_arch1/genconf/arch/stan valid_for=(standby_logfiles,standby_role) db_unique_name
=genconf'
genconf2.log_archive_dest_3='location=/oltp2_arch2/genconf/arch/stan valid_for=(standby_logfiles,standby_role) db_unique_name
=genconf'
*.log_archive_dest_4='SERVICE=gendr LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=gendr'
*.log_archive_dest_9=''
*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='enable'
*.log_archive_dest_state_3='enable'
*.log_archive_dest_state_4='enable'
*.log_archive_format='log_%d_%t_%s_%r.arc'
*.log_archive_max_processes=10
*.nls_date_format='dd/MM/yyyy'
*.open_cursors=5000
*.optimizer_mode='CHOOSE'
*.pga_aggregate_target=17179869184
*.processes=2000
*.query_rewrite_enabled='TRUE'
*.remote_listener='LISTENERS_GENCONF'
*.remote_login_passwordfile='exclusive'
*.resource_limit=TRUE
*.session_cached_cursors=400
*.sessions=3500
*.sga_max_size=42949672960
*.sga_target=0
*.shared_pool_size=10737418240
*.standby_file_management='AUTO'
genconf2.thread=2
genconf1.thread=1
*.transactions=2500
*.undo_management='AUTO'
*.undo_retention=10800
genconf2.undo_tablespace='UNDOTBS2'
genconf1.undo_tablespace='UNDOTBS1'
Just want to know that, Node1, primary database generates archive logs and shipped to standby. Then why error is occurring at node1, primary database?
Please assist me to know the concept of it.
Regards,
Ashish Kumar Mahanta
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: ORA-00308: cannot open archived log [message #626083 is a reply to message #626081] |
Mon, 20 October 2014 08:23  |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
ashishkumarmahanta80 wrote on Mon, 20 October 2014 14:16Dear All,
Mentioned archive log is not available at the desired path. But log shipping is successfully applying. That is my major concern.
Dear Mr Michel,
Node1 is genconf1.
That paramater file states that instance genconf1 will attempt to archive to /oltp1_arch1/genconf/arch and to /oltp1_arch1/genconf/arch/stan. It is not possible for this instance to report an error writing to /oltp2_arch2/genconf/arch/log_7628d0a0_2_24792_765657634.arc.
You have made a mistake in describing the environment, you need to try again. And you need to answer MC's questions.
--update: I notice that thread is wrong as well. Your error has to be coming from the instance genconf2.
[Updated on: Mon, 20 October 2014 08:24] Report message to a moderator |
|
|
|
| Re: ORA-00308: cannot open archived log [message #626116 is a reply to message #626083] |
Tue, 21 October 2014 00:45 |
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
|
Senior Member |
|
|
Dear Mr. Michel,
Please find the details as requested -
oracle@uigcdb02[genconf2]:/oltp2_arch2/genconf/arch$ ls -l log_7628d0a0_2_24792_765657634.arc
log_7628d0a0_2_24792_765657634.arc not found
oracle@uigcdb02[genconf2]:/oltp2_arch2/genconf/arch$ ls -ld
drwxr-x--- 2 oracle oinstall 68608 Oct 21 11:02 .
oracle@uigcdb02[genconf2]:/oltp2_arch2/genconf/arch$ cd ..
oracle@uigcdb02[genconf2]:/oltp2_arch2/genconf$ ls -ld
drwxr-x--- 5 oracle oinstall 96 Jul 26 16:33 .
oracle@uigcdb02[genconf2]:/oltp2_arch2/genconf$ cd ..
oracle@uigcdb02[genconf2]:/oltp2_arch2$ ls -ld
drwxrwxr-x 4 oracle oinstall 96 Sep 14 2013 .
oracle@uigcdb02[genconf2]:/oltp2_arch2$
Dear Mr. John,
It is not possible for this instance to report an error writing to /oltp2_arch2/genconf/arch/log_7628d0a0_2_24792_765657634.arc.
Please check my alert log of genconf1 -
Errors in file /u01/oracle/product/admin/genconf/bdump/genconf1_arc1_1349.trc:
ORA-00308: cannot open archived log '/oltp2_arch2/genconf/arch/log_7628d0a0_2_24792_765657634.arc'
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3
Here, it shows trace file at genconf1 but referring to genconf2 archive destination archive log. Alert log of genconf1 is also attached for your reference.
Need to valuable feedback on it.
Regards,
Ashish Kumar Mahanta
[Updated on: Tue, 21 October 2014 00:59] Report message to a moderator |
|
|
|
| Re: ORA-00308: cannot open archived log [message #626125 is a reply to message #626116] |
Tue, 21 October 2014 02:03 |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
It now becomes clear. The messages (which are not errors, merely informative) are caused by the fetch archive log mechanism, as your standby tries to locate copies of archive logs. It appears that you have two standbys, so you could eliminate the messages and take some stress off your primary by adjusting the FAL_SERVER parameter in your standbys to direct them to each other for missing logs, rather than to the primary.
You should also archive both threads to a shared destination (you have a fast recovery area: use it) which would be a better solution in many ways.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
