Backup [message #57045] |
Fri, 16 May 2003 09:12 |
M. Gopinath
Messages: 6 Registered: April 2003
|
Junior Member |
|
|
Hi,
My Advance thanks for your response.
I am a Junior DBA in my concern (recently employed) where we have database of 120 GB, regular backup of this database (some important schemas) takes 5 hrs .
Also i learned about Incremental Backup in oracle, where we need to take a full backup as first step.
My question is, if I perform incremental backup after a full backup, will it reduce my backup time???.
Actual transaction of a day (2000 -3000 entries).
FYI : I have a test server to check the difference.
So pls help me. I need a guidance.
Thank you.
Gopinath. M
|
|
|
Re: Backup [message #57053 is a reply to message #57045] |
Sat, 17 May 2003 06:47 |
Deepa
Messages: 269 Registered: November 2000
|
Senior Member |
|
|
Actually incremental backup is supported when ur are have a backupstrategy using RMAN.
Obviously, it will reduce time.
First time u need to take a full back up.
Then U do an incremental backup which are backups of a
datafile that contain only blocks that changed after a previous incremental backup.
Go though the RMAN guide to get a full idea ...
|
|
|