cancel
Showing results for 
Search instead for 
Did you mean: 

RMAN Backup for Oracle

Shivkumar
Super Advisor

RMAN Backup for Oracle

Hi All,

Is RMAN backup for oracle work for raw file system and not with cooked file system ?

Using RMAN we can perform only cold backup by shutting down database. Is it correct or incorrect ?

Thanks,
Shiv
8 REPLIES
Michal Kapalka (mikap)
Honored Contributor

Re: RMAN Backup for Oracle

hi,

here a short description what is a RMAN and what's his purpose.

http://en.wikipedia.org/wiki/RMAN

mikap
Aneesh Mohan
Honored Contributor

Re: RMAN Backup for Oracle

1) Is RMAN backup for oracle work for raw file system and not with cooked file system ?

RMAN can be used for both cooked filesystem and raw chunks.

2)Using RMAN we can perform only cold backup by shutting down database. Is it correct or incorrect ?

Cold backup is a consistent backup .RMAN requires that the database be started and mounted to perform a cold backup.

shutdown immediate;
startup mount;
backup database;

Regards,
Aneesh

Re: RMAN Backup for Oracle

Using RMAN we can perform only cold backup by shutting down database. Is it correct or incorrect ?

RMAN will shut the database down and restart it as part of the backup job. It will also backup your control files and archive logs.
RMAN can perform a hot backup, but the database must be in archivelog mode.
Jean-Luc Oudart
Honored Contributor

Re: RMAN Backup for Oracle

Regarding your 1st question, RMAN can backup both (In fact, it does not make any difference for RMAN).

For COLD backup (and to keep a consistent backup) you need to shut down your database. This can be done with RMAN.

see documentation
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/backrec.htm#i1007289

Regards
Jean-Luc
fiat lux
Shivkumar
Super Advisor

Re: RMAN Backup for Oracle

Are there any tool used for hot backup in consistent manner ? I mean if it is 24X7 database and we don't want to shutdown then what are the tools available in the market.

Money is not a concern for us at all as we are a big enterprize and don't bother for cost for right technology.

Re: RMAN Backup for Oracle

Most of the major backup vendors have APIs into RMAN. VeriTAS NetBackup, Legato Networker, Tivoli Storage Manager and of course HP OmniBack II. If you want an overview of each one, look at the Oracle Press book "ORACLE 10g RMAN Backup & Recovery.
Aneesh Mohan
Honored Contributor

Re: RMAN Backup for Oracle

Hi Shiv,

Are there any tool used for hot backup in consistent manner ?

Yes there are ..

A) Oracle Secure Backup (From Oracle)

B) Offcourse RMAN, You can use RMAN for hot backup efficiently (withoutn taking database is begin backup mode) .But the only limitation in RMAN is it doesn`t have Media Management Library ,that means if you want to take backup in tape media you man need to depend any other backup software like HP Dataprotector with RMAN integration or Vertias Netbackup ..etc.

RMAN + HP Dataprotector (with Oracle integration) is a better combination


Aneesh
Eric Antunes
Honored Contributor

Re: RMAN Backup for Oracle

Hi Shiv,

RMAN is the right choice. But you need to do some setup:

1- set init.ora parameters:
i) log_archive_start = TRUE
ii) log_archive_dest = (I recomend at least 100 Gb in free space. This cannot be full or your database will crash)
2- shutdown database and restart:
sqlplus '/ as sysdba'
SQL> shutdown immediate;
Cold Backup
SQL> startup mount;
SQL> alter database archivelog;
SQL> alter database open;

Best Regards,

Eric Antunes
Each and every day is a good day to learn.