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. […]
Category: BACKUP AND RECOVERY
Cold Backup with Rman in Oracle
Today we are going to have look on Cold Backup. Being DBA we are aware of the importance of Backup in Oracle. Different kind of backup has a different kind of uses. Let’s have look on Cold Backup. Steps for Cold Backup SQL> create table cold_back(name varchar(100)); Table created. SQL> insert into cold_back values(‘********* DATA INSERTED […]
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 […]
Catalog Database in RMAN
Purpose of Catalog Database A base recovery catalog is a database schema that contains RMAN metadata for a set of target databases. A virtual private catalog is a set of synonyms and views that enable user access to a subset of a base recovery catalog. Catalog Database can be two types Base recovery catalog Virtual […]
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 […]
Control file recovery
Today we are going to have look at the backbone of an Oracle Database. Being DBA we all are most aware of the recovery of the controlfile . It is the most important element of our database. Let’s have a look at the steps which are required for the recovery of controlfile. Instance terminates on startup with ORA-00600: internal […]
How to recover database without knowing DBID or DB Name
This article is a bit different from other recovery and backup case studies. The solution to this scenario has given by my fellow DBA Sham. Being a DBA we all are must aware of some different conditions that can occur in different conditions. In this post, we are going to learn about the steps which […]
Archive log delete input and delete all input
Archive log mode : This mode created backup of all transactions that have occurred in the database , so that you can recover your database to any point in time. These logs consumes space in respective destination. To utilize storage , we can remove archive log with RMAN command delete input or delete all input […]
RMAN maxpiecesize command
Use of RMAN maxpiecesize command To avoid large size of backupset we can set maxpiecesize of rman backup piece. I have taken following backup without setting any parameter : RMAN> backup database; Starting backup at 29-DEC-17 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=8 device type=DISK channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) […]