THE Wiki

User Tools

Site Tools

Trace: • horde • sles • db2 • xmbc • vi • oracle • ibm_tsm • shell_progammierung • allergien • start
oracle

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
oracle [2025/08/14 09:19] – [ACLs] mduerschoracle [2026/03/06 09:25] (current) – mduersch
Line 1: Line 1:
 ====== ORACLE ====== ====== ORACLE ======
 +
 +==== CDB PDB ====
 +
 +Befehle 
 +  SHOW CON_NAME
 +  ALTER SESSION SET CONTAINER=pdb1;
 +  SELECT NAME, CON_ID, DBID, CON_UID, GUID FROM V$CONTAINERS ORDER BY CON_ID; 
 +  SELECT PDB_ID, PDB_NAME, STATUS FROM DBA_PDBS ORDER BY PDB_ID;
 +  SELECT NAME, OPEN_MODE, RESTRICTED, OPEN_TIME FROM V$PDBS;
  
 ==== ACLs ==== ==== ACLs ====
Line 349: Line 358:
 ==== Dataguard related ==== ==== Dataguard related ====
  
 +   SELECT DEST_ID, DESTINATION, STATUS, GAP_STATUS, ARCHIVED_THREAD#, ARCHIVED_SEQ#, APPLIED_THREAD#, APPLIED_SEQ#, FROM V$ARCHIVE_DEST_STATUS WHERE STATUS <> 'INACTIVE'
 +  
    select database_role, open_mode from v$database;    select database_role, open_mode from v$database;
    select processm, status, sequence# from v$managed_standby;    select processm, status, sequence# from v$managed_standby;
Line 559: Line 570:
    select LOG_MODE from v$database;    select LOG_MODE from v$database;
    select name from V$database;    select name from V$database;
 +   # flashbackquery
 +   select count(1) from somewhere 
 +                 AS OF TIMESTAMP TO_TIMESTAMP('2025-12-12 16:00', 'YYYY-MM-DD HH24:MI:SS') 
 +           where 
 +                 something is NULL;
  
 ==== GRANTS ==== ==== GRANTS ====
oracle.1755163185.txt.gz · Last modified: by mduersch