Situatie
Solutie
srvctl stop database -d <database_name>
SQL> conn / as sysdba
SQL> startup mount;
SQL> alter system set db_recovery_file_dest = ‘+FRAX01′ scope=both sid=’*’;
SQL> alter system set db_recovery_file_dest_size = ’20G’ scope=both sid=’*’;
SQL> alter database archivelog;
SQL> alter database open;
SQL> select log_mode from v$database;
SQL> archive log list;
SQL> alter system switch logfile;
SQL> shutdown immediate;
srvctl start database -d <database_name>
Leave A Comment?