RMAN Backup for Oracle

[Shivkumar]

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

[Michal Kapalka (mikap)]

hi,

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

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

mikap

[Aneesh Mohan]

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

[John Brooks_1]

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]

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

[Shivkumar]

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.

[John Brooks_1]

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]

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]

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