异常断电导致Oracle控制文件等受到破坏的处理(二)

SQL> alter system set log_archive_max_processes = 5;

SQL> alter system set log_archive_format = "archive_%t_%s_%r.arc" scope=spfile;

2、重启数据库

SQL> shutdown immediate

SQL> startup mount;

SQL> alter database archivelog;

SQL> alter database open;

3、确认

SQL> archive log list;