oracle sql and dba tutorial logo

Oracle DBA

Learn Oracle 11g / 12c Database Admin step by step

Oracle SQL

Tutorial for Oracle SQL


Oracle DBA Interview Questions

Most asked Oracle DBA Interview Questions.

60 Technical Questions
42 Backup & Recovery Questions

Unix For Oracle DBA 20 Questions

Download Oracle 11g / 12 c Software

Links to Download Oracle 12c / 11g for Linux, Windows etc.

Taking partial backups using RMAN    

When database is running in ARCHIVELOG mode, you can also take Partial backups i.e. backup of particular tablespaces or datafiles using RMAN.

When taking manual backups using O/s commands we have to take tablespaces in the BACKUP mode to take ONLINE backups and then after backup is over we have to END the backup mode.

Whereas if you are taking backup using RMAN there is no need to take tablespaces in the BACKUP MODE you can simply take backup by just starting RMAN and typing the backup command.

To take online backup of particular tablespaces using RMAN do the following

Step 1

 Start RMAN by typing the following command

$ export ORACLE_SID=test
$ rman target system/manager nocatalog

Then RMAN will get connected to the database and it will show the following messages

RMAN connect to database

Step 2

For Example let's take backup of USERS tablespace

To take the backup of a particular tablespace we have to mentioned the tablespace name in the backup command.

rman> backup tablespace users tag 'usertsbak';

rman tablespace backup

Similarly to take the backup of particular datafiles you can give the following command

rman> backup datafile 2,6 tag 'userdbfbak';

In the above command we are specifying the datafile id's instead of it's path and filename. You can see the file ID from V$DATAFILE view

In the above command 2 is the file ID of example01.dbf and 6 is the ID of users01.dbf

Once you type the above command you will get a output as shown below

rman datafile backup



HomeContact Us

Data Loader

Data Loader is a simple yet powerful tool to
export and import Data between many common database formats

Forms Data Loader

Tool to load data into Oracle E-Business Suite R12 / Oracle Apps using Macros and Forms Record and Playback

Interface Computers Academy © 2007-2017 All Rights Reserved