Show pageOld revisionsBacklinksODT exportBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== Log management ====== **Switch to archivelog mode : ** <sxh sql> alter system set log_archive_dest_1='LOCATION=/oracat/log/ORACAT/archive' scope=both; shutdown immediate; startup mount; alter database archivelog; alter database open; alter system switch logfile; archive log list; </sxh> **Check the recovery area :** <sxh sql> show parameter recovery </sxh> **Change between archivelog / noarchivelog mode ** <sxh sql> shutdown immediate; startup mount; alter database archivelog / noarchivelog; alter database open; </sxh> oracle_log.txt Last modified: 2019/10/18 20:04by 127.0.0.1