Restore A Loss Of Controlfile Using Autobackup
Follow the steps to Restore A Loss Of Controlfile Using Autobackup: Step:1 connect to RMAN and view the default parameters using SHOW ALL. Step:2 see the location of control…
Read MoreBACKUP DATABASE USING RECOVERY CATALOG.
Steps in Backuping database using Recovery Catalog: What is a Recovery Catalog? RMAN metadata can be stored in either of the two places, Controlfile Recovery catalog Hence recovery catalog is…
Read MoreHow to Apply a Patch(Patch 30886680: DATABASE APR 2020 RELEASE UPDATE 12.2.0.1.200414)
Steps for applying the patch: Step:1 Check current version of OpatchTool Step:2 Upgrade the Opatch utility Step:3 Take the backup of ORACLE_HOME Step:4 Shutdown the Database and Listener Step:5 Apply…
Read MoreIntroduction to Materialised views
MATERIALISED VIEWS: Materialized views are schema objects that can be used to summarize, precompute, replicate and distribute data. In mview, the query result is cached as a concrete table that may…
Read MoreActive Cloning
Steps to perform Active Cloning : Target database – RAHUL Clone database – DOYEN 1)create the particular directories for clone database for storing datafiles,controlfiles,log files. mkdir DOYEN then create separate…
Read MoreRecover a tablespace using RMAN
Recover a tablespace using RMAN: Step:1 create a tablespace Rahul. Step:2 view the tablespaces present in the database using Select tablespace_name from dba_tablespaces; Step:3 Backup the tablespace and backup the…
Read MoreData Recovery Advisor in Oracle 12c
Data Recovery Advisor feature/utilty was introduced in oracle 12c to identify and repair the failure automatically,before that we have to manually identify and rectify the failure that has occurred using…
Read MoreBlock change Tracking (BCT)
Block Change Tracking(BCT): It improves the performance of incremental backups by recording changed blocks in the block change tracking file.It is used when an incremental backup is done,instead of scanning…
Read MoreDatabase Incarnation
Database incarnation is a new version of the database that happens when you reset the online redo logs using alter database open resetlogs; Database incarnation falls into following category Current,…
Read MoreRMAN CONSISTENT BACKUP
CONSISTENT BACKUP: A consistent backup of the database is one taken when the database is in a consistent state, that is, one taken after the database has been shut down normally (using…
Read More