RMAN

**najmalp** · 07-24-2002, 06:44 AM

Hi All,

Wolud like to know, How do u all find using RMAN instead of taking o/s online or offline backups? Because we are thinking of going for it replacing our o/s backup scripts.

How many of you utilizing it real time?

Please share your experience.

Cheers
Najmal

**jovery** · 07-24-2002, 06:53 AM

I use RMAN to backup our development databases (as our developers work in shifts) so that they can be running 24x7 it seems to work fine and when we have had to restore it's been a realitivly painless experience.

The only reason we don't use it for production servers is because the veritas tape plugin licences are too expensive.

Regards

**SANJAY_G** · 07-24-2002, 06:53 AM

I would say Go for it..
I moved my backups to RMAN after a bit hasitation but started loving it after some hands-on.

Sanjay

**kmwong** · 07-24-2002, 06:59 AM

We are using RMAN, but don't know what do you mean by "real time".

RMAN should be used in on-line mode, performing hot database file backup.

It is not our choice of using RMAN, but the project vendor did. The 1st good thing is it integrated well with Legato and tape drive.

Another good point (which I just discovered, from oracle) is it do "block by block" verifying while backup, which allow hot backup without turning the datafile to backup mode, and also detect block corruption during backup. (it will be too late if you find the backup file on tape is with corrupted blocks when you try to restore them).

The shortcoming are: not easy to maintain, you need to learn a new set of commands, short of documentation, buggy, Oracle support are not helpful on that product, difficult to trace the error ......

Ming

**najmalp** · 07-24-2002, 07:02 AM

Thanks Sanjay & Jim

Hello Jim,

Is Veritas plug in licence for using RMAN with veritas netbackup ?

Najmal

**jovery** · 07-24-2002, 07:08 AM

Originally posted by najmalp
Thanks Sanjay & Jim

Hello Jim,

Is Veritas plug in licence for using RMAN with veritas netbackup ?

Najmal

Yes, I think it basically does a lot more than allow you to just use netbackup with RMAN but it was something we could not justify the extra cost for :( Thats finance departments for you.

Regards

**SANJAY_G** · 07-25-2002, 02:27 AM

Originally posted by najmalp
Thanks Sanjay & Jim

Hello Jim,

Is Veritas plug in licence for using RMAN with veritas netbackup ?

Najmal

Yes, I think it basically does a lot more than allow you to just use netbackup with RMAN but it was something we could not justify the extra cost for :( Thats finance departments for you.

Instead of Veritas you can use Legato Storage Manager, which is bundeled with Oracle Server Enterprise Edition. No extra license cost.

HTH
Sanjay

**dsimpson** · 07-25-2002, 10:56 AM

I have found RMAN to be an excellent backup/restore process to use for Oracle. I have recovered databases more than once using the point in time recovery feature too - and this worked very smoothly.
However I use multiple backup procedures - just in case. If possible, I also like to perform a database export of the most important tables (or the whole database if I have enough disk space). There are some recovery scenarios in which having a database export can be much less disruptive than performing a rollback of the entire database to a point in time.

(Please see Recovery scenario#8 - for more info in the following link

http://www.dotcomsolutionsinc.net/pr...very_scenarios

David Simpson
http://www.dotcomsolutionsinc.net

**najmalp** · 07-27-2002, 04:47 AM

Hi All,

Is it possible to do a consistent whole database backup while the database is mounted not open using a recovery catalog?

Thanks in advance
Najmal

**najmalp** · 07-28-2002, 03:14 AM

Any response please?

Thread: RMAN

Thread Tools

Display

RMAN

RMAN

Posting Permissions