Re: easiest way to backup&recover Oracle?

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Wed, 16 Apr 2003 23:06:39 +0100
Message-ID: <3e9dd112_3@mk-nntp-1.news.uk.worldonline.com>

"Grant" <canuck_tech_at_yahoo.com> wrote in message news:5868625b.0304151518.120cecad_at_posting.google.com...
> Hi,
>
> I was wondering what the easiest & best way is to backup and recover
> our new Oracle 9i database? I've taken a look at the oracle recovery
> manager documentation but it looks like I'd have to code a lot of
> scripts. Our company had a Veritas rep by and their product doesn't
> look like it removes any of the scripting requirements, plus I'll have
> to install a bunch of third party drivers, and I'll be relying on
> tape.. yuck, I have bad memories of tape from my sysadmin days.
> Although, I guess I don't have an alternative for our disaster
> recovery needs...sigh. Are there any better solutions that people
> like?
>
> thanks,

Grant,

Take a new look at RMAN. I must confess I wrote it off years ago when I first saw it in 8.0, but I've revisted it in 9.2 with nothing (so far) but awed respect.

G:\Documents and Settings\Dad\Documents>rman target dad

Recovery Manager: Release 9.2.0.1.0 - Production

target database Password:
connected to target database: DAD (DBID=801044914)

RMAN> backup database;

Starting backup at 16-APR-03
using target database controlfile instead of recovery catalog allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=12 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset

including current SPFILE in backupset
including current controlfile in backupset

input datafile fno=00001 name=G:\ORACLE\ORADATA\DAD\SYSTEM01.DBF
input datafile fno=00005 name=G:\ORACLE\ORADATA\DAD\EXAMPLE01.DBF
input datafile fno=00002 name=G:\ORACLE\ORADATA\DAD\UNDOTBS01.DBF
input datafile fno=00010 name=G:\ORACLE\ORADATA\DAD\XDB01.DBF
input datafile fno=00006 name=G:\ORACLE\ORADATA\DAD\INDX01.DBF
input datafile fno=00009 name=G:\ORACLE\ORADATA\DAD\USERS01.DBF
input datafile fno=00003 name=G:\ORACLE\ORADATA\DAD\CWMLITE01.DBF
input datafile fno=00004 name=G:\ORACLE\ORADATA\DAD\DRSYS01.DBF
input datafile fno=00007 name=G:\ORACLE\ORADATA\DAD\ODM01.DBF
input datafile fno=00008 name=G:\ORACLE\ORADATA\DAD\TOOLS01.DBF

channel ORA_DISK_1: starting piece 1 at 16-APR-03 channel ORA_DISK_1: finished piece 1 at 16-APR-03 piece handle=G:\ORACLE\ORA92\DATABASE\0BEKO4QA_1_1 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:01:06 Finished backup at 16-APR-03

RMAN> I admit that this is minimal, but it's a fully usable hot backup. I've added and deleted stuff after the backup, then deleted a few datafiles to try it out, and then issued 'recover database', It just works, and without fuss.

I'm only posting this response to c.d.o.s., by the way; many people read all the c.d.o. groups, so see it only as a waste of bandwidth to have to download the same message from multiple groups. I'd suggest that for future postings you pick whichever group seems most appropriate. In the long run you will get more help that way.

Regards,
Paul Received on Wed Apr 16 2003 - 17:06:39 CDT