Home » RDBMS Server » Backup & Recovery » RMAN backups (oracle 9i,windows server 2003)
RMAN backups [message #327313] Mon, 16 June 2008 00:44 Go to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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. Smile
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

Re: RMAN backups [message #327325 is a reply to message #327313] Mon, 16 June 2008 01:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Backup and Recovery Basics
For instance, Chapter 2 Backup and Recovery Strategies

Regards
Michel
Re: RMAN backups [message #327356 is a reply to message #327325] Mon, 16 June 2008 03:54 Go to previous message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
Thanks Mahesh and Michel..
Previous Topic: Invalid Password File error while performing Restore
Next Topic: rman
Goto Forum:
  


Current Time: Tue Dec 06 06:29:12 CST 2016

Total time taken to generate the page: 0.15154 seconds