话不多说直接肝;
第一步:
以sysdba登录数据库:
oracle>./sqlplus /nolog SQL> conn sys/sys as sysdba #以sysdba登录数据库: Connected.
第二步:关闭数据库开启归档功能
SQL> shutdown immediate; #关闭数据库 并卸载数据库 Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; #启动数据库例程 ORACLE instance started. Total System Global Area 3256942592 bytes Fixed Size 2217752 bytes Variable Size 1778387176 bytes Database Buffers 1459617792 bytes Redo Buffers 16719872 bytes Database mounted. #装载完毕 SQL> alter database archivelog; #打开归档日志功能 Database altered. SQL> alter database open; #打开数据库 Database altered. SQL> archive log list; #查询归档日志状态 Database log mode Archive Mode #数据库日志模式--存档模式 Automatic archival Enabled #自动存档--启用 Archive destination USE_DB_RECOVERY_FILE_DEST #存档点 Oldest online log sequence 6 #最早联机日志序列 Next log sequence to archive 8 # 下一个日志序列 Current log sequence 8 #当前日志序列 SQL> quit
第三步,关闭数据库归档日志功能
SQL> shutdown immediate; #关闭数据库 并卸载数据库 Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; #启动数据库例程 ORACLE instance started. Total System Global Area 3256942592 bytes Fixed Size 2217752 bytes Variable Size 1778387176 bytes Database Buffers 1459617792 bytes Redo Buffers 16719872 bytes Database mounted. #装载完毕 SQL> alter database noarchivelog; #关闭归档日志功能 Database altered. SQL> alter database open; #打开数据库 Database altered. SQL> archive log list; #查询归档日志状态 Database log mode Archive Mode #数据库日志模式--存档模式 Automatic archival disable #自动存档--禁用 Archive destination USE_DB_RECOVERY_FILE_DEST #存档点 Oldest online log sequence 6 #最早联机日志序列 Next log sequence to archive 8 # 下一个日志序列 Current log sequence 8 #当前日志序列 SQL> quit 查询归档日志空间大小:
SQL> show parameter db_recovery_file_dest; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /volumes01/app/flash_recovery_ area db_recovery_file_dest_size big integer 10G SQL>
设置归档日志空间:
SQL> alter system set db_recovery_file_dest_size=10737418240; --计算方法:10G=10*1024*1024*1024=10737418240;