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

Report message to a moderator

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

Report message to a moderator

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?

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

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: 10708
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.

Report message to a moderator

Previous Topic: Oracle 9i -> Oracle 10g
Next Topic: problem creating auxiliary db using RMAN, Help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 20:15:05 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.