Re: To DBA - Oracle Backup Question ?

Johnson <syner_at_pd.jaring.my> schreef in berichtnieuws 8gshqi$n5d$1_at_news6.jaring.my...
> Hello,
>
> Hello I am confuse with Backup mode and Backup methodologies :
>
> I understand that Oracle Database had two backup mode - ARCHIVE &
 NOARCHIVE,
> where the HOTBACKUP and COLDBACKUP can take place.
>
> But what is this mode going to do with Backup methodologies,I mean what is
> the Hotbackup or Coldbackup to do with EXP80 ?
>
> Please advise. Thanks.
>
>
>

Actually your confusion seems to be bigger than that. Basically you have several types of failure - physical
- logical / user error
Physical backup protects against physical error, export protects against logical error. So if someone acidentally deletes 32 rows from a 3 million row table, if you do have a recent export, you can retrieve that table only from the export, if you don't have an export you will be forced to perform point in time recovery for the *complete* database. This means you need to conduct *both* backups and exports.
Secondly, I wouldn't call archive and noarchive backup modes. Running the database in archivelog mode allows you to recover the database to any point in time, running the database in noarchivelog mode basically allows you to recover the current set of online redologs online, if you are running in noarchivelog, your most recent *physical* backup was taken on Monday, and you crash on Wednesday, most likely you will have a *real* problem, because older archivelogs would have been lost.

Hth,

Sybrand Bakker, Oracle DBA Received on Mon May 29 2000 - 00:00:00 CEST