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 MoreMATERIALISED 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 MoreSteps 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: 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 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): 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 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 MoreCONSISTENT 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