show parameter log_archive_dest
shutdown immediate;
startup mount;
alter database noarchivelog;
alter database open;
SQL> show parameter log_archive_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest string
log_archive_dest_1 string location=/u01/gmdb01backup/arc
hivelog_bk mandatory reopen=12
0
log_archive_dest_10 string
log_archive_dest_11 string
删除/u01/gmdb01backup下的文件
关闭归档 :shutdown immediate;
startup mount;
alter database noarchivelog;
alter database open;