image

why we use crosscheck, obsolete , restore validate in rman?

1. why we use crosscheck command in rman ? 2. why we use obsolete command in rman ? 3. why we go for restore database validate ? Solution : .1. To check whether backups are physically available2. To check whether backups are valid (redundant)3. To check the existing backup pieces are valid to restore  

image

Recovery – Loss of all control files (no catalog)

SCENARIO – LOSS OF ALL CONTROLFILES (NO CATALOG) SQL> insert into myobjects select * from myobjects; 919664 rows created. SQL> commit; Commit complete. SQL> select count(*) from myobjects; COUNT(*) ———- 1839328 >>>> need to check this record count after recovery SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST … continue reading

image

Recovery from complete loss of all online redo log files using RMAN

Recovery from complete loss of all online redo log files using RMAN: Database name and version SQL> select instance_name,version from v$instance; INSTANCE_NAME VERSION —————- —————– opsdba 10.2.0.2.0 SQL> select member from v$Logfile; MEMBER ——————————- /u02/ORACLE/opsdba/redo03.log /u02/ORACLE/opsdba/redo02.log /u02/ORACLE/opsdba/redo01.log Lets delete all the redo log files , from the above specified location i.e /u02/ORACLE/ opsdba:/u02/ORACLE/opsdba>rm redo*.log If … continue reading

image

Incomplete Recovery (until log sequence)

Point in time recovery using RMAN (until a log sequence number) Recovery Objective SQL> conn scott/tiger Connected. SQL> select count(*) from myobjects; COUNT(*) ———- 249410 Switch a logfile SQL> conn / as sysdba Connected. SQL> alter system switch logfile; System altered. Note the current log sequence number (13) SQL> archive log list Database log mode … continue reading

image

Incomplete Recovery (until point in time)

POINT IN TIME RECOVERY via RMAN Scenario: DBA dropped the tablespace TEST which is important for application. Requirement: We need to restore the database before the TEST tablespace was dropped. Solution: SQL> drop tablespace test including contents and datafiles; Tablespace dropped. DBA realized the mistake; He will refer alert log for the exact timing when … continue reading

image

Loss Of All Files – Disaster Recovery

RECOVERY SCENARIO: Complete loss of all database files including SPFILE using RMAN Database Details —————— Database Name=OPSDBA Machine Name=ITLINUXDEVBLADE07 DBID=1499754868 (select dbid from v$database) SIMULATING CRASH ———————— opsdba:/u01/ORACLE/opsdba>ls -l total 1948980 drwxr-x— 2 oracle dba 4096 Feb 12 13:35 arch -rw-r—– 1 oracle dba 7389184 Feb 12 13:57 control01.ctl -rw-r—– 1 oracle dba 7389184 Feb … continue reading

image

RMAN Restore on another machine with different file system- same database name

RMAN Restore on another machine with different file system – same database name Primary/Target Machine ITLINUXDEVBLADE08 Secondary/Auxiliary Machine ITLINUXDEVBLADE07 Database Name OPSDBA Note For this example, we will be using TSM in order to backup and duplicate the database to the new machine. Hence TSM needs to be configured on both the machines. If you … continue reading

image

Deleting the Archive log Using RMAN

Once you are connected, then you can use the following to delete archivelogs with one of the following commands. You can choose the commands depending on your situation. 1. To delete all Archivelogs withou backing them up: delete archivelog all; 2. To backup all archivelogs which are not already backed up atleast one time –And … continue reading

image

Recover Oracle database from a corrupt or missing control file

This article will detail about the recovery of oracle database due to loss or corrupt of control file under two senario 1. Corrupt or Missing of Control File 2.  All control files are corrupt or missing If you don’t know the location of the control file as well as multiplexing of the control file click … continue reading

image

DROP a Database using RMAN Oracle

How to Drop a Database using RMAN in ORACLE: Use the drop database command to drop a database from the RMAN prompt. Here are the steps to follow: 1. Start up the database in mount exclusive mode: SQL> startup mount exclusive; Database mounted. SQL> exit 2. From the RMAN interface, use the following command to … continue reading

Visit Us On FacebookVisit Us On Google PlusVisit Us On Youtube