Home » RDBMS Server » Backup & Recovery » time for rman backup
time for rman backup [message #227302] Tue, 27 March 2007 23:05 Go to next message
sunsanvin
Messages: 60
Registered: April 2006
Location: Hyderabad
Member

Dear Friends,
what could be the ideal time for rman backup for a 100 gb database?


thank you very much
Re: time for rman backup [message #227303 is a reply to message #227302] Tue, 27 March 2007 23:16 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

what could be the ideal time for rman backup for a 100 gb database?

Always recommended for backup when minimum activity on database.

regards
Taj
Re: time for rman backup [message #227306 is a reply to message #227302] Tue, 27 March 2007 23:28 Go to previous messageGo to next message
sunsanvin
Messages: 60
Registered: April 2006
Location: Hyderabad
Member

After minimising all the activities, what will be the general time to take a rman backup for 100gb?
Re: time for rman backup [message #227308 is a reply to message #227306] Tue, 27 March 2007 23:30 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

what will be the general time to take a rman backup for 100gb?

It is really very hard to say becuase it is depand on your ORACLE and OS configuration...
of which type of backup >>> full , incremental.


You should try first on test enviourment and after that you implement on production database.
regards
Taj
Re: time for rman backup [message #227309 is a reply to message #227302] Tue, 27 March 2007 23:32 Go to previous messageGo to next message
sunsanvin
Messages: 60
Registered: April 2006
Location: Hyderabad
Member

Dear Friend, actually i'm asking this for an interview purpose
Re: time for rman backup [message #227314 is a reply to message #227309] Tue, 27 March 2007 23:43 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Dear Friend, actually i'm asking this for an interview purpose

then say you interviewer it is very hard to say...
it is depand on many factors.



regards
Taj
Re: time for rman backup [message #227494 is a reply to message #227314] Wed, 28 March 2007 07:07 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Actual time taken / size of backupsets depends on many factors.
Incremental backup does not essential mean that backups are faster and smaller in size.
It depends the transactions you make. More transactions, more archived logs to backup.
It depdends on your database design. If the tablespace has multiple datafiles spread across, the only datafiles that were active would be backed up.
Depends on channels you have allocated and hardware resources.
Previous Topic: Oracle 9i -> Oracle 10g
Next Topic: problem creating auxiliary db using RMAN, Help
Goto Forum:
  


Current Time: Sat Dec 10 20:24:17 CST 2016

Total time taken to generate the page: 0.04088 seconds