博客访问： 928345
博文数量： 160
博客积分： 1857
博客等级： 上尉
技术积分： 2366
注册时间：
认证徽章：
吾生有涯,而知无涯,适当止学.循序渐进,步步提升
IT168企业级官微
微信号：IT168qiye
系统架构师大会
微信号：SACC2013
分类： Oracle
一：以归档模式运行数据库
1.shutdown immediate关闭数据库
[oracle@oracle-n1 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 7 11:30:42 2012
Copyright (c) , Oracle.& All rights reserved.
Connected to an idle instance.
2.启动数据库到mount状态
SQL> startup mount
ORACLE instance started.
Total System Global Area
Fixed Size&&&&&&&&&&&&&&&&& 2212776 bytes
Variable Size&&&&&&&&&&&&
Database Buffers&&&&&&&&&
Redo Buffers&&&&&&&&&&&&&&& 9232384 bytes
Database mounted.
3.启用或停止归档模式
开启归档模式
SQL> alter
Database altered.
Database altered.
Database log mode&&&&&&&&&&&&& Archive Mode
Automatic archival&&&&&&&&&&&& Enabled
Archive destination&&&&&&&&&&& /data/ora11g/product/11.2.0/db_1/dbs/arch
Oldest online log sequence&&&& 97
Next log sequence to archive&& 99
Current log sequence&&&&&&&&&& 99
关闭归档模式
Database closed.
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area
Fixed Size&&&&&&&&&&&&&&&&& 2212776 bytes
Variable Size&&&&&&&&&&&&
Database Buffers&&&&&&&&&
Redo Buffers&&&&&&&&&&&&&&& 9232384 bytes
Database mounted.
SQL> alter d
Database altered.
Database altered.
Database log mode&&&&&&&&&&&&& No Archive Mode
Automatic archival&&&&&&&&&&&& Disabled
Archive destination&&&&&&&&&&& /data/ora11g/product/11.2.0/db_1/dbs/arch
Oldest online log sequence&&&& 97
Current log sequence&&&&&&&&&& 99
阅读(1390) | 评论(0) | 转发(0) |
相关热门文章
给主人留下些什么吧！~~
请登录后评论。查看: 1984|回复: 12
Oracle开启归档模式有什么缺陷
认证徽章论坛徽章:16
今天总监说弄一个Oracle关闭归档模式，而且要每周备份一次，我想来可能是归档模式影响性能吧，不知道对不对，另外不开启归档模式貌似只能用数据泵备份了吧，数据泵备份有什么缺陷吗，听说数据泵备份慢
论坛徽章:17
只有开启归档才能做数据库的完全恢复、即恢复崩溃之前所有提交的数据。另外，非归档模式不能做表空间或数据文件的联机备份。开启归档后会有一些CPU和内存的开销、但是不算很大。还有就是要消耗一些硬盘空间以存放归档日志文件。并需要DBA管理和维护这些归档日志文件。
论坛徽章:17
(186.5 KB, 下载次数: 53)
17:36 上传
点击文件名下载附件
论坛徽章:17
以上是摘自《Oracle DBA 培训教程——从实践中学习Oracle数据库管理与维护（第2版），清华大学出版社出版，作者何明》的第17章，是专门介绍归档日志的，写的比较详细。
认证徽章论坛徽章:242
数据泵备份的只是一个快照，也就只能恢复到那个状态
认证徽章论坛徽章:16
paulminghe 发表于
谢谢，我下载下来了
认证徽章论坛徽章:16
那这么说我用数据泵做备份可以吗，只能恢复到备份那个点，RMAN就能恢复出所有的数据是吧
认证徽章论坛徽章:16
paulminghe 发表于
以上是摘自《Oracle DBA 培训教程——从实践中学习Oracle数据库管理与维护（第2版），清华大学出版社出版， ...
RMAN可以恢复所有是吧
论坛徽章:17
royzs 发表于
RMAN可以恢复所有是吧
不一定，即使使用RMAN，要全恢复也必须使用归档模式。
认证徽章论坛徽章:16
royzs 发表于
RMAN可以恢复所有是吧
要使用RMAN备份不是首先就要开启归档模式吗
itpub.net All Right Reserved. 北京皓辰网域网络信息技术有限公司版权所有　　　　
　北京市公安局海淀分局网监中心备案编号：　广播电视节目制作经营许可证：编号（京）字第1149号设置oracle归档模式出现的问题 -
- ITeye技术网站
博客分类：
在虚拟机上安装了oracle 11g数据库，就是为了自己平时做实验什么的，今天上午想把数据库设置为归档模式下运行，结果搞出问题了，整了一个多小时才搞定，不过这个过程还是蛮有意思的，记录下来和大家分享，不足之处，欢迎大家批评指正。
将一个数据库设置为归档模式一般要经过以下几个步骤：
(1)设置归档目录：
md C:\oracle\archive1
md C:\oracle\archive2
(2)设置参数命名第(1)步中创建的两个目标目录，并控制归档日志文件名：(以sys用户连接)
alter system set log_archive_dest_1='location=C:\oracle\archive1' scope=
alter system set log_archive_dest_2=’location=C:\oracle\archive2’ scope=
alter system set log_archive_format=’arch_%d_%t_%r_%s.log’ scope=
(3)干净的关闭数据库：
Shutdown immediate
(4)以加载模式启动数据库:
startup mount
(5)将数据库转换成归档日志模式：
(6)打开数据库：
(7)确认数据库为归档日志模式，并用下列两个查询运行归档器：
Select log_mode from v$
Select archiver from v$
按照上述步骤我在设置数据库归档时，在第二步中，在设置归档日志文件名称时，自己写错了，写成如下了：
alter system set log_archive_format=’arch_%d_%t_%s.log’ scope=
将%r参数给丢了，但是数据的数据库给出的提示是：“系统已更改。”
这一步并没有给出错误提示，所以没有注意丢东西了。接下来是干净的关闭数据库，这一步也没有问题，然后以加载模式启动数据库，这个时候出问题了，问题提示如下：
ORA-19905: log_archive_format must contain %s, %t and %r
这说明是设置归档文件名称时缺少了%r导致的，log_archive_format参数设置归档日志文件的名称是在文件名称中添加了一些动态的参数，防止文件重名被覆盖，其中%s表示日志切换序列号，%t表示线程号，%r表示场景号；现在数据库已经干净关闭了，然而spfile又出了问题，数据库已经无法启动了，现在想再重新设置这个参数已经不可能了（看来oracle这一点做的还是不够好啊，如果参数设置出现问题了，应该在设置时就提示设置错误，在设置的时候没有给出提示，而是在启动的时候提示参数错误）。
在网上查了一下资料只能通过init.ora文件重建spfile文件来解决这个问题了，在数据库安装目录中搜索到init.ora.(我理解这个应该是init.ora的备份文件，不知道正确不，所以后面的数字每个机器应该是不同的，要所要按照init.ora匹配搜索)文件，找到这个文件后，执行命令，创建spfile文件：
create spfile from pfile='C:\app\Administrator\admin\orcl\pfile\init.ora.';
尝试启动数据库：startup
启动结果如下：
ORACLE 例程已经启动。
Total System Global Area
Fixed Size
1375088 bytes
Variable Size
Database Buffers
Redo Buffers
6037504 bytes
ORA-00214: ???? ''C:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL01.CTL'' ?? 1726 ???
''C:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\CONTROL02.CTL'' ?? 1713 ???
数据库已经可以启动了，但是出现了ora-00214错误，这个是控件文件的错误，在设置归档之前我曾经设置过数据库控制文件的多路复用，现在重新设置一下控制文件的位置：
alter system set control_files="C:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL01
.CTL","C:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL02.CTL" scope=
这个时候再关闭重新启动一下数据库试试，终于搞定了：
ORACLE 例程已经启动。
Total System Global Area
Fixed Size
1375088 bytes
Variable Size
Database Buffers
Redo Buffers
6037504 bytes
数据库装载完毕。
数据库已经打开。
虽然问题是搞定了，但是还是有一个问题没有搞明白，在重新创建spfile文件之后尝试启动数据库为什么会出现控制文件的错误，另外在错误提示中的
ORA-00214: ???? ''C:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL01.CTL'' ?? 1726 ???
''C:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\CONTROL02.CTL'' ?? 1713 ???
两个位置的控制文件都是存在的，而且是建库时系统创建的控制文件，内容肯定没错，但是为什么还是会报错，这个和我以前调整过数据库控制文件参数有关系吗？欢迎大家解答、指正。
浏览: 26455 次
来自: 北京RAC环境下归档模式修改从10G R2以后，不再修改cluster_database参数，参考链接。步骤如下所示：
1. The following steps need to be taken to enable archive logging in a RAC database environment:— shutdown immediate all database instances$ srvctl stop database -d &db_unique_name&— startup database in mount mode$ srvctl start database -d &db_unique_name& -o mount— enable archive logging$ sqlplus / as sysdbasql& altersql&— stop database$ srvctl stop database -d &db_unique_name&— restart all database instances$ srvctl start database -d &db_unique_name&— verify archiving is enabled/disabled by means of:sql&&
以上是开启RAC环境下归档模式步骤，非归档模式亦然。下面是SuSE11SP3 11gR2RAC环境演示。
1、开启归档
（1）、关闭所有实例
:~& srvctl stop database -d ORACLE
:~& crsctl status res -t
——————————————————————————–
NAME & & & & & TARGET &STATE & & & &SERVER & & & & & & & & & STATE_DETAILS & & &&
——————————————————————————–
Local Resources
——————————————————————————–
ora.DATA.dg
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.FRA.dg
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.LISTENER.lsnr
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.OCR.dg
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & Started & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & Started & & & & & &&
& & & & & & & &OFFLINE OFFLINE & & &jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &OFFLINE OFFLINE & & &jason2 & & & & & & & & & & & & & & & & & & &&
ora.net1.network
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.registry.acfs
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
——————————————————————————–
Cluster Resources
——————————————————————————–
ora.LISTENER_SCAN1.lsnr
& & & 1 & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & 1 & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
ora.jason1.vip
& & & 1 & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
ora.jason2.vip
& & & 1 & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & 1 & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
ora.oracle.db
& & & 1 & & & &OFFLINE OFFLINE & & & & & & & & & & & & & & & Instance Shutdown &&
& & & 2 & & & &OFFLINE OFFLINE & & & & & & & & & & & & & & & Instance Shutdown &&
ora.scan1.vip
& & & 1 & & & &ONLINE &ONLINE & & & jason2 & & & &
（2）、启动实例到mount状态 & & & & & & & & & & & & & & &&
:~& srvctl start &database -d ORACLE -o mount
:~& crsctl status res -t
——————————————————————————–
NAME & & & & & TARGET &STATE & & & &SERVER & & & & & & & & & STATE_DETAILS & & &&
——————————————————————————–
Local Resources
——————————————————————————–
ora.DATA.dg
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.FRA.dg
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.LISTENER.lsnr
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.OCR.dg
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & Started & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & Started & & & & & &&
& & & & & & & &OFFLINE OFFLINE & & &jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &OFFLINE OFFLINE & & &jason2 & & & & & & & & & & & & & & & & & & &&
ora.net1.network
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.registry.acfs
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
——————————————————————————–
Cluster Resources
——————————————————————————–
ora.LISTENER_SCAN1.lsnr
& & & 1 & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & 1 & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
ora.jason1.vip
& & & 1 & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
ora.jason2.vip
& & & 1 & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & 1 & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
ora.oracle.db
& & & 1 & & & &ONLINE &INTERMEDIATE jason1 & & & & & & & & & Mounted (Closed) & &
& & & 2 & & & &ONLINE &INTERMEDIATE jason2 & & & & & & & & & Mounted (Closed) & &
ora.scan1.vip
& & & 1 & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
（3）、开启归档模式
:~& sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Fri Jan 8 19:29:47 2016
Copyright (c) , Oracle. &All rights reserved.
SQL& conn /as sysdba
Connected.
Database log mode & & & & & No Archive Mode
Automatic archival & & & & & & Disabled
Archive destination & & & & & &USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence & & 8
Current log sequence & & & & & 9
SQL& alter
Database altered.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
（4）、再次关闭实例
切换至grid用户
:~& srvctl stop database -d ORACLE
:~& crsctl status res -t
——————————————————————————–
NAME & & & & & TARGET &STATE & & & &SERVER & & & & & & & & & STATE_DETAILS & & &&
——————————————————————————–
Local Resources
——————————————————————————–
ora.DATA.dg
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.FRA.dg
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.LISTENER.lsnr
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.OCR.dg
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & Started & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & Started & & & & & &&
& & & & & & & &OFFLINE OFFLINE & & &jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &OFFLINE OFFLINE & & &jason2 & & & & & & & & & & & & & & & & & & &&
ora.net1.network
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.registry.acfs
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
——————————————————————————–
Cluster Resources
——————————————————————————–
ora.LISTENER_SCAN1.lsnr
& & & 1 & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & 1 & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
ora.jason1.vip
& & & 1 & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
ora.jason2.vip
& & & 1 & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & 1 & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
ora.oracle.db
& & & 1 & & & &OFFLINE OFFLINE & & & & & & & & & & & & & & & Instance Shutdown &&
& & & 2 & & & &OFFLINE OFFLINE & & & & & & & & & & & & & & & Instance Shutdown &&
ora.scan1.vip
& & & 1 & & & &ONLINE &ONLINE & & & jason2 & & &&
（5）、启动实例 & & & & & & & & & & & & & &
:~& srvctl start &database -d ORACLE
:~& crsctl status res -t
——————————————————————————–
NAME & & & & & TARGET &STATE & & & &SERVER & & & & & & & & & STATE_DETAILS & & &&
——————————————————————————–
Local Resources
——————————————————————————–
ora.DATA.dg
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.FRA.dg
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.LISTENER.lsnr
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.OCR.dg
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & Started & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & Started & & & & & &&
& & & & & & & &OFFLINE OFFLINE & & &jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &OFFLINE OFFLINE & & &jason2 & & & & & & & & & & & & & & & & & & &&
ora.net1.network
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.registry.acfs
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
——————————————————————————–
Cluster Resources
——————————————————————————–
ora.LISTENER_SCAN1.lsnr
& & & 1 & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & 1 & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
ora.jason1.vip
& & & 1 & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
ora.jason2.vip
& & & 1 & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & 1 & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
ora.oracle.db
& & & 1 & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & Open & & & & & & & &
& & & 2 & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & Open & & & & & & & &
ora.scan1.vip
& & & 1 & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
（6）、效验归档模式
:~& sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Fri Jan 8 19:40:57 2016
Copyright (c) , Oracle. &All rights reserved.
SQL& conn /as sysdba
Connected.
Database log mode & & & & & & &Archive Mode
Automatic archival & & & & & & Enabled
Archive destination & & & & & &USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence & & 8
Next log sequence to archive & 9
Current log sequence & & & & & 9
2、关闭归档
（1）、关闭所有实例
:~& srvctl stop database -d ORACLE
:~& crsctl status res -t
——————————————————————————–
NAME & & & & & TARGET &STATE & & & &SERVER & & & & & & & & & STATE_DETAILS & & &&
——————————————————————————–
Local Resources
——————————————————————————–
ora.DATA.dg
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.FRA.dg
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.LISTENER.lsnr
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.OCR.dg
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & Started & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & Started & & & & & &&
& & & & & & & &OFFLINE OFFLINE & & &jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &OFFLINE OFFLINE & & &jason2 & & & & & & & & & & & & & & & & & & &&
ora.net1.network
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.registry.acfs
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
——————————————————————————–
Cluster Resources
——————————————————————————–
ora.LISTENER_SCAN1.lsnr
& & & 1 & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & 1 & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
ora.jason1.vip
& & & 1 & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
ora.jason2.vip
& & & 1 & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & 1 & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
ora.oracle.db
& & & 1 & & & &OFFLINE OFFLINE & & & & & & & & & & & & & & & Instance Shutdown &&
& & & 2 & & & &OFFLINE OFFLINE & & & & & & & & & & & & & & & Instance Shutdown &&
ora.scan1.vip
& & & 1 & & & &ONLINE &ONLINE & & & jason2 & & & &
（2）、启动到mount状态 & & & & & & & & & & & & & & &&
:~& &srvctl start database -d ORACLE -o mount
:~& crsctl status res -t
——————————————————————————–
NAME & & & & & TARGET &STATE & & & &SERVER & & & & & & & & & STATE_DETAILS & & &&
——————————————————————————–
Local Resources
——————————————————————————–
ora.DATA.dg
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.FRA.dg
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.LISTENER.lsnr
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.OCR.dg
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & Started & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & Started & & & & & &&
& & & & & & & &OFFLINE OFFLINE & & &jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &OFFLINE OFFLINE & & &jason2 & & & & & & & & & & & & & & & & & & &&
ora.net1.network
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.registry.acfs
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
——————————————————————————–
Cluster Resources
——————————————————————————–
ora.LISTENER_SCAN1.lsnr
& & & 1 & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & 1 & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
ora.jason1.vip
& & & 1 & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
ora.jason2.vip
& & & 1 & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & 1 & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
ora.oracle.db
& & & 1 & & & &ONLINE &INTERMEDIATE jason1 & & & & & & & & & Mounted (Closed) & &
& & & 2 & & & &ONLINE &INTERMEDIATE jason2 & & & & & & & & & Mounted (Closed) & &
ora.scan1.vip
& & & 1 & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
（3）、设置为非归档模式
切换到oracle用户
:~& sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Fri Jan 8 19:24:08 2016
Copyright (c) , Oracle. &All rights reserved.
SQL& conn /as sysdba
Connected.
Database log mode & & & & & & &Archive Mode
Automatic archival & & & & & & Enabled
Archive destination & & & & & &USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence & & 6
Next log sequence to archive & 7
Current log sequence & & & & & 7
SQL& alter d
Database altered.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
（4）、关闭所有实例
切换到grid用户查看状态
:~& srvctl stop database -d ORACLE
:~& crsctl status res -t
——————————————————————————–
NAME & & & & & TARGET &STATE & & & &SERVER & & & & & & & & & STATE_DETAILS & & &&
——————————————————————————–
Local Resources
——————————————————————————–
ora.DATA.dg
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.FRA.dg
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.LISTENER.lsnr
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.OCR.dg
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & Started & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & Started & & & & & &&
& & & & & & & &OFFLINE OFFLINE & & &jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &OFFLINE OFFLINE & & &jason2 & & & & & & & & & & & & & & & & & & &&
ora.net1.network
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.registry.acfs
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
——————————————————————————–
Cluster Resources
——————————————————————————–
ora.LISTENER_SCAN1.lsnr
& & & 1 & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & 1 & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
ora.jason1.vip
& & & 1 & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
ora.jason2.vip
& & & 1 & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & 1 & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
ora.oracle.db
& & & 1 & & & &OFFLINE OFFLINE & & & & & & & & & & & & & & & Instance Shutdown &&
& & & 2 & & & &OFFLINE OFFLINE & & & & & & & & & & & & & & & Instance Shutdown &&
ora.scan1.vip
& & & 1 & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
（5）、再次打开实例
:~& srvctl start database -d ORACLE
:~& crsctl status res -t
——————————————————————————–
NAME & & & & & TARGET &STATE & & & &SERVER & & & & & & & & & STATE_DETAILS & & &&
——————————————————————————–
Local Resources
——————————————————————————–
ora.DATA.dg
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.FRA.dg
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.LISTENER.lsnr
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.OCR.dg
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & Started & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & Started & & & & & &&
& & & & & & & &OFFLINE OFFLINE & & &jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &OFFLINE OFFLINE & & &jason2 & & & & & & & & & & & & & & & & & & &&
ora.net1.network
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
ora.registry.acfs
& & & & & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
& & & & & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
——————————————————————————–
Cluster Resources
——————————————————————————–
ora.LISTENER_SCAN1.lsnr
& & & 1 & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & 1 & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
ora.jason1.vip
& & & 1 & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
ora.jason2.vip
& & & 1 & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
& & & 1 & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & & & & & & & & & & &&
ora.oracle.db
& & & 1 & & & &ONLINE &ONLINE & & & jason1 & & & & & & & & & Open & & & & & & & &
& & & 2 & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & Open & & & & & & & &
ora.scan1.vip
& & & 1 & & & &ONLINE &ONLINE & & & jason2 & & & & & & & & & & & & & & & & & & &&
（6）、效验归档模式
:~& sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Fri Jan 8 19:29:47 2016
Copyright (c) , Oracle. &All rights reserved.
SQL& conn /as sysdba
Connected.
Database log mode & & & & & & &No Archive Mode
Automatic archival & & & & & & Disabled
Archive destination & & & & & &USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence & & 8
Current log sequence & & & & & 9
备注：本实验中，归档地址使用默认地址，如需要更换可以通过修改对应日志参数实现。
本文出自 “” 博客，请务必保留此出处
收集自互联网，仅供学习交流使用！