Re: Newbie: What actions have to be taken when doing a COLD BACKUP?

From: peter <peter01234_at_zonnet.nl>
Date: Wed, 19 Feb 2003 22:37:19 +0100
Message-ID: <nTS4a.103934$481.21327@amstwist00>

Hi Ron,

....please find my answers below:

> What about the data files of the instance? Are the tablespaces put in
> backup mode before the copy is made? If not, your backups are not going
> to be valid.

The tablespaces have not been put into backup mode before the copy is made. Sorry, it's probably very basic: but is this really a requirement as long as no users are logged in?
I mean: do I only achieve "consistent state" by putting the tablespaces in backup mode?
If so, is there any command available how to perform this on all tablespaces for a particular instance?

> However, I would strongly suggest you use RMAN to control your backups.
> I think you might be able to run RMAN backups from ArcServ (not sure
> here, but the Backup Recovery Guide or metalink might give you this
> information).

Ron, thanks. I guess this is the most secure (and only) way to ensure everything is backuped properly.
Are there any negative issues involved with using RMAN? I mena the "RAW mode", one has to take care of control, param files, number of datafiles an so on ...
what would be the benefit of this efforet? ....if it could be more easy by using RMAN?
I am not familiar enough with RMAN - that's why.

Thanks for you great help!
Peter Received on Wed Feb 19 2003 - 15:37:19 CST