Home » RDBMS Server » Backup & Recovery » Backup principles (Oracle Express 10G on Windows XP)
Backup principles [message #294902] Sun, 20 January 2008 11:58 Go to next message
larso
Messages: 1
Registered: January 2008
Junior Member
Hi,

Just started to use Oracle Express for a development project.
The data stored is complex and we need to perform periodical backups.
I have enabled the ARCHIVELOG feature to enable online backups to be able to take backups without having to shut the database down.

The Windows XP installation contains a command file (Backup.bat) that stores
data files in the flash_recovery_area.

Which files do I need to copy to tape?
Must all files in the flash_recovery_area be kept to be able to perform recovery?
What about incremental vs full backups.

Please bare with my newbi questions

BR

L
Re: Backup principles [message #294906 is a reply to message #294902] Sun, 20 January 2008 12:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Backup and Recovery Basics

Regards
Michem
Re: Backup principles [message #294922 is a reply to message #294902] Sun, 20 January 2008 21:45 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
Which files do I need to copy to tape?

Totally depends on you. You can copy all or neither.
Quote:
Must all files in the flash_recovery_area be kept to be able to perform recovery?

No.


Previous Topic: Error 00265 - Instance recovery
Next Topic: one doubt about snapshot control file in RMAN
Goto Forum:
  


Current Time: Fri Dec 09 00:05:51 CST 2016

Total time taken to generate the page: 0.07398 seconds