Oracle 11G comes with some additional checks for integrity checking. Can be done at database, tablespace, datafile, controlfile and block level. source : http://www.online-database.eu/index.php/oracle-11g/139-validate-physical-and-logical-consistency Some commands are RMAN > validate. read more…
Catégorie : RMAN
Setup pluggable database (PDB) as a recovery catalog for all other pluggable DBs in the container
* PDB can act as a recovery catalog* Recovery catalog is not supported when connected to pluggable database* You must register the whole CDB agains the PDB catalog . read more…
Problème de compilation de trigger RMAN après montée de version en 12.2
alter trigger RMAN.VPC_CONTEXT_TRG disable; => marche pas 🙁 lancer : @?/rdbms/admin/dbmsrmanvpc.sql -vpd rman puis UPGRADE CATALOG ; source
Migrate database from One RMAN catalog to another RMAN catalog
Migrate database from One RMAN catalog to another RMAN catalog http://www.nazmulhuda.info/migrate-database-from-one-rman-catalog-to-another-rman-catalog Migrate database from One RMAN catalog to another RMAN catalog In that scenario we will move catalog from. read more…
Sauvegarde Full RMAN avec stratégie
La commande de backup full rman avec une stratégie de backup incrémentale (c’est à dire chaque jour une nouvelle sauvegarde ) est : backup incremental level 0 device type disk. read more…
Valider une consistence de données avec RMAN
Oracle 11G comes with some additional checks for integrity checking. Can be done at database, tablespace, datafile, controlfile and block level. source : http://www.online-database.eu/index.php/oracle-11g/139-validate-physical-and-logical-consistency Some commands are RMAN > validate. read more…
Commandes utiles RMAN
Liste des commandes utiles RMAN RMAN> show all; Configure the disk channel to the format /backup/ora_df%t_s%s_s%p’ RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ‘/backup/ora_df%t_s%s_s%p’; Configure the disk channel to the. read more…