Hi,

Can anybody please tell me how to take a full backup of a oracle database & how can we restore that. my database is in archive mode.

I know how to export database objects using EXP but I need to take a full backups. currently I'm backing up archive files.

ThanX

__________________
nalaka hewage
http://nalakahewage.blogspot.com

Hi,

To make a full backup you can use exp sys/pwd@base full=y.
You can also do a cold backup :
   Stop the database
   save redolog file, datafile, controlfile, ini.ora
   restart the database.

If your db crash, you can recreate one db (with dbca) and reimport file, or use cold backup + archive.

See : http://asktom.oracle.com/pls/ask/f?p...:3151992035532

ThanX



Hi CYRLOEF,

ThanX buddy. I'll check that.