Q

RMAN cold backup vs. hot backup

Why would you want to do an RMAN cold backup vs. hot? What's the difference?

Why would you want to do an RMAN cold backup vs. hot? What does this buy me? What about the downtime of the database?
DBAs like a cold backup because the backup is consistent across the board. More than anything, they like the comfort factor of a nice, consistent backup. Hot backups will result in inconsistencies in the backed up datafiles. RMAN will resolve these inconsistencies on recovery, after a restore. For many DBAs, it is a comfort factor.

That being said, there are two areas to consider. If you perform a cold backup, you must have downtime for your database. If you cannot afford the downtime, then a cold backup is not for you. If you want or need to perform a hot backup, then you must be running in archive log mode.

Cold backups are easy, do not require archived redo logs, but require downtime. Hot backups do not require any downtime, but are a little more complex and require archived redo logs.

This was first published in June 2004

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close