Skip to main content

Posts

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 Database closed. Database dismounted. ORACLE instance shut down.
Recent posts

Issues and Solutions for Oracle 19c Grid Infrastructure Installation

     Common Issues and Solutions for Oracle 19c Grid Infrastructure Installation •       Check Log Files for Details Oracle installation issues often provide valuable clues in the log files. If the installer seems stuck or fails, check the following logs: ▪ Install log : /u01/app/oraInventory/logs/installActions<date>.log •       ▪ Grid Infrastructure log : $ORACLE_BASE/cfgtoollogs/ •         •       These logs can provide error messages and help identify the exact issue. •         •        Check Permissions and Ownership Verify that the Oracle Grid Infrastructure installation directories have the correct ownership and permissions. •        For example: •        Make sure the grid user has permission to write to the directories where the installation is happening. •        Ensure that your server has sufficient swap space and disk space . Oracle can sometimes fail silently if these requirements are not met. •        Check the swap space with: •        Check disk space wi

RESTORE AND RECOVERING A DROPPED DATAFILE IN PDB:

    RESTORE AND RECOVERING A DROPPED DATAFILE IN PDB:   SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 31 12:27:21 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> show pdbs;       CON_ID CON_NAME                       OPEN MODE  RESTRICTED ---------- ------------------------------ ---------- ----------          2 PDB$SEED                       READ ONLY  NO          3 ORCLPDB                        READ WRITE NO   SQL> alter session set container=ORCLPDB;   Session altered.   SQL> show pdbs;       CON_ID CON_NAME                       OPEN MODE  RESTRICTED ---------- ------------------------------ ---------- ----------          3 ORCLPDB                        READ WRITE NO              SQL> select file_name from dba_data_files;   FILE_NAME -----------------------------------------------------