RAM&KRISHNA BLOG

  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.

     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:   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 -----------------------------------------------------