Oracle 8i Backup and Recovery on NT 4.0

[jgabay]

Is there any easy (and inexpensive) way to backup and recover an 8i database? Manuals are exhaustively uninformative (and confusing at best) and any scripts that can be found are, more ofter than not, for Unix boxes. I'm not looking for bells and whistles, just something down and dirty to get the job done.

 

[mrcomino]

I dont understand so much what you are asking for...

But
The type of backup and recovery its strongly dependent of
each instalation.

For a small/Middle instalation, I would recomend you to make
physical and logical daily backups.

1º Physical cold Backups (With Your Oracle DB down, you
must copy all datafiles, redo log files , archiver log
files , and parameter files to another storage medium).

If you need 24X7 availavility then use Hot backup
(With the Oracle DB OPEN
loop for all tablespaces
Alter Tablespace xxx begin backup;
host >dump or cp or dd of the phisical datafiles
Alter tablespace xxx end backup;
end loop
).

2º Logigal backup --> Full daily export of the DB.


The physical backup ensure you a full and quick recovery.

The logical its more eficient for parcial recoverys (a user, a table, some objects ...).


Sorry for my english
Tarko