Software Knowledge

  1. Home
  2. Docs
  3. Software Knowledge
  4. Database
  5. Oracle: Error dataguard due to add more datafiles
Generic selectors
Exact matches only
Search in title
Search in content

Oracle: Error dataguard due to add more datafiles

When add more datafile from the primary server, the folder at secondary server must be prepared before added a new one. If forgotten to prepare the folder, the error can be coccurred and the new datafile will be registered with UNNAMExxxx

Example

=======================================

[[email protected]]:/oracle/PRD/sapdata2>su – oraprd

[YOU HAVE NEW MAIL]

saperp01:oraprd 1> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 – Production on Mon May 29 13:21:11 2017

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup nomount;

ORACLE instance started.

Total System Global Area 1.0284E+10 bytes

Fixed Size 2101008 bytes

Variable Size 6241124592 bytes

Database Buffers 4026531840 bytes

Redo Buffers 14675968 bytes

SQL> alter database mount standby database;

Database altered.

SQL> alter system set standby_file_management=MANUAL ;

System altered.

SQL> alter database recover managed standby database cancel;

alter database recover managed standby database cancel

*

ERROR at line 1:

ORA-16136: Managed Standby Recovery not active

SQL> alter database create datafile ‘/oracle/PRD/102_64/dbs/UNNAMED00051’ as ‘/oracle/PRD/sapdata2/sr3_28/sr3.data28’;

Database altered.

SQL> alter system set standby_file_management=AUTO;

System altered.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

Database altered.