Oracle 10g backup, backup Options

[jitu]

Dear sir,

we are using oracle 10g for our data entry based application.
Data entry operators continuously works on database. so in this case for backup of data what should we do?
which is the best way to obtain backup of database.please tell me...?


regards

[dave]

same applies for every database, use rman

[mssaravanan86]

Dear sir,

we are using oracle 10g for our data entry based application.
Data entry operators continuously works on database. so in this case for backup of data what should we do?
which is the best way to obtain backup of database.please tell me...?


regards

If you are not strong with RMAN , you could use export and import , its very simple

[dave]

If you are not strong with RMAN , you could use export and import , its very simple

WHAT? export and import is not a backup and that is down right dangerous to suggest it as one

[mrculp]

RMAN is very simple to setup and use and a good consultant can set it up with scripts in a day.

http://www.dba-oracle.com/concepts/rman.htm

[burleson]

Hi,

>> which is the best way to obtain backup of database.please tell me...?

Like every Oracle question, the answer is "it depends".

If you do not have hardware-level B&R, then you want to use RMAN.

And RMAN is not trivial, it's a very sophisticated tool and you need to take a class at Oracle University to learn how to use it.

http://education.oracle.com/pls/web_prod-p...;p_org_id=46777

It sounds like you don;t know much about database management, I recommend that you get properly trained.

Oracle is the world's most complex and flexible database, it's not for casual use!

[Abraham]

The ability to recover a database is the most fundamental responsibility of a DBA -- All else amounts to nothing if data is lost.

If you have limited knowledge of the recovery process and you are in charge of recovering a production instance, my first suggestion would be to contact support : you don't want to make a mistake. Trust me, you don't want to practice on a production environment.

Once the database is restored, when you have plenty of time, I'd suggest you start by having a thorough look at the documentation.