• Arun Kumar

Oracle RMAN Cold Backup

It’s easy to fire RMAN backups when database is running in archive log mode. RMAN will take your database backup along with archive logs.


You can even use RMAN to take backup of a database running in NOARCHIVELOG mode. But the condition is the database must not be open.


You can fire the RMAN full backup in MOUNT mode.


Put DB in mount mode


As the database is running in NOARCHIVELOG mode, we cannot take RMAN backup when it is open. RMAN will work when your database is atleast in MOUNT mode

SQL> startup mount;


Take full backup


Connect to RMAN and fire full DB backup. The backup will be by default stored inside FRA location

rman target /

RMAN> backup database;

In case you want to store the database backup in a different location then

RMAN> backup database format '/u02/backup/testdb/full_bkp_%U';


Open the database


Now you can open the database

RMAN> alter database open;




Recent Posts

See All

MySQL Installation on Linux

This article demonstrates MySQL installation on Oracle Enterprise Linux 6.5 version. Installation of MySQL Make sure you are able to connect internet via virtual machine. Try to ping google.com and pr

Add ISO image storage repository on XenServer

If you have used VMware ESXI, its very easy to upload ISO files to the data store and create VMs. With XenServer, you must create your own ISO repository to upload ISO files. Create ISO directory Acce

Perform Manual Switchover on Physical Standby

Connect to proddb database via client: Take a new putty session and connect to proddb database via client machine. Keep querying below sqlplus sys/sys@proddb as sysdba SQL> select name, open_mode, db

  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis

Feedback