希望对不会的人能有所帮助。这里想把charge数据库从非归档模式转换成归档模式
方法:
1.使用本地身份验证登录数据库,
查看登录的数据库:
发现登录的默认数据库是ORAL
[img]http://dl.iteye.com/upload/attachment/198578/ce87d205-29e5-39d3-b7a9-e0d9510fc67d.jpg[/img]
2.切换数据库为charge,设置环境变量
再次登录数据库
[img]http://dl.iteye.com/upload/attachment/198580/b606ea3b-82d1-3b1d-bb2b-e90a0a700b02.jpg[/img]
3.查看是否为归档模式
关闭数据库
启动数据库到mount状态
[img]http://dl.iteye.com/upload/attachment/198582/1d38ba1d-f987-34b5-a335-09d838fdcc7d.jpg[/img]
4.修改数据库归档模式
启动数据库
定义归档位置
确认配置生效:
[img]http://dl.iteye.com/upload/attachment/198584/69ebd481-6f5a-3f01-ac86-b7baf52a8321.jpg[/img]
5.登录OEM也可以进行验证,如下图:
[img]http://dl.iteye.com/upload/attachment/198609/907f3867-2eb4-38a1-9f61-2085587622ca.jpg[/img]
方法:
1.使用本地身份验证登录数据库,
sqlplus / as sysdba
查看登录的数据库:
select name from V$DATABASE;
发现登录的默认数据库是ORAL
[img]http://dl.iteye.com/upload/attachment/198578/ce87d205-29e5-39d3-b7a9-e0d9510fc67d.jpg[/img]
2.切换数据库为charge,设置环境变量
set ORACLE_SID=CHARGE
再次登录数据库
[img]http://dl.iteye.com/upload/attachment/198580/b606ea3b-82d1-3b1d-bb2b-e90a0a700b02.jpg[/img]
3.查看是否为归档模式
archive log list;
关闭数据库
shutdown immediate
启动数据库到mount状态
startup mount;
[img]http://dl.iteye.com/upload/attachment/198582/1d38ba1d-f987-34b5-a335-09d838fdcc7d.jpg[/img]
4.修改数据库归档模式
alter database archivelog;
启动数据库
alter database open;
定义归档位置
alter system set log_archive_dest_1="location=D:\database\example" scope=both;
确认配置生效:
archive log list;
[img]http://dl.iteye.com/upload/attachment/198584/69ebd481-6f5a-3f01-ac86-b7baf52a8321.jpg[/img]
5.登录OEM也可以进行验证,如下图:
[img]http://dl.iteye.com/upload/attachment/198609/907f3867-2eb4-38a1-9f61-2085587622ca.jpg[/img]