Tags

Errors in file …/trace/RAPOR_pr00_2801804.trc:
ORA-01119: error in creating database file ‘/data/datafile_1.dbf’
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
IBM AIX RISC System/6000 Error: 13: Permission denied
File #4 added to control file as ‘UNNAMED00004’.
Originally created as:
‘/data/datafile_1.dbf’
Recovery was unable to create the file as:
‘/data/datafile_1.dbf’
WARNING: File being created with same name as in Primary
Existing file may be overwritten
Errors in file …/trace/RAPOR_pr00_2801804.trc:
ORA-01119: error in creating database file ‘/data/datafile_2.dbf’
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
IBM AIX RISC System/6000 Error: 13: Permission denied
File #26 added to control file as ‘UNNAMED00026’.
Originally created as:
‘/data/datafile_2.dbf’
Recovery was unable to create the file as:
‘/data/datafile_2.dbf’
Errors with log …/1_140743_714484088.dbf
MRP0: Background Media Recovery terminated with error 1274
Errors in file …/trace/RAPOR_pr00_2801804.trc:
ORA-01274: cannot add datafile ‘/data/datafile_2.dbf’ – file could not be created
Recovery interrupted!
Recovery stopped due to failure in applying recovery marker (opcode 17.30).
Datafiles are recovered to a consistent state at change 139094692621 but controlfile could be ahead of datafiles.
Mon Sep 23 12:27:01 2013
MRP0: Background Media Recovery process shutdown (RAPOR)


select file#,name from v$datafile where name like '%UNNAMED%';
alter system set standby_file_management='manual';

alter database create datafile '/rapor/oracle/11203/dbs/UNNAMED00026' as '/data/datafile_2.dbf';
alter database create datafile '/rapor/oracle/11203/dbs/UNNAMED00004' as '/data/datafile_1.dbf';

alter system set standby_file_management='auto';
alter database recover managed standby database disconnect from session;

select process, status, thread#, sequence#, block#, blocks from v$managed_standby;

Advertisements