Home » SQL & PL/SQL » SQL & PL/SQL » backups2
backups2 [message #1582] Tue, 14 May 2002 21:22 Go to next message
por
Messages: 2
Registered: May 2002
Junior Member
Do I need to put the DB into archivelog mode before using exp utility to back it up.
Re: backups2 [message #1593 is a reply to message #1582] Wed, 15 May 2002 08:22 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
No. Export will recover the DB from the last export. You will lose any data that has changed since the last export provided you didn't lose your export file. Export does not care if you are in archive mode.

Use archive mode and RMAN to backup the DB without taking it offline. This give you the ability to do a full recovery up to the failure or a point-in-time recovery.

There are many backup strategies you can use. Check out the Backup and Recovery manual.
Previous Topic: PL/SQL table as IN parameter to stored proc
Next Topic: internet app: handling error messages
Goto Forum:
  


Current Time: Fri Apr 26 08:47:52 CDT 2024