oracel某实例改成归档模式

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;