Let’s have look on the steps used for Cold Backup and Recovery From Archivelog. Check the archive log status SQL> archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 6 Current log sequence 8 Enable the archive logs SQL> shutdown immediate; Database closed. Database dismounted. […]
Articles Tagged: RECOVERY
RMAN Recovery From Missing All Control File
Today we are going to have look on the steps which are used by “DBA” for RMAN Recovery From Missing All Control File. SQL> select dbid from v$database; DBID ———- 847839442 RMAN> show all; using target database control file instead of recovery catalog RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default […]
Basic of RMAN Backup and Recovery Scenario
Backup and recovery is a common task in DBA’s Daily Routine. Let’s have looked over the process to take backup of Oracle database and know about the process to recover the database. Check the archive log status SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log […]
RMAN Time Based Recovery
RMAN is the most useful tool for Oracle in DBA’s life. Today’s post is about “RMAN Time Based Recovery”. Let’s have look on the steps. First, take the full backup. RMAN> run { allocate channel c1 device type disk; allocate channel c2 device type disk; backup database and archivelog all delete input; } Create a […]
Resynchronize a duplicated remote database using RMAN backups
This post is about re-synchronized a duplicated database: the source database is PROD@vsi08 server and the target database will have the same SID, but located @vsi10 server. All the steps to set up a duplicated database are already explained in this previous post. Let’s duplicate for the first time our target database PROD located on […]
Categories of Failures in Oracle Database
Today we are going to have look on Categories of Failures in Oracle Database. This information helps to DBA solve the issue as soon as possible. Statement Failure Statement failure transpires when there is a logical failure in the handling of a statement in an Oracle program. If a statement failure occurs, then the Oracle software or operating […]
Restore from a loss of all current control files to a non default location using a backup piece
This post is about the steps which use restore from a loss of all current control files to a non-default location using a backup piece. First of all just create a location outside the flash recovery area where to save the backup piece containing the current control file: [oracle@localhost oracle]$ pwd /home/oracle/app/oracle/ [oracle@localhost oracle]$ […]
Perform a time-based incomplete recovery
Every incomplete recovery is followed by a resetlogs command before opening the database: each time you use a resetlogs command, a new incarnation of the database is created. While performing incomplete recovery it should be known the target point at which the recovery process needs to terminate: there are several ways to establish and set […]
Duplicate a database on the same host
This post explains the steps which are used for RMAN: how to duplicate a database on the same host. We need to duplicate a database. There are many possibilities to complete this task and I choose to use RMAN and its commands: in particular, I decided (to be honest it was just a poor notebook configuration […]
Recovery when the first block of a datafile containing the datafile header becomes corrupt
Here some lines explain about the header of a block. Normally we know have seen block corrupt but what if when the first block of a datafile containing the datafile header becomes corrupt. The header of a block contains information like the type of segment the block belongs to and the SCN of the last […]