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 […]
Articles Tagged: BACKUP
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 […]
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 […]
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 […]
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 […]
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. […]
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 […]
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 […]
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. […]
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 […]