数据库归档与非归档的转换

来源：互联网发布：直播变脸软件编辑：程序博客网时间：2024/05/29 01:53

[root@rtest ~]# su - oracle[oracle@rtest ~]$ sqlplus /nologSQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 2 10:47:46 2013Copyright (c) 1982, 2011, Oracle.  All rights reserved.idle> conn /as sysdbaConnected.sys@TESTDB> archive log list;Database log mode              No Archive ModeAutomatic archival             DisabledArchive destination            USE_DB_RECOVERY_FILE_DESTOldest online log sequence     5Current log sequence           7sys@TESTDB> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.sys@TESTDB> startup mount;ORACLE instance started.Total System Global Area 2505338880 bytesFixed Size                  2230952 bytesVariable Size             553649496 bytesDatabase Buffers         1929379840 bytesRedo Buffers               20078592 bytesDatabase mounted.sys@TESTDB> alter database archivelog;Database altered.sys@TESTDB> alter database open;Database altered.sys@TESTDB> archive log list;Database log mode              Archive ModeAutomatic archival             EnabledArchive destination            USE_DB_RECOVERY_FILE_DESTOldest online log sequence     5Next log sequence to archive   7Current log sequence           7sys@TESTDB> shutdown immedaite;SP2-0717: illegal SHUTDOWN optionsys@TESTDB> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.sys@TESTDB> startup mount;ORACLE instance started.Total System Global Area 2505338880 bytesFixed Size                  2230952 bytesVariable Size             553649496 bytesDatabase Buffers         1929379840 bytesRedo Buffers               20078592 bytesDatabase mounted.sys@TESTDB> alter database noarchivelog;Database altered.sys@TESTDB> alter database open;Database altered.sys@TESTDB> archive log list;Database log mode              No Archive ModeAutomatic archival             DisabledArchive destination            USE_DB_RECOVERY_FILE_DESTOldest online log sequence     5Current log sequence           7sys@TESTDB> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.sys@TESTDB> startup mount;ORACLE instance started.Total System Global Area 2505338880 bytesFixed Size                  2230952 bytesVariable Size             553649496 bytesDatabase Buffers         1929379840 bytesRedo Buffers               20078592 bytesDatabase mounted.sys@TESTDB> alter database archivelog;Database altered.sys@TESTDB> alter database open;Database altered.sys@TESTDB> archive log list;Database log mode              Archive ModeAutomatic archival             EnabledArchive destination            USE_DB_RECOVERY_FILE_DESTOldest online log sequence     5Next log sequence to archive   7Current log sequence           7

总结：

在mount状态下转换，
使用alter database archivelog;转为归档
使用alter database noarchivelog;转为非归档
最后打开数据库alter database open;