ORA-01119/ORA-01111

Thu Feb 17 22:11:29 EST 2011
File #51 added to control file as 'UNNAMED00051'.
Originally created as:
'+DATA02/infra/datafile/geneos_data.262.743357055'
Recovery was unable to create the file as:
'+ITPDR_DATA01'
Errors with log +ITPDR_ARCH/infra20/archivelog/2011_02_17/thread_1_seq_22690.586.743364737
MRP0: Background Media Recovery terminated with error 1119
Thu Feb 17 22:11:29 EST 2011
Errors in file /u01/app/oracle/admin/infra0/bdump/infra0_mrp0_1282.trc:
ORA-01119: error in creating database file '+ITPDR_DATA01'
ORA-17502: ksfdcre:4 Failed to create file +ITPDR_DATA01
ORA-15041: diskgroup space exhausted
Some recovered datafiles maybe left media fuzzy
Media recovery may continue but open resetlogs may fail
Thu Feb 17 22:11:31 EST 2011
Errors in file /u01/app/oracle/admin/infra0/bdump/infra0_mrp0_1282.trc:
ORA-01119: error in creating database file '+ITPDR_DATA01'
ORA-17502: ksfdcre:4 Failed to create file +ITPDR_DATA01
ORA-15041: diskgroup space exhausted
Thu Feb 17 22:11:31 EST 2011
MRP0: Background Media Recovery process shutdown (infra0)


22:25:18 SYS@infra0 SQL> select * from v$datafile where name like '%UNNAMED%';

FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE# STATUS ENABLED CHECKPOINT_CHANGE# CHECKPOINT_TIME UNRECOVERABLE_CHANGE# UNRECOVERABLE_TIME LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE# ONLINE_TIME BYTES BLOCKS
---------- ---------------- -------------------- ---------- ---------- ------ ---------- ------------------ ------------------------------ --------------------- -------------------- ------------ -------------------- --------------- -------------- -------------------- ---------- ----------
CREATE_BYTES BLOCK_SIZE NAME PLUGGED_IN BLOCK1_OFFSET
------------ ---------- ------------------------------ ---------- -------------
AUX_NAME
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGED_TIME
------------------- --------------------
51 1.3522E+11 17-FEB-2011 16:06:41 26 51 RECOVE READ WRITE 1.3522E+11 17-FEB-2011 16:06:41 0 0 0 0 0
8589934592 8192 /u01/app/oracle/product/10.2.0 0 4294967295
.5/db_1/dbs/UNNAMED00051
UNKNOWN
0


1 row selected.

Elapsed: 00:00:01.45

22:34:05 SYS@infra0 SQL> show parameter standby

NAME TYPE VALUE
------------------------------------ ------------ ------------------------------
standby_archive_dest string +ITPDR_ARCH
standby_file_management string AUTO
22:34:10 SYS@infra0 SQL> alter system set standby_file_management=manual;

System altered.

Elapsed: 00:00:00.18

22:35:19 SYS@infra0 SQL> alter database create datafile '/u01/app/oracle/product/10.2.0.5/db_1/dbs/UNNAMED00051' as '+DATA02' size 8192m;

Database altered.

Elapsed: 00:01:45.27
22:37:44 SYS@infra0 SQL> alter system set standby_file_management=auto scope=both ;

System altered.

Elapsed: 00:00:00.08
22:37:50 SYS@infra0 SQL> alter database recover managed standby database disconnect from session;

Database altered.

Elapsed: 00:00:07.12
22:38:19 SYS@infra0 SQL> exit


Check if mrp is started and logs are getting applied
[wbeqdora7:oracle]/u01/app/oracle/admin/infra0/bdump> tail -f alert_infra0.log
SUCCESS: diskgroup DATA02 was mounted
Thu Feb 17 22:38:17 EST 2011
parallel recovery started with 7 processes
Thu Feb 17 22:38:19 EST 2011
Waiting for all non-current ORLs to be archived...
SUCCESS: diskgroup ITPDR_ARCH was mounted
Media Recovery Log +ITPDR_ARCH/infra20/archivelog/2011_02_17/thread_1_seq_22690.586.743364737
Media Recovery Log +ITPDR_ARCH/infra20/archivelog/2011_02_17/thread_2_seq_29220.464.743358599
Thu Feb 17 22:38:19 EST 2011
Completed: alter database recover managed standby database disconnect from session
Thu Feb 17 22:38:40 EST 2011
Media Recovery Log +ITPDR_ARCH/infra20/archivelog/2011_02_17/thread_2_seq_29221.368.743362199
Thu Feb 17 22:38:54 EST 2011
Media Recovery Log +ITPDR_ARCH/infra20/archivelog/2011_02_17/thread_2_seq_29222.348.743364745
Thu Feb 17 22:39:04 EST 2011
Media Recovery Log +ITPDR_ARCH/infra20/archivelog/2011_02_17/thread_2_seq_29223.610.743364765
Media Recovery Log +ITPDR_ARCH/infra20/archivelog/2011_02_17/thread_1_seq_22691.433.743364765
Media Recovery Delayed for 240 minute(s) (thread 1 sequence 22692)