Causes:

备库由于服务器空间不足,在参数standby_file_management=auto时,创建数据文件失败,日志如下:

Sat Sep 19 23:42:23 2009
File #70 added to control file as 'UNNAMED00070'. Originally created as:
'/u03/PROD/proddata/perfstat02.dbf'
Recovery was unable to create the file as:
'/d03/PROD/proddata/perfstat02.dbf'
Sat Sep 19 23:43:06 2009
MRP0: Background Media Recovery terminated with error 1274
Sat Sep 19 23:43:06 2009
Errors in file /d01/proddb/9.2.0/admin/PROD_oraebs02/bdump/prod_mrp0_22497.trc:
ORA-01274: cannot add datafile '/u03/PROD/proddata/perfstat02.dbf' - file could not be created
ORA-19502: write error on file "/d03/PROD/proddata/perfstat02.dbf", blockno 109569 (blocksize=8192)
ORA-27063: skgfospo: number of bytes read/written is incorrect
SVR4 Error: 28: No space left on device
Additional information: -1
Additional information: 1048576
ORA-19502: write error on file "/d03/PROD/proddata/perfstat02.dbf", blockno 110081 (blocksize=8192)
ORA-27063: skgfospo: number of bytes read/written is incorrect
Additional information: 32768
Additional information: 1048576
Some recovered datafiles maybe left media fuzzy
Media recovery may continue but open resetlogs may fail

Solutions:

SQL> alter system set standby_file_management = manual;

System altered.

SQL> alter database create datafile '/d03/PROD/proddata/perfstat02.dbf' as '/d01/proddb/9.2.0/dbs/UNNAMED00070';
alter database create datafile '/d03/PROD/proddata/perfstat02.dbf' as '/d01/proddb/9.2.0/dbs/UNNAMED00070'
*
ERROR at line 1:
ORA-01516: nonexistent log file, datafile, or tempfile
"/d03/PROD/proddata/perfstat02.dbf"


SQL> alter database create datafile '/d01/proddb/9.2.0/dbs/UNNAMED00070' as '/d03/PROD/proddata/perfstat02.dbf';

Database altered.


SQL> recover managed standby database disconnect from session;


此种恢复数据文件方法,一般用户,数据文件损坏,没有备份,但有自此数据文件创建以来的所有归档日志时使用.

注：
如果数据文件有offline drop过，在恢复前，一定要将此文件online, 然后再恢复。因为oracle recover时，是不恢复offline文件的。切记！

另如上恢复所需日志文件过大,或者日志不全,可使用以下链接方法:
hi.baidu.com/flying_hg/blog/item/8d4a24d3534f193e970a16cb.html