Re: Am I Screwed?

"Mark" <m_sparky_at_eudoramail.com> wrote in message news:UlEpa.880$RT6.393550961_at_twister1.starband.net...
> Now I wish I had not been so fast as to delete all the files and just
> recreate the db.

You may have had to do this anyway.

> Then I imported my backup. The backup was actually
> from around 3:00pm, so it was not all that much data entry, and they had
> to have the system back up as quick as possible. But thanks so much for
> all your help. I like to get every bit of information I can. I feel
> that communicating like this is much more usefull than Oracle's
> overwhelming amount of information.

You need to understand that export is not a backup strategy, "as such". It keeps a logical record of the database at a point in time. Oracle provides a well documented (in the backup and recovery guide) method for doing backups which is one of the two things below.

1. use RMAN
2. put tablespaces in backup mode, copy the datafiles using os commands and take tablespaces out of backup mode, also keep copies of archived redo logs and controlfiles and you have everything you need to recover a database completely,clone it elsewhere or perform point in time recovery - for when you drop a critical table at 5:30pm. Requires archive log mode, but is dead simple.

I like to do both a backup and export the data, two different things for two different purposes.

Again the backup and recovery guide is required reading.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************