Re: Oracle Cold Backup

In article <3CC07E48.4E95351D_at_saic.com>, "Guy says...
>
>The short answer is, NO.

c/NO/YES/

rman will do this for you. You do not need to use cp/tar/cpio

>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
>

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp