topic Re: RMAN Backup for Oracle in Operating System - HP-UX

RMAN Backup for Oracle

Shivkumar — Sun, 15 Nov 2009 18:56:37 GMT

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

Re: RMAN Backup for Oracle

Michal Kapalka (mikap) — Sun, 15 Nov 2009 19:07:10 GMT

hi,

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

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

mikap

Re: RMAN Backup for Oracle

Aneesh Mohan — Mon, 16 Nov 2009 04:40:30 GMT

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

John Brooks_1 — Mon, 16 Nov 2009 14:06:29 GMT

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.

Re: RMAN Backup for Oracle

Jean-Luc Oudart — Mon, 16 Nov 2009 16:03:16 GMT

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

Re: RMAN Backup for Oracle

Shivkumar — Mon, 16 Nov 2009 23:10:03 GMT

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

John Brooks_1 — Mon, 16 Nov 2009 23:36:49 GMT

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.

Re: RMAN Backup for Oracle

Aneesh Mohan — Tue, 17 Nov 2009 05:29:09 GMT

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

Re: RMAN Backup for Oracle

Eric Antunes — Tue, 17 Nov 2009 12:10:12 GMT

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