CDB and / Or PDB reboot time query and alert log
Oracle 19.20 - 4 node RAC enterprise Oracle database
OS: Oracle Linux 7
we have 3 CDBs and each have two PDBs. Once in a while, CDB or just PDBs reboot due to hardware issues.
- I use the following query to find the uptime for each PDBs.
SELECT instance_name,host_name,TO_CHAR (startup_time, 'DD-MON-YYYY HH24:MI:SS') "INST Startup Time",DATABASE_STATUS,status,ACTIVE_STATE
FROM sys.gv_$instance order by 3 desc
Q1. Which query should I run in CDB and/or PDB to figure if CDB and PDB rebooted or just PDB, etc.?
Q2. There is only one Alert log for each CDB, correct? So, all DB alert info is just written for a particular CDB + All PDBs underneath in ONE Alert log, is this correct?
Tagged:
1