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