How to Backup and restore oracle DB?

[tjedwin]

I'm a newbie, how can i backup my database? and how to restore it?

Thank you in advance

[leo]

Wow!

It is a huge question.

Is it for home use or production?

If it is for home use, than shutdown database and backup all the data files, control files, parameter file and password file if you have one.

It looks like all.

But backup of Oracle is a huge topic...

Leo

[anandharaj]

Hi,

Could you be more specific, regarding your environment..?

that is :
OS details, Database details, Archive Mode or Not ?
Is it Production ?
Is it OLTP ?

So that we can proceed further accordingly...

Regards

[Sureshy]

Hi,

As Leo has stated, backup and recovery is a huge subject. The backup/recovery strategy you employ is based on your environment and resources.

The following link is a good starting point in understanding B&R concepts and administration. If after reading this manual, you are still unclear, you may need to book a course to truly understand Oracle SCN's and how they work in backup and recovery and how to recover from all the different types of failure you may come across, based on the affected files and the type of backup you employ.

http://otn.oracle.com/docs/products/...a76993/toc.htm

Feel free to ask questions relating to specific areas of B&R on this forum. You can also use the search engine to find other threads related to B&R at this site.

Suresh