When we want to take hot bkp, we keep the tbspaces in begin backup mode. In this mode all headers of the datafiles will be freezed till end the begin backup mode.recommended not to keep in this mode for longer time.

Because the db may go to hung state because of generating huge no.of archive logs and if there is no space in archive destination.

Jyoti Pandey |

| 04 Sep 2015 1:26 pm

Helpful answer

And also it will not generate the SCN number which is very imp in case of DR out of sync or any other issues. when the headers are freezed.

Oracle Database Interview Questions and Answers
1. On which component can I open an SAP message if there are problems with the Oracle database?The following components are available:BC-DB-ORA: OracleBC-DB-ORA-DBA: BR*TOOLS for the database...