Oracle Database Discussions

Hi

We have a dataguard setup on production environment - Oracle Database Version - 10.2.0.4.0

It is running smoothly from 4 months onwards. All datafiles on primary database are with AUTOEXTEND=YES.

standby_file_management is set to AUTO on both primary and standby

Four days back from SAP application using BRTools front end datafile was resized on primary by increasing 1GB.

But it got failed on physical standby due to lack of space.

After four days we got an email from client about this. But till now up to date archive logs are shipping from primary to standby.As of now on both the servers archivelogs are physically same.

But last applied archivelog on standby is four days back.After that datafile resize on primary, no archivelog got applied on standby.But physically archive logs are shipping from primary to standby.

Now filesystem on physical standby server got resized. After filesystem resizing also archivelogs are not applying and filesize on physical standby didn't got changed.

Please help us how to go ahead in this situation.Please find the alert log error on standby and datafile state on standby.

RFS[12]: Archived Log: '/oracle/P46/oraarch/P46arch1_66465_630023497.dbf'
Tue Jan 26 19:18:43 2010
Media Recovery Log /oracle/P46/oraarch/P46arch1_66465_630023497.dbf
Media Recovery Waiting for thread 1 sequence 66466
Tue Jan 26 19:39:10 2010
RFS[13]: Archived Log: '/oracle/P46/oraarch/P46arch1_66466_630023497.dbf'
Tue Jan 26 19:39:14 2010
Media Recovery Log /oracle/P46/oraarch/P46arch1_66466_630023497.dbf
Media Recovery Waiting for thread 1 sequence 66467
Tue Jan 26 19:54:24 2010
RFS[12]: Archived Log: '/oracle/P46/oraarch/P46arch1_66467_630023497.dbf'
Tue Jan 26 19:54:27 2010
Media Recovery Log /oracle/P46/oraarch/P46arch1_66467_630023497.dbf
Errors with log /oracle/P46/oraarch/P46arch1_66467_630023497.dbf
MRP0: Background Media Recovery terminated with error 1237
Tue Jan 26 19:54:31 2010
Errors in file /oracle/P46/saptrace/background/p46_mrp0_26152.trc:
ORA-01237: cannot extend datafile 25
ORA-01110: data file 25: '/oracle/P46/sapdata4/datdb_5/datdb.data5'
ORA-19502: write error on file "/oracle/P46/sapdata4/datdb_5/datdb.data5", blockno 877696 (blocksize=8192)
ORA-27072: File I/O error
HPUX-ia64 Error: 11: Resource temporarily unavailable
Additional information: 4
Additional information: 877696
Additional information: 630784
Some recovered datafiles maybe left media fuzzy
Media recovery may continue but open resetlogs may fail
Tue Jan 26 19:54:31 2010
Errors in file /oracle/P46/saptrace/background/p46_mrp0_26152.trc:
ORA-01237: cannot extend datafile 25
ORA-01110: data file 25: '/oracle/P46/sapdata4/datdb_5/datdb.data5'
ORA-19502: write error on file "/oracle/P46/sapdata4/datdb_5/datdb.data5", blockno 877696 (blocksize=8192)
ORA-27072: File I/O error
HPUX-ia64 Error: 11: Resource temporarily unavailable
Additional information: 4
Additional information: 877696
Additional information: 630784
Tue Jan 26 19:54:31 2010
MRP0: Background Media Recovery process shutdown (P46)
Tue Jan 26 20:00:35 2010
RFS[13]: Archived Log: '/oracle/P46/oraarch/P46arch1_66468_630023497.dbf'
Tue Jan 26 20:06:40 2010
RFS[12]: Archived Log: '/oracle/P46/oraarch/P46arch1_66469_630023497.dbf'
Tue Jan 26 20:18:20 2010

Standby server:

SQL> select file#, status, name, bytes from v$datafile where status='RECOVER';

FILE# STATUS
---------- -------
NAME
--------------------------------------------------------------------------------
BYTES
----------
25 RECOVER
/oracle/P46/sapdata4/datdb_5/datdb.data5
*7172259840*

Primary server:

SQL> select file#, status, name, bytes from v$datafile where file#=25;

FILE# STATUS
---------- -------
NAME
--------------------------------------------------------------------------------
BYTES
----------
25 ONLINE
/oracle/P46/sapdata4/datdb_5/datdb.data5
*8413773824*


Thank you...