| RMAN backups [message #327313] |
Mon, 16 June 2008 00:44  |
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
|
Member |
|
|
Hi all,
I have recently joined a new company, where the client has given me a production server of size 126 GB. I was informed that the backup strategy they currently follow is Full exports(nightly) and they need to implement RMAN backukps. So i have prepared a backup strategy of:
1) Differential incremental level 0 backups weekly once and ,
2) Differential incremental level 1 backups on the other days.
My question is if this strategy ok for the database of 126 GB?
Shall the full export be continued?
The production server is currently in NOARCHIVE mode...I decided to take the database to ARCHIVE mode,So i also want to know the approximate size that will be required for the archivelog location and for the RMAN backups?...Pls i need help in allocating the optimal space for the backups,how to go about with this?
Thanks,
Arun.
|
|
|
|
| Re: RMAN backups [message #327315 is a reply to message #327313] |
Mon, 16 June 2008 00:52  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>I was informed that the backup strategy they currently follow is Full exports(nightly)
Good luck. 
I would never ever ever never depend just on exported dumps, if the database is somewhat worthy.
>>1) Differential incremental level 0 backups weekly once and ,
Level 0 is just full backup.
>>Shall the full export be continued?
Depends on the database.
If your client agrees to wait forever to restore (through import).
For a transactional database, this is not quite useful.
>>So i also want to know the approximate size that will be required for the archivelog location
Will depend on behavior of database.
Insert/deletes/updates all will cause more archive logs.
You should know better about your database.
>>Pls i need help in allocating the optimal space for the backup
same as above.
Depends on what the database is doing.
[Updated on: Mon, 16 June 2008 00:52] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
