修改需要在mount状态下

  • shutdown immediate;
  • startup mount;
  • alter database archivelog;
  • alter database flashback on;
  • alter database open;
  • archive log list;
  • select flashback_on from v$database;