oracle 开启关闭归档日志
开启归档,保证log_archive_start=true开启自动归档,否则只能手工归档,关闭了归档,则设置该参数为false注意:如果是OPS/RAC环境,需要先把parallel_server = true注释掉,然后执行如下步骤,最后用这个参数重新启动
1、开启归档
a. 关闭数据库shutdown immediate
b. startup mount
c.>
d.> 2、禁止归档
a. 关闭数据库shutdown immediate
b. startup mount
c.>
d.> 归档信息可以通过如下语句查看
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]