OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » 1 year backups

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

1 year backups [message #182083]

Wed, 12 July 2006 22:37

mahi02
Messages: 11
Registered: July 2006

Junior Member

Hi,
In the place iam working they want weekly,monthly and yearly backups of the whole data in such a way that after taking the backup of the whole year we want the whole old data to be removed from that system and be backedup to elsewhere but should be able to retrieve the data whenever required.
Thanks.

Report message to a moderator

Re: 1 year backups [message #182095 is a reply to message #182083]

Thu, 13 July 2006 00:32

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Perhaps you could consider building a warehouse; having it, all history data would be accessible all the time, while production database would hold only this year's data.

If you do the backup (of course, that is really not an "IF" - what kind of a DBA doesn't have a valid backup?) and store it somewhere (tape, for example), it would take some time to restore it in order to make it accessible whenever required.

Therefore, I guess that you should have both versions up and running.

Report message to a moderator

Re: 1 year backups [message #182204 is a reply to message #182083]

Thu, 13 July 2006 10:35

mahi02
Messages: 11
Registered: July 2006

Junior Member

Thanks for the reply and Iam thinking to take a whole year tape backup plus this warehouse idea seems to be good because extracting data from the tape seems to be a little slow for the monthly backups itself,so can you please give me an idea for how to build this warehouse.

Report message to a moderator

Re: 1 year backups [message #182213 is a reply to message #182204]

Thu, 13 July 2006 15:17

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Brick by brick Wink

Here is an article you might be interested in.

Report message to a moderator

Previous Topic:	Backup in 9i Restore in 10g.
Next Topic:	OEM problems

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 11:54:18 CST 2024