13518219792
windows系统：打开cmd窗口
创新互联主要从事网站设计制作、成都网站制作、网页设计、企业做网站、公司建网站等业务。立足成都服务涡阳,10年网站建设经验,价格优惠、服务专业,欢迎来电咨询建站服务:028-86922220
Linux/Unix系统：打开终端
rman target / nocatalog;
sqlplus /nolog
conn / as sysdba;
2、开启归档
sqlplusshutdown immediate;（启动归档前先要停止数据库）
sqlplusstartup mount;（数据库以mount方式启动）
sqlplusalter database archivelog;（启动数据库归档）
修改成归档模式步骤：
关闭数据库
SQL shutdown immediate
启动数据库到mount
SQLstartup mount;
修改成归档模式
SQL alter database archivelog;
打开数据库
SQL alter database open;
修改成非归档模式：
步骤基本如上，只是将第三步中的命令改成如下：
SQL alter database noarchivelog;
注意事项：oracle数据库归档模式的的修改需要关闭数据库，所以在生产系统中修改时，需要考虑数据库启停时间。
如果开启归档，请保证log_archive_start=true开启自动归档，否则只能手工归档，如果是关闭了归档，则设置该参数为false 注意：如果是OPS/RAC环境，需要先把parallel_server = true注释掉，然后执行如下步骤，最后用这个参数重新启动 1、开启归档 a. 关闭数据库shutdown immediate b. startup mount c. alter database archivelog d. alter database opne 2、禁止归档 a. 关闭数据库shutdown immediate b. startup mount c. alter database noarchivelog d. alter database open 归档信息可以通过如下语句查看 SQL archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination E:\oracle\ora92\database\archive Oldest online log sequence 131 Next log sequence to archive 133 Current log sequence 133
1.管理员身份连接数据库
C:\Users\Administratorsqlplus sys/sys@prjdb as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 17 23:50:55 2014Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options
2.查看当前归档模式，是归档还是非归档
SQL archive log list;Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 228Current log sequence 230
3.关闭数据库
SQL shutdown immediate;Database closed.Database dismounted.
ORACLE instance shut down.
4.启动数据库到mount状态
SQL startup mount;
ORACLE instance started.
Total System Global Area 3423965184 bytes
Fixed Size 2180544 bytes
Variable Size 2013268544 bytesDatabase Buffers 1392508928 bytes
Redo Buffers 16007168 bytesDatabase mounted.
5.启动归档模式
SQL alter database archivelog;Database altered.
SQL archive log list;Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 228Next log sequence to archive 230Current log sequence 230
6.启动数据库
SQL alter database open;Database altered.
7.关闭归档模式
SQL shutdown immediate;Database closed.Database dismounted.
ORACLE instance shut down.
SQL startup mount;
ORACLE instance started.
Total System Global Area 3423965184 bytes
Fixed Size 2180544 bytes
Variable Size 2013268544 bytesDatabase Buffers 1392508928 bytes
Redo Buffers 16007168 bytesDatabase mounted.
SQL alter database noarchivelog;Database altered.
SQL archive log list;Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 228Current log sequence 230SQL
