| Bckup Stratergy [message #454157] |
Tue, 04 May 2010 05:01  |
goracle9
Messages: 136
Registered: December 2006
|
Senior Member |
|
|
Dear Experts,
We have 2 production database, my Backup procedure as like below
Backup Method. Backup Location
---------------------------- -------------------
1.daily Full database dump Database Machine itself
2.daily Hot-backup Database Machine itself
3.weekly Rman Backup Database Machine itself
all the above 3 backup files & archive are stored in a location /u07 in diffrenet Folders
daily i m storing full /u07 to a tape
daily i m changing the tape, then next week i m using same tape in round robin corresponding day.
more than that i keep the Dump file to another IP=30 also.
i m copying that hot backup and rman backup weekly twise in the IP 30
monthly and yearly also keeping as in Dump and in seperate tape backup also
please suggest is the enough or still any suggestion.
|
|
|
|
|
|
| Re: Bckup Stratergy [message #454292 is a reply to message #454158] |
Wed, 05 May 2010 00:16  |
goracle9
Messages: 136
Registered: December 2006
|
Senior Member |
|
|
Mr.Michel
my Archive log location is /u07/arch
i m baking full /u07 drive to tape daily
is it enough or what
please suggest to improve my Bckup Stratergy
thanks.
|
|
|
|
|
|
|
|
|
|
| Re: Bckup Stratergy [message #455380 is a reply to message #454337] |
Tue, 11 May 2010 06:54 |
mdba
Messages: 2
Registered: August 2009
Location: UK
|
Junior Member |
|
|
I believe the weekly RMAN backup is level0 backup. If yes then you can schedule a level1 backup daily.
It wil complete the backup strategy and you would be able to do a recovery with RMAN backup when required.
Regards,
mdba
[Updated on: Tue, 11 May 2010 07:07] Report message to a moderator |
|
|
|
| Re: Bckup Stratergy [message #455390 is a reply to message #455380] |
Tue, 11 May 2010 07:19 |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:It wil complete the backup strategy and you would be able to do a recovery with RMAN backup when required.
Not at all if you don't backup the archived logs (how many times I said this in this topic?).
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
