OraFAQ Forum: Backup & Recovery » time for rman backup

Home » RDBMS Server » Backup & Recovery » time for rman backup

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

time for rman backup [message #227302]

Tue, 27 March 2007 23:05

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

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

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

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

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

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 07 16:59:04 CDT 2026