ORA-01274 in Dataguard

Standby database out of sync with primary due to missing datafile.

Errors in alertlog
MRP0: Background Media Recovery terminated with error 1274
Errors in file /u01/ofaroot/TEST/diag/diag/rdbms/TESTdr/TEST/trace/TEST_pr00_1486.trc:
ORA-01274: cannot add datafile ‘/u01/oradata/TEST/TEST/2014ro.dbf’ – file could not be created
Managed Standby Recovery not using Real Time Apply

Recovery stopped due to failure in applying recovery marker (opcode 17.30).
Datafiles are recovered to a consistent state at change 11276608262328 but controlfile could be ahead of datafiles.

Check status of files in Standby :

SQL> select file#,status from v$datafile where status <>’ONLINE’ and status<>’SYSTEM’;

FILE# STATUS
———- ——-
3 RECOVER
17 RECOVER

SQL> select file#,name from v$datafile where file# in (17,3);

FILE#
———-
NAME
——————————————————————————–
3
/uv1248/u01/oradata/TEST/TEST/undotbs01.dbf

17
/apps/oracle/product/11.2.0.3.2014CPUQ4/dbs/UNNAMED00017

Stop the recovery process on standby if it is not already

SQL> alter database recover managed standby database cancel;

Database altered.

Create datafile on standby database:

SQL> alter database create datafile ‘/apps/oracle/product/11.2.0.3.2014CPUQ4/dbs/UNNAMED00017’ as ‘/uv1248/u01/oradata/TEST/TEST/2014ro.dbf’ ;

Database altered.

SQL> alter system set standby_file_management=auto scope=both;

System altered.

Start the recovery process;

SQL> alter database recover managed standby database using current logfile disconnect from session;

Database altered.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s