好贷网好贷款

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

发布时间:2016-12-5 2:24:39 编辑:www.fx114.net 分享查询网我要评论
本篇文章主要介绍了"数据库归档与非归档的转换",主要涉及到数据库归档与非归档的转换方面的内容,对于数据库归档与非归档的转换感兴趣的同学可以参考一下。

[[email protected] ~]# su - oracle [[email protected] ~]$ sqlplus /nolog SQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 2 10:47:46 2013 Copyright (c) 1982, 2011, Oracle. All rights reserved. idle> conn /as sysdba Connected. [email protected]> archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 5 Current log sequence 7 [email protected]> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. [email protected]> startup mount; ORACLE instance started. Total System Global Area 2505338880 bytes Fixed Size 2230952 bytes Variable Size 553649496 bytes Database Buffers 1929379840 bytes Redo Buffers 20078592 bytes Database mounted. [email protected]> alter database archivelog; Database altered. [email protected]> alter database open; Database altered. [email protected]> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 5 Next log sequence to archive 7 Current log sequence 7 [email protected]> shutdown immedaite; SP2-0717: illegal SHUTDOWN option [email protected]> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. [email protected]> startup mount; ORACLE instance started. Total System Global Area 2505338880 bytes Fixed Size 2230952 bytes Variable Size 553649496 bytes Database Buffers 1929379840 bytes Redo Buffers 20078592 bytes Database mounted. [email protected]> alter database noarchivelog; Database altered. [email protected]> alter database open; Database altered. [email protected]> archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 5 Current log sequence 7 [email protected]> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. [email protected]> startup mount; ORACLE instance started. Total System Global Area 2505338880 bytes Fixed Size 2230952 bytes Variable Size 553649496 bytes Database Buffers 1929379840 bytes Redo Buffers 20078592 bytes Database mounted. [email protected]> alter database archivelog; Database altered. [email protected]> alter database open; Database altered. [email protected]> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 5 Next log sequence to archive 7 Current log sequence 7   总结: 在mount状态下转换, 使用alter database archivelog;转为归档 使用alter database noarchivelog;转为非归档 最后打开数据库alter database open;    

上一篇:设计模式之调停者模式
下一篇:Android常用动画alpha和rotate同时使用

相关文章

相关评论