Skip to content
  • Home
  • About Us
  • Contact Us
  • Terms And Conditions
orakldba – ORACLE Tutorial

orakldba - ORACLE Tutorial

  • Installation
  • Patching
  • Upgrade
  • Scripts
  • Oracle RAC
  • DataGuard
  • Oracle AVDF
  • TDE
  • Auditing
  • RMAN
  • DataPump
  • Multitenant
  • Operating System

ora 01524 cannot create datafile as

ORA-01274 cannot add data file that was originally created as

January 28, 2024July 4, 2023 by Prasanta
ORA-01274_ cannot add data file that was originally created as

ORA-01274: cannot add data file that was originally created as: In this paragraph i will discuss about ORA-01274 database error. When you getting ORA-01274 error follow below steps to resolve the issue. Problem: After adding a datafile in primary database, recovery process in standby database stopped with below error. Primary Side: After adding a datafile … Read more

Categories Data Guard, ORA-ERROR, Oracle 11g, Oracle 12c, Oracle 19c Tags alter database create datafile as new in standby, data file not created on standby, datafiles are recovered to a consistent state at change but controlfile could be ahead of datafiles, i am not able to add data file to tablespace what could be the issue, ora 01524 cannot create datafile as, ORA-01274, ORA-01274:, ORA-01274: cannot add data file, ORA-01274: cannot add data file that was originally created as, ora-01276: cannot add file standby, ora-01516: nonexistent log file data file or temporary file, ora-1274, standby_file_management 12c, standby_file_management 19c, standby_file_management is set to manual, standby_file_management=manual add datafile, the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL, unnamed file in standby database Leave a comment

Categories

  • ASM (4)
  • Cloning (2)
  • Data Guard (8)
    • Oracle 11g (3)
    • Oracle 12c (4)
    • Oracle 19c (6)
  • Data Pump (9)
    • Oracle 11g (3)
    • Oracle 12c (3)
    • Oracle 19c (4)
  • Database (64)
    • Oracle 11g (8)
    • Oracle 12c (25)
    • Oracle 19c (31)
  • Database Security (12)
    • Auditing (2)
    • Oracle AVDF (8)
    • TDE (2)
  • DB Tool (1)
  • Installation (19)
  • Multitenant (3)
  • MySQL Database (1)
  • ORA-ERROR (6)
  • Oracle AVDF (8)
  • OS (5)
  • Patching (14)
  • Performance & Tuning (3)
  • RAC (8)
    • Oracle 11g (1)
    • Oracle 19c (4)
  • RMAN (11)
  • Scripts (13)
  • Upgrade (2)
    • Oracle 12c to 19c (2)

Recent Posts

  • Oracle 23ai Installation on Linux
  • Manage Linux Firewall with firewalld and firewall-cmd
  • Apply RU 19.27 Patch on Oracle 19c RAC Environment
  • Apply RU 19.27 Patch on Oracle 19c Database
  • PRVG-2002 Encountered error in copying file /etc/nsswitch.conf

Recent Comments

  • Prasanta on Apply RU 19.27 Patch on Oracle 19c RAC Environment
  • Dba on Apply RU 19.27 Patch on Oracle 19c RAC Environment
  • Prasanta on Oracle 19c RAC Installation Steps on Linux 8
  • Rajibul on Oracle 19c RAC Installation Steps on Linux 8
  • Linkon M Gomes on Create Physical Standby Database Using RMAN Backup and Restore

Recent Posts

  • Oracle 23ai Installation on Linux
  • Manage Linux Firewall with firewalld and firewall-cmd
  • Apply RU 19.27 Patch on Oracle 19c RAC Environment
  • Apply RU 19.27 Patch on Oracle 19c Database
  • PRVG-2002 Encountered error in copying file /etc/nsswitch.conf
  • Oracle 19c RAC Installation Steps on Linux 8
  • How To Break And Restart A DataPump Export Or Import Job
  • How to Register a target database on AVDF console
  • Failed to generate executables for Host monitor
  • Host Monitor Agent installation on Linux

Categories

  • ASM (4)
  • Cloning (2)
  • Data Guard (8)
    • Oracle 11g (3)
    • Oracle 12c (4)
    • Oracle 19c (6)
  • Data Pump (9)
    • Oracle 11g (3)
    • Oracle 12c (3)
    • Oracle 19c (4)
  • Database (64)
    • Oracle 11g (8)
    • Oracle 12c (25)
    • Oracle 19c (31)
  • Database Security (12)
    • Auditing (2)
    • Oracle AVDF (8)
    • TDE (2)
  • DB Tool (1)
  • Installation (19)
  • Multitenant (3)
  • MySQL Database (1)
  • ORA-ERROR (6)
  • Oracle AVDF (8)
  • OS (5)
  • Patching (14)
  • Performance & Tuning (3)
  • RAC (8)
    • Oracle 11g (1)
    • Oracle 19c (4)
  • RMAN (11)
  • Scripts (13)
  • Upgrade (2)
    • Oracle 12c to 19c (2)

Like Us on Our Facebook Page

© 2025 orakldba - ORACLE Tutorial • Built with GeneratePress