Différences

Ci-dessous, les différences entre deux révisions de la page.

--- informatique:base_de_donnees:tips [2024/01/16 16:49] – ben
+++ informatique:base_de_donnees:tips [2024/02/05 16:21] (Version actuelle) – [PDBs] ben
@@ Ligne 165: / Ligne 165: @@
 </code>
+  * Resize
+<code>
+set lin 1000
+col header_status form a12
+col mode_status form a12
+col path form a15
+col name form a15
+select
+	header_status
+	,mode_status
+	,os_mb
+	,total_mb
+	,free_mb
+	,name
+	,path
+from v$asm_disk ;
+alter diskgroup reco resize all ;
+</code>
 ===== Archivelogs =====
@@ Ligne 506: / Ligne 527: @@
 <code>
-orapwd file=orapwt21cbio password=Dedalus1 ignorecase=n format=12 force=Y
+orapwd file=orapwt21cbio password=password ignorecase=n format=12 force=Y
 asmcmd pwcopy --dbuniquename T21CBIO /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_5/dbs/orapwt21cbio +DATA/T21CBIO/orapwt21cbio
 </code>
@@ Ligne 562: / Ligne 583: @@
 PFRNPC01                       READ WRITE NO
 SQL>
+</code>
+<code>
+alter pluggable database PHQR_OAS1 close instances=all;
+alter pluggable database PHQR_OEM1 close instances=all;
+alter pluggable database PHQR_OEM1 close immediate instances=all;
+alter pluggable database all save state instances=all;
+SELECT * FROM cdb_pdb_saved_states;
 </code>
@@ Ligne 570: / Ligne 599: @@
 Warning: PDB altered with errors.
+</code>
+  * clean violations
+<code>
+exec DBMS_PDB.CLEAR_PLUGIN_VIOLATIONS( pdb_name => 'PFRBNO01');
 </code>
@@ Ligne 850: / Ligne 885: @@
 *****   CIBLE
-# Add Connexion in tnsnames.ora sur $OH Database et $OH Grid
+# Add Connexion in tnsnames.ora sur $OH Database et $OH Grid. DUP => pour ne pas passer par le scan
-P72EPAT_DUP =
-  (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oda1db0vip)(PORT = 1521))
+CDB_RAST_DUP =
-  (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = P72EPAT)))
+  (DESCRIPTION =
+    (ADDRESS = (PROTOCOL = TCP)(HOST = ex1dc2db2cw2cl.nibclt.prod)(PORT = 1521))
+    (CONNECT_DATA =
+      (SERVER = DEDICATED)
+      (SERVICE_NAME = CDB_RAST)
+      (UR = A)
+    )
+  )
 # Add Connexion in listener.ora
 SID_LIST_LISTENER =
   (SID_LIST = (SID_DESC =
-    (GLOBAL_DBNAME = P72EPAT)
+    (GLOBAL_DBNAME = CDB_RA)
     (ORACLE_HOME = /u01/app/oracle/dbHome)
-    (SID_NAME = TEPAT1)))
+    (SID_NAME = CDB_RA)))
 # Create DUMP file on both servers
@@ Ligne 866: / Ligne 910: @@
 # Start Database NOMOUT with pfile
-startup nomount pfile='initPEPAT1.ora' ;
+startup nomount pfile='initCDB_RAST1.ora' ;
 # Create the STANDBY via RMAN Duplicate
 rman
-connect target sys/Dedalus1@P21EPAT_DUP
+connect target sys/password@CDB_RAST
-connect auxiliary sys/welcome1@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ex1dc2db2cw2cl.nibclt.prod)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME = CDB_RAST_DUP)))
+connect auxiliary sys/password@CDB_RAST_DUP
 RUN
 {