To use RMAN to perform hot backup, you must manually switch the database to the archivelog mode by referring to the following steps.
It is recommended that you perform the following operations directly on the server.
- Change the values of log_archive_format and log_archive_dest_1.
alter system set log_archive_format='ora11_%r_%t_%s.log' scope=spfile;
alter system set log_archive_dest='' scope=spfile;
alter system set log_archive_dest_1='LOCATION=/opt/oracle/product/11gR2/db/dbs' scope=spfile;
NOTE: Here, /opt/oracle/product/11gR2/db/dbs is the path where archive logs locate. Change the path based on the site requirements.
- Change the database status to shut down.
shutdown immediate
- Change the database status to mounted.
startup mount
- Change the database log mode to ARCHIVELOG.
alter database ARCHIVELOG;
- Change the database status to opened.
alter database open;
