| Oracle online backups [message #254044] |
Wed, 25 July 2007 11:00  |
ronangarry
Messages: 5
Registered: July 2007
Location: Dublin
|
Junior Member |
|
|
A third party implemented an oracle DB previously in my company, I'm only here a couple of weeks.
No offline backups have been configured.
A daily online backup is configured, and these archive files are stored and zipped. No offline since last year.
Am I right in assuming that if we have a failure and need to restore, we will have to restore last years offline backup, and apply all the archived log files since then to the db?
Cheers!
|
|
|
|
|
|
| Re: Oracle online backups [message #254220 is a reply to message #254047] |
Thu, 26 July 2007 03:36  |
ronangarry
Messages: 5
Registered: July 2007
Location: Dublin
|
Junior Member |
|
|
Hi Michel,
Thanks for the very prompt response!
Can you or anyone else clarify the difference between offline/online backups on an oracle db? What implications do the different backups have on restore in a dr situation?
Can you suggest a best practice schedule for a db?
Current backup log detail!
Database log mode Archive Mode
Automatic archival Enabled
Archive destination E:\ARCHIVE
Oldest online log sequence 46277
Next log sequence to archive 46279
Current log sequence 46280
Thank you,
Ronan
|
|
|
|
|
|
| Re: Oracle online backups [message #254243 is a reply to message #254044] |
Thu, 26 July 2007 05:01 |
ronangarry
Messages: 5
Registered: July 2007
Location: Dublin
|
Junior Member |
|
|
Hi Michel,
Thanks again for the response, but I did actually know the difference between online and offline in the basic sense, but was more worried about the difference between the two as far as recovery is concerned.
Basically;
1. Backup the DB every morning using online backup.
2. Backup those files (*.dbf & *.arch) every day.
In this situation can I recover from these files, without needing any other files?
Also if the above is correct, can I delete the *.arch files on the DB drive that are older than 3 days for example? (have had issues with drive filling)
Thanks again,
Ronan
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Oracle online backups [message #256326 is a reply to message #254044] |
Fri, 03 August 2007 17:03 |
meggens
Messages: 57
Registered: February 2007
Location: Netherlands
|
Member |
|
|
|
you should read an rman book. rman is the tool to do your database backup. Make sure you understand the backup you make and test your restore procedure.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
