« Oracle 11g: RMAN UNDO表空间备份优化 | Blog首页 | 《循序渐进Oracle》今日付印 »
10gRAC系列之五-如何启用归档模式
链接:https://www.eygle.com/archives/2007/07/oracle10g_rac_archivelog.html
Oracle RAC的参数文件和单实例参数文件不同,所以修改参数文件时需要注意。
首先设置归档路径:
SQL> alter system set log_archive_dest='/opt/oracle/archive' scope=spfile sid='*';
System altered.
SQL> col sid for a10
SQL> col name for a20
SQL> col value for a30
SQL> select sid,name,value from v$spparameter where name='log_archive_dest';SID NAME VALUE
---------- -------------------- ------------------------------
* log_archive_dest /opt/oracle/archive
然后关闭两个实例,启动实例,更改数据库为归档模式:
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.Total System Global Area 1258291200 bytes
Fixed Size 1978336 bytes
Variable Size 352325664 bytes
Database Buffers 889192448 bytes
Redo Buffers 14794752 bytes
Database mounted.
SQL> alter database archivelog;Database altered.
SQL> alter database open;
Database altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /opt/oracle/archive
Oldest online log sequence 83
Next log sequence to archive 84
Current log sequence 84
接下来启动另外一个节点,完成归档模式的变更过程。
在RAC环境下,归档路径的选择是值得斟酌的,如果使用共享的归档目录作为归档路径,则可以减少备份时的复杂性。如果使用独立的目录,则备份时需要进行特殊处理。
-The End-
历史上的今天...
>> 2019-07-23文章:
>> 2015-07-23文章:
>> 2014-07-23文章:
>> 2012-07-23文章:
>> 2009-07-23文章:
>> 2008-07-23文章:
>> 2005-07-23文章:
By eygle on 2007-07-23 16:45 | Comments (2) | Advanced | 1512 |
log_archive_dest 不让修改啊!!
谢谢