Skip to main content

Posts

Showing posts from November, 2024

RESTORE AND RECOVERING A SYSTEM DATAFILE OF CDB$ROOT CONTAINER DATABASE 19C

  RESTORE AND RECOVERING A SYSTEM DATAFILE OF CDB$ROOT CONTAINER DATABASE 19C   SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 31 17:20:29 2024 Version 19.3.0.0.0   Copyright (c) 1982, 2019, Oracle.  All rights reserved.   Enter user-name: / as sysdba   Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0   SQL> select file_name from dba_data_files;   FILE_NAME --------------------------------------------------------------------------- D:\ORACLE19\DB19C\ORADATA\ORCL\SYSTEM01.DBF  -- DELETED SYSTEM DATAFILE D:\ORACLE19\DB19C\ORADATA\ORCL\SYSAUX01.DBF D:\ORACLE19\DB19C\ORADATA\ORCL\UNDOTBS01.DBF D:\ORACLE19\DB19C\ORADATA\ORCL\USERS01.DBF D:\ORACLE19\DB19C\DBFILE\KRISHNA.DBF   SQL> show con_name;   CON_NAME ------------------------------ CDB$ROOT   SHUTDOWN THE DATABASE:   SQL> shut immediate Datab...