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