Database cold dump

[zircon06]

Can anyone help me with steps to take datbase cold dump

Thanks

 

[KenCunningham]

Which OS?

I want to be good, is that not enough?

 

[zircon06]

os AIX 5.0.2

 

[SantaMufasa]

Zircon,

Oracle provides a package called "RMAN" that you can read up about that can help you.

But, to do cold backups manually (as I do), here are the steps:

1) Before shutting down the database, have Oracle display a list of all of the files in your database (to which you can refer during step 3, below. Your vital database data files include:

a) Control files (select name from v$controlfile
b) On-line redo log files (select member from v$logfile
c) Database datafiles (select name from v$datafile
d) TEMP datafiles (select name from v$tempfile

2) Gracefully shutdown the database. (e.g., SHUTDOWN IMMEDIATE).

3) Use your operating system's "copy" command to copy each of your files, above, to your backup area of choice.
(e.g. "% cp <file_name(s)> <target location>)

4) Re-start your database. (e.g. STARTUP).

Let us know if you have additional questions.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[zircon06]

Thank a lot Mufasa for your help