Home » RDBMS Server » Server Administration » ORA-00308: cannot open archived log (10g (RAC), 10.2.0.4, hp unix)
ORA-00308: cannot open archived log [message #626077] Mon, 20 October 2014 07:54 Go to next message
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 #626078 is a reply to message #626077] Mon, 20 October 2014 07:56 Go to previous messageGo to next message
BlackSwan
Messages: 26187
Registered: January 2009
Location: SoCal
Senior Member
>HPUX-ia64 Error: 2: No such file or directory
>Additional information: 3

Either file or directory does not exist or oracle user does not have sufficient OS file permissions
Re: ORA-00308: cannot open archived log [message #626079 is a reply to message #626077] Mon, 20 October 2014 08:03 Go to previous messageGo to next message
John Watson
Messages: 7615
Registered: January 2010
Location: Global Village
Senior Member
Which instance is running on what you call "node1" ?
Re: ORA-00308: cannot open archived log [message #626080 is a reply to message #626077] Mon, 20 October 2014 08:08 Go to previous messageGo to next message
Michel Cadot
Messages: 65840
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

And post the result of:
id (for the account that started the instance)
ls -l /oltp2_arch2/genconf/arch/log_7628d0a0_2_24792_765657634.arc
ls -ld /oltp2_arch2/genconf/arch/
ls -ld /oltp2_arch2/genconf/
ls -ld /oltp2_arch2/

Re: ORA-00308: cannot open archived log [message #626081 is a reply to message #626080] Mon, 20 October 2014 08:16 Go to previous messageGo to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear 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.
Re: ORA-00308: cannot open archived log [message #626082 is a reply to message #626081] Mon, 20 October 2014 08:22 Go to previous messageGo to next message
BlackSwan
Messages: 26187
Registered: January 2009
Location: SoCal
Senior Member
>But log shipping is successfully applying.

ERRORS disagree with statement above.
Re: ORA-00308: cannot open archived log [message #626083 is a reply to message #626081] Mon, 20 October 2014 08:23 Go to previous messageGo to next message
John Watson
Messages: 7615
Registered: January 2010
Location: Global Village
Senior Member
ashishkumarmahanta80 wrote on Mon, 20 October 2014 14:16
Dear 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 Go to previous messageGo to next message
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 Go to previous message
John Watson
Messages: 7615
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.
Previous Topic: Temp tablespace size
Next Topic: How to set password login / as sysdba sqlplus on database oracle 11g
Goto Forum:
  


Current Time: Tue Oct 16 14:22:06 CDT 2018