1. 登陆oracle
SecureCRT登录服务器,切换用户oracle,连接oracle
[root@userbeta~]# su - oracle
[oracle@userbeta~]$ sqlplus /nolog
SQL> connect /as sysdba
2. 计算flash recovery area已经占用的空间
SQL> select sum(percent_space_used)*3/100 from v$flash_recovery_area_usage;
3. 查看db_recovery_file_dest_size大小
SQL> show parameter db_recovery_file_dest_size;
4. 扩容
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=20g;
5. 关闭归档日志
shutdown immediate;
startup mount;
alter database noarchivelog;
alter database open;
archive log list;
参考链接:
1. https://jingyan.baidu.com/article/3065b3b6e202ccbecef8a411.html