Saturday, April 7, 2018

Cannot extend datafile

ORA-01237: cannot extend datafile 329


MRP0: Background Media Recovery terminated with error 1237
Errors in file /PRODDG/ora01/oracle/product/11.2.0/log/diag/rdbms/proddg/PRODDG/trace/PRODDG_pr00_51445938.trc:
ORA-01237: cannot extend datafile 329
ORA-01110: data file 329: '/PRODDG/data04/APPS_TS_TX_IDX_1602241600.dbf'
ORA-27072: File I/O error
Additional information: 2

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert                 string      /PROD/data01/, /PRODDG/data01/
                                                 , /PROD/data02/, /PRODDG/data0
                                                 2/, /PROD/data03/, /PRODDG/dat
                                                 a03/, /PROD/data04/, /PRODDG/d
                                                 ata04/



  Looks like the redo logs are in consuming space in data04.  We need to relocate those to /PRODDG/arch01.  It is sized larger that the production arch01.  So, you need to change standby file management to manual, drop the redo log groups, and re-create them in /PRODDG/arch01.  Then you will have to reset standby file management back to auto.  Please work up steps and send to us for review before implementing. 
We also need to modify the log name file convert parameter in case the Dataguard gets rebuilt in the future.



No comments:

Post a Comment