Con la siguiente consulta en el contenedor de la base de datos, puedes obtener el historial de dichas acciones.
SQL> @fecha_pdbs.sql
DB_NAME CON_ID PDB_NAME OPERATION OP_TIMESTA CLONED_FROM_PDB
---------- ------ --------------- ---------------- ---------- ---------------
G6486 3 PDB$SEED UNPLUG 09-JAN-20
G6486 4 PDB$SEED UNPLUG 09-JAN-20
G6486 5 PDB$SEED UNPLUG 09-JAN-20
G6486 6 PDB$SEED UNPLUG 09-JAN-20
G6486 7 PDB$SEED UNPLUG 09-JAN-20
DBMIGRA 3 PDB$SEED PLUG 04-FEB-21 PDB$SEED
DBMIGRA 4 PDB$SEED PLUG 04-FEB-21 PDB$SEED
DBMIGRA 5 PDB$SEED PLUG 04-FEB-21 PDB$SEED
DBMIGRA 6 PDB$SEED PLUG 04-FEB-21 PDB$SEED
DBMIGRA 7 PDB$SEED PLUG 04-FEB-21 PDB$SEED
DBMIGRA 3 PDB1 CREATE 04-FEB-21 PDB$SEED
DBMIGRA 4 FCUBSUAT CREATE 14-DEC-22 PDB$SEED
DBMIGRA 5 OBDXUAT CREATE 14-DEC-22 PDB$SEED
DBMIGRA 6 OBBRNUAT CREATE 14-DEC-22 PDB$SEED
DBMIGRA 7 FISERESUAT CREATE 14-DEC-22 PDB$SEED
15 rows selected.
SQL> host more fecha_pdbs.sql
set pagesize 20
COLUMN DB_NAME FORMAT A10
COLUMN CON_ID FORMAT 999
COLUMN PDB_NAME FORMAT A15
COLUMN OPERATION FORMAT A16
COLUMN OP_TIMESTAMP FORMAT A10
COLUMN CLONED_FROM_PDB_NAME FORMAT A15
SELECT DB_NAME, CON_ID, PDB_NAME, OPERATION, OP_TIMESTAMP, CLONED_FROM_PDB_NAME
FROM CDB_PDB_HISTORY
WHERE CON_ID > 2
ORDER BY OP_TIMESTAMP,CON_ID
/
No hay comentarios:
Publicar un comentario
Te agradezco tus comentarios. Te esperamos de vuelta.