Home » RDBMS Server » Backup & Recovery » Oracle online backups
Oracle online backups [message #254044] Wed, 25 July 2007 11:00 Go to next message
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 #254047 is a reply to message #254044] Wed, 25 July 2007 11:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You don't need any offline backup, full online backups are sufficient (with archived logs, of course, and assuming you are in ARCHIVELOG mode).

Regards
Michel
Re: Oracle online backups [message #254220 is a reply to message #254047] Thu, 26 July 2007 03:36 Go to previous messageGo to next message
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 #254221 is a reply to message #254220] Thu, 26 July 2007 03:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OFFLINE: database is not open.
ONLINE: database is open.

OracleŽ Database Backup and Recovery Basics

Regards
Michel
Re: Oracle online backups [message #254243 is a reply to message #254044] Thu, 26 July 2007 05:01 Go to previous messageGo to next message
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 #254247 is a reply to message #254243] Thu, 26 July 2007 05:11 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

ronangarry wrote on Thu, 26 July 2007 16:01


In this situation can I recover from these files, without needing any other files?

Also backup your controlfile.
can I delete the *.arch files on the DB drive that are older than 3 days for example? (have had issues with drive filling)
Yes.

Thanks again,
Ronan

Re: Oracle online backups [message #254255 is a reply to message #254044] Thu, 26 July 2007 05:32 Go to previous messageGo to next message
ronangarry
Messages: 5
Registered: July 2007
Location: Dublin
Junior Member
Thanks Michel & Arju for all your help.

*.dbf, *.arch & *.ctl files backed up to local disk, and then backed up to remote storage, and also to removable storage, will cover me for all eventualities. Cool

Ronan
Re: Oracle online backups [message #254761 is a reply to message #254243] Sat, 28 July 2007 00:35 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Backup those files (*.dbf & *.arch) every day.
You also need to backup "control files ".ctl"".

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)

No directly,
you have to set "retention policy" for it.

http://download.oracle.com/docs/cd/B14117_01/server.101/b10734/rcmconc1.htm#1016372

Regards
Taj
Re: Oracle online backups [message #255581 is a reply to message #254761] Wed, 01 August 2007 04:23 Go to previous messageGo to next message
ronangarry
Messages: 5
Registered: July 2007
Location: Dublin
Junior Member
Hi Taj,

I'm not using RMAN. My intention is to check the backups once a week and delete the redo logs older than 14 days via a vb script.

Ronan
Re: Oracle online backups [message #255670 is a reply to message #255581] Wed, 01 August 2007 08:08 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

but why you don't use RMAN features.

and please don't DELETE REDO LOG FILES ....

may be you talking about ARCHIVE LOG FILES ...

Regards
Taj
Re: Oracle online backups [message #256326 is a reply to message #254044] Fri, 03 August 2007 17:03 Go to previous messageGo to next message
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.
Re: Oracle online backups [message #256371 is a reply to message #256326] Sat, 04 August 2007 01:24 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Useless comment, we already pointed OP to the documentation.

Regards
Michel
Previous Topic: How Can Configue RMAN To Auto delete unnesessary ARCHIVELOG
Next Topic: how we take backup in tape
Goto Forum:
  


Current Time: Thu Dec 08 10:15:51 CST 2016

Total time taken to generate the page: 0.19750 seconds