查看当前归档信息;
centos@SYS> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST ---->归档路径为快速恢复区路径 Oldest online log sequence 1 Next log sequence to archive 3 Current log sequence 3 centos@SYS> show parameter db_recovery_file_dest NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /u01/app/oracle/flash db_recovery_file_dest_size big integer 3G centos@SYS>
修改数据库为非归档模式(开启、关闭归档模式都需在mount模式下修改);
centos@SYS> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. centos@SYS> startup mount ORACLE instance started. Total System Global Area 830930944 bytes Fixed Size 2257800 bytes Variable Size 587205752 bytes Database Buffers 239075328 bytes Redo Buffers 2392064 bytes Database mounted. centos@SYS> alter database noarchivelog; Database altered. centos@SYS> archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 1 Current log sequence 3 centos@SYS> alter database open; Database altered. centos@SYS>
修改数据库为归档模式;
centos@SYS> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. centos@SYS> startup mount ORACLE instance started. Total System Global Area 830930944 bytes Fixed Size 2257800 bytes Variable Size 587205752 bytes Database Buffers 239075328 bytes Redo Buffers 2392064 bytes Database mounted. centos@SYS> alter database archivelog; Database altered. centos@SYS> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 1 Next log sequence to archive 3 Current log sequence 3 centos@SYS> alter database open; Database altered. centos@SYS>