Re: using rman

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Wed, 08 Jan 2003 16:54:29 GMT
Message-ID: <9JYS9.1051$mN.61978640@newssvr21.news.prodigy.com>

Igor wrote:
> Karsten Farrell wrote:
>
> Hi Karsten,
>

>>You can also perform incremental backups in rman ... something you can't
>>do in a shell script.

>
> But as Holger wrote, incremental refers to the last successful complete
> backup, right?!
>

Yes, to restore, you must retrieve the "complete backup" file and any "incremental" files (unless you do cumulative incrementals).

>>By the way, I use shell scripts for all my backups ... but hey, I've got
>>the dream DBA job ... small database (after the terabyte ones in my
>>previous job) ... script takes only 15 minutes for full backup of our
>>prod db ... minimal DBA intervention required ... more disk space than I
>>need ... time to read the docs.

>
> Cool, do you have any "dream sysadmin job" vacant? ;-)
>

Our current sysadmin loves his job too ... but he has to work harder than I do ... he gets to take care of Microsoft Exchange as well.

> A last question, please allow: Did you use rman with the terabyte db's?
>

Those were Oracle7 DBs ... and RMAN wasn't introduced until Oracle8. We actually used homegrown scripts that replicated data from a "master" schema (into which the pharmacists and insurance companies entered their data) into layers of "slave" schemas. One of the DBAs before me didn't like Oracle's replication (which is trigger based), so he wrote his own (that was cron based). If something happened to the master or slave, we could recover from the other "set" of data. Although it used more disk space (we had something like 40 30GB disks per OLTP db server), it was faster to restore this way. With huge DBs, you have to do something out of the ordinary ... just to offload a quarter's worth of data to our data warehouse took something like 3 24-hour days to run.

> Have a very nice day,
> Best regards,
> Igor
>

Thanks. From some of the comments I see on this NG, San Diego always has a nice day ... it's supposed to get a bit chilly today though ... 68 deg farenheit. This past week, highs have been in the 80s. (For those on the Celsius scale, that's something like 19 deg I think.) Received on Wed Jan 08 2003 - 10:54:29 CST