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): 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 MoreORA-19809: limit exceeded for recovery files In this blog, we are going to resolve the “ORA-19809” error The limit for recovery files specified by the db_recovery_file_dest_size was exceeded. Here I am…
Read MoreMultiplex Oracle control file: In order to reduce the risk of losing control files due to corruption, accidental removal, or any possible worst. Viewing the Control file available in our…
Read MoreDATABASE_LINK PARAMETER A database link is a schema object in one database that enables you to access objects on another database. The other database need not be an Oracle Database system. You can query a table or view…
Read MoreIn this blog, We are going to learn about recovering online redo log files without any backup Step 1: Starting Up the database, SQL> startup ORACLE instance started. Total System…
Read MoreSteps to recover a loss of all online redo log files using RMAN Every instance of an Oracle database has an associated online redo log to protect the database in case of an…
Read MoreHere I am going to explain about how to create a Instance in cloud, Step 1: Provide the instance name as your suitable: Step 2 : Click the change Image…
Read More