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
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.