Home » RDBMS Server » Backup & Recovery » Backup
Backup [message #57045] Fri, 16 May 2003 09:12 Go to next message
M. Gopinath
Messages: 6
Registered: April 2003
Junior Member
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 Go to previous message
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 ...
Previous Topic: recovery using a backuped control file!
Next Topic: RMAN and import
Goto Forum:

Current Time: Sat May 25 09:06:46 CDT 2024