RMAN backup in Noarchive log mode

Today we will see how to take backup of Oracle Database when your database is in NOARCHIVELOG mode. Step 1: Check your database details [oracle@dbatesting ~]$ export ORACLE_SID=orcl [oracle@dbatesting ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Wed Dec 19 21:44:57 2018 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle […]

Read More

Backup CDB and PDBs

Introduction of Multitenant Architecture In this article, we will see how we can take RMAN backup of whole CDB and for the single pluggable database. To take RMAN backup of the whole CDB we can simply take backup by connecting to target as container database and backup database command. Let us see by example : CDB […]

Read More

RMAN Backup With Archivelog

This post is  about how to take RMAN Backup With Archivelog RMAN> run { allocate channel c1 type disk; backup database; backup(archivelog all); } RMAN> backup archivelog all delete input; Note: This will backup all archivelog file and delete those from a target location. If we physically delete some archivelog file before backup then we have […]

Read More

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 […]

Read More

Restoring physical standby backup to create new standby database

RMAN Physical Standby Database backup is used to create another physical standby database. Offloading Backup to Standby in Data Guard I have already taken backup of one of my physical standby database. Use following steps to restore physical standby backup to create a new physical standby database. Step 1: Create the directory on the server […]

Read More

Schedule rman backup in windows

We are going to learn about the steps which we will use for schedule rman backup in windows. Most probably Organisations use Linux and Unix OS as per there requirements but sometimes as per company’s requirements, we have to use windows. Here we are going to have look at the process of schedule rman backup in windows.   Let’s have look at it. […]

Read More

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 […]

Read More

Clone Database using RMAN on Windows 10

Cloning Database with RMAN : A cloning database is useful for a variety of purposes, most of which involve testing. You can perform the following tasks to clone database: Prerequisites: You should have 2 servers , both server should have Oracle Software installed on them. Oracle Version : 11.2.0.4.0 OS : Windows 10 Database Name […]

Read More

Creating and Deleting Database backupsets on Oracle Cloud DBAAS

This article was written by Skant Gupta and Joel Perez in Oracle OTN. By backing up your Oracle Database Cloud Service database deployments, you can protect the software, configuration and database against loss if a failure occurs. By restoring from a backup, you can restore the deployment’s software, configuration, and database to their state at the time of the backup. […]

Read More

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 […]

Read More