Différences
Ci-dessous, les différences entre deux révisions de la page.
Les deux révisions précédentes Révision précédente Prochaine révision | Révision précédente | ||
informatique:base_de_donnees:tips [2024/01/16 16:51] – ben | informatique:base_de_donnees:tips [2024/02/05 16:21] (Version actuelle) – [PDBs] ben | ||
---|---|---|---|
Ligne 165: | Ligne 165: | ||
</ | </ | ||
+ | * Resize | ||
+ | |||
+ | |||
+ | < | ||
+ | set lin 1000 | ||
+ | col header_status form a12 | ||
+ | col mode_status form a12 | ||
+ | col path form a15 | ||
+ | col name form a15 | ||
+ | select | ||
+ | header_status | ||
+ | , | ||
+ | ,os_mb | ||
+ | ,total_mb | ||
+ | ,free_mb | ||
+ | ,name | ||
+ | ,path | ||
+ | from v$asm_disk ; | ||
+ | |||
+ | alter diskgroup reco resize all ; | ||
+ | </ | ||
===== Archivelogs ===== | ===== Archivelogs ===== | ||
Ligne 562: | Ligne 583: | ||
5 PFRNPC01 | 5 PFRNPC01 | ||
SQL> | SQL> | ||
+ | </ | ||
+ | |||
+ | < | ||
+ | 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; | ||
</ | </ | ||
Ligne 570: | Ligne 599: | ||
Warning: PDB altered with errors. | Warning: PDB altered with errors. | ||
+ | </ | ||
+ | |||
+ | * clean violations | ||
+ | |||
+ | < | ||
+ | exec DBMS_PDB.CLEAR_PLUGIN_VIOLATIONS( pdb_name => ' | ||
</ | </ | ||
Ligne 850: | Ligne 885: | ||
***** CIBLE | ***** 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 |
CDB_RAST_DUP = | CDB_RAST_DUP = | ||
- | (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oda1db0vip)(PORT = 1521)) | + | (DESCRIPTION = |
- | (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = CDB_RAST))) | + | |
+ | (CONNECT_DATA = | ||
+ | | ||
+ | | ||
+ | (UR = A) | ||
+ | | ||
+ | ) | ||
+ | |||
# Add Connexion in listener.ora | # Add Connexion in listener.ora |