oracel某实例改成归档模式
1. export ORACLE_SID=tst01
2. sqlplus /nolog
3. conn /as sysdba
4. shutdown immediate;
5. startup mount
6.alter database archivelog;
7.alter system set log_archive_dest_1='location=/home/oracle/datalogs/archivelogs';
8.alter database open;
可以用archive log list
将归档模式改为非归档模式
1. export ORACLE_SID=tst01
2. sqlplus /nolog
3. conn /as sysdba
4. shutdown immediate;
5. startup mount;
6. alter database noarchivelog;
alter database open;