What is data hot backup?
Hot backup is a method of backing up the database in the Archivelog mode when the database is running.
If you have a cold backup from last night and today’s hot backup file, you can use these data to restore more information when a problem occurs. Hot backup requires the database to operate in Archivelog mode and requires a large amount of archive space. Once the database is running in the archivelog state, it can be backed up. The command file for hot backup consists of three parts:
1. Datafiles are backed up tablespace by tablespace.
(1) Set the tablespace to backup state
(2) Back up the data files of the tablespace
(3) Restore the tablespace to normal state
2. Backup and archive log files
(1) Temporarily stop the archiving process
(2) Those files in the archive rede log target directory under the log
(3) Restart the archive process
(4) Backup archived redo log files
3. The advantages of using the alter database bachup controlfile command to back up the control file hot backup are:
1. It can be backed up at the table space or database file level, and the backup time is short.
2. The database can still be used while backing up.
3. Second-level recovery (recovery to a certain point in time) can be achieved.
4. Can restore almost all database entities
5. Recovery is fast and in most cases loves recovery while the database is still working.