Re: switch from file system to raw device

From: Igor <igor.news_at_merkudelete.org>
Date: Thu, 16 Sep 2004 14:24:03 +0200
Message-ID: <pan.2004.09.16.12.24.02.892792@merkudelete.org>

On Thu, 16 Sep 2004 22:05:49 +1000, Howard J. Rogers wrote:

Hello Howard,

> What RMAN database? It is not compulsory to run RMAN with a catalog
Maybe I forgot, maybe teacher was not so good. ;-)

> database. In fact, from 9i onwards, the default is not to. And the
When I will come to 9 I will surely reconsider things... As far as I have to stick to 7.3.4 and 8.0.6 for now this is (unfortunately?) not an issue.

> In any event, the RMAN catalog database, if you choose to use one, is
> peanut-sized. Most of it is just SYSTEM tablespace, after which it's just
> 20MB per target database per year. It isn't exactly in use all the time,
> either, so you can just shut it down, copy *.*, and have done.
It's not the size, it's yet another piece.

>> We are very 
>> comfortable with the bash shell script backup/recovery "software". In fact
>> we test recovery procedure once in a while with dba and operator.

> That's one of the main reasons I would be honing my RMAN skills whilst you
> have the chance... it wouldn't surprise me in the least if Oracle turned
> around one version soon and announced that RMAN was henceforth to be the
> only supported backup method. They've put a lot of effort and investment
> into their own tool, after all.

Which means that Operator and dba will have to detail RMAN skills, too, doesn't it?! I will not discuss what we shall do or not shall do as far as training is concerned because I am not deciding about it (read, I can't spend a cent by myself) and I guess we all converge in saying that training is important and has to be done. As things get more and more complex with 9i, 10g or 11h and "external" backup software won't work any more or won't be supported any more, we will reconsider things ... of course.

Thanks a lot. Best regards,
Igor Received on Thu Sep 16 2004 - 07:24:03 CDT