Month: December 2022
Recovery Catalog
What is Recovery Catalog? A recovery catalog is a database schema used by RMAN Which is used to stored Metadata of one ormore databases. Benefits: To store this files from target databases:This recovery catalog contains metadata of Rman operations of each registered target database Database Registration:The process of enrolling the target database with in a … Read more
Recovery of dropped tablespace with RMAN
SELECT NAME ,OPEN_MODE FROM V$DATABASE;SELECT LOG_MODE FROM V$DATABASE;SELECT NAME FROM V$DATAFILE;SELECT NAME FROM V$TABLESPACE; CREATE TABLESPACE(TB1) RMAN > BACKUP DATABASE PLUS ARCHIVELOG; LIST BACKUP OF CONTROLFILE; LIST BACKUP OF TABLESPCAE TB1; DROP TABLESPACE TB1 INCLUDING CONTENTS AND DATAFILES; SELECT NAME FROM V$DATAFILE; SELECT NAME FROM V$TABLESPACE; LIST BACKUP OF TABLESPCAE TB1; =======> Not present in … Read more
Control File and Redolog File Multiplexing
Control file and Redolog file contains crucial database information and loss of these files will lead to loss of important data about database. It is recommended to have multiplexed copies of files in different locations.• Control File Multiplexing• Redolog File Multiplexing If control file is lost in 9i, database may go for force shutdown, where … Read more
ARCHIVE AND OLD RMAN BACKUP REMOVAL
***************************FOR ARCHIVELOG****************************** [oracle@Anish trace]$ df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/VolGroup-lv_root 57G 46G 8.0G 86% /
How to determine what is keeping Catalog and Catproc invalid in the Registry
1. Run this SQL script until it returns ‘CATPROC can be validated now’. For any objects that are reported by this script, they must be addressed in some manner and made valid to continue. To check CATALOG, simply change the two entries in the script. (i.e. replace CATPROC with CATALOG before running) 2. Then run … Read more