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 […]
Articles Tagged: RMAN
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 […]
Advantage Of RMAN in Oracle
This post is for those who are new in “Oracle RDBMS”, Being a part of Oracle technology in Database. “RMAN” plays an important part in “Backup&Recovery”. “RMAN” has its own benefits. Let’s have looked over the “RMAN” benefits. RMAN helps to DBA have incremental where only modified data blocks will be copied It integrity checks for the […]
Benefits and Restrictions of RMAN in DataGuard
As we use RMAN to backup and restore the database in Simple scenarios. We can use it in Data Guard Environment same way. Oracle Dataguard Even we can use Physical Standby database backup to restore the Primary database and to recover the Primary database. But with some consideration as follow : The recovery catalog is […]
Create Physical Standby Database using RMAN Backup Restore
We have seen preparing Primary Database for Dataguard and creating Oracle network service on both sides. In this article, we will see Physical Standby database creation and configuration using RMAN backup and restore. Step 1: Connect to the Primary database and check if recovery area has enough space configured or not. SQL> show parameter db_recovery NAME […]
Duplicating a PDB to an Existing CDB in Oracle 18c
Use the DUPLICATE command to duplicate a PDB to an existing CDB. To duplicate a PDB to an existing CDB: Ensure that the required prerequisites are met. Review the limitations of duplicating a PDB to an existing CDB Create the directories that store the duplicate database files on the destination CDB Establish Oracle net connectivity […]
RMAN-08137 on Primary Database although Archive Destination
This article is about RMAN-08137. We are going to learn how do we can solve this issue. Let’s have look at the steps to solve this issue. RMAN does not delete ArchiveLogs on Primary Database when the State of the Archive Destination to the Standby Database is set to ‘defer’. When trying to delete ArchiveLogs, this Error is […]
How to Check/Validate That RMAN Backups Are Good
From today’s post, I am going to remind you all about those colleges day when we used to learn about the validation in programming languages. In daily life are aware of validation. In the database world, it is little different. Let’s have look at the types of validation in general terms. Some of […]
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 […]
Database Cloning without RMAN on windows
CREATE INITSRDB.ORA PFILE IN D:\DATABASE\APP FOLDER *.db_name=’srdb2′ *.control_files=’D:\DATABASE\APP\SHRIRAM\REDOLOGS\srdb2\CONTROLFILE\O1_srdb2.CTL’ 2. CREATE DESTINATION FOLDER DATAFILES FOLDER ONLINE REDOLOGS FOLDER CONTROLFILE FOLDER 3. CREATE SERVICE USING ORADIM ORADIM -NEW -SID SRDB2 NOTE: CHECK WHETHER THE SERVICE IS RUNNING OR NOT. 4. COPY ALL THE DATAFILES, REDOLOGS TO DESTINATION FOLDER AS IT IS THE CASE OF DATABASE CLONING WITHOUT […]