Q
Problem solve Get help with specific problems with your technologies, process and projects.

Is a hot backup part of a backup database using RMAN?

How can the System Change Number (SCN) be used to perform a hot backup for a backup database using RMAN? Learn the answer here.

Does RMAN put the Oracle database in hot backup mode (e.g. alter database begin backup) when doing an Oracle database backup? If not, what kind of mechanism does RMAN use when doing the backup?
RMAN does not use the traditional ALTER DATABASE BEGIN|END BACKUP commands that user-managed hot backups leverage. Instead, RMAN uses the System Change Number (SCN) to help with hot backups. RMAN notes the SCN when it begins and ends the hot backup of the tablespace. If RMAN needs to resolve any inconsistencies, it can use the SCN knowledge to help it. Both RMAN and user-managed hot backups rely on archived redo logs for keeping track of changes to the file.

Dig Deeper on Oracle database administration

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close