Re: Oracle Cold Backup

From: Guy D. Kuhn <guy.d.kuhn_at_saic.com>
Date: Fri, 19 Apr 2002 16:30:00 -0400
Message-ID: <3CC07E48.4E95351D@saic.com>

The short answer is, NO. I guess Oracle assumes if the database is shutdown you should be able to copy all the files without thier help. The backup will be consistent as long as you do a shutdown normal. ( We usually do an abort, startup, shutdown because of application sessions.)

Just make sure you have ALL your archive log files from so you can roll forward.

Md Irfan wrote:

> Hi Mark -- Thanks for the suggestion. I was more likely to know if
> Oracle has
> a)commands for cold backup instead of using OS commands. Like for hot
> backup we have alter tbsp begin/end backup and cp the data files
> b)in your solution for me, how about the control files?
>
> Thanks/Irfan
Received on Fri Apr 19 2002 - 15:30:00 CDT