ORA-00257: archiver error --11GR2 RAC 設定歸檔路徑和開啟flashback

ora-00257: archiver error --11gr2 rac 設定歸檔路徑和開啟flashback

 <wbr> 開啟歸檔和flashback，現在對于11g來說開啟rac和單執行個體沒有什麼差别，測試了這麼的一個例子，  

需求：把歸檔日志存放到asm上，orcl1的歸檔存放在+data/arc1下，orcl2的歸檔放到+data/arc2下。  

flashbask area是需要單獨的一個diskgroup，是以特地給他建立了個新的dg -- shflash  

一、under asm environment  

[grid@node1 ~]$ sqlplus / as sysasm  

sql*plus: release 11.2.0.1.0 production on tue apr 9 15:06:35 2013  

copyright (c) 1982, 2009, oracle.  all rights reserved.  

connected to:  

oracle database 11g enterprise edition release 11.2.0.1.0 - 64bit production  

with the real application clusters and automatic storage management options  

sql> create diskgroup shflash external redundancy disk '/dev/raw/raw2';----此處也可用asmca圖形化界面去建立  

sql> desc v$asm_diskgroup              

 name                                      null?    type  

 ----------------------------------------- -------- ----------------------------  

 group_number                                       number  

 name                                               varchar2(30)  

 sector_size                                        number  

 block_size                                         number  

 allocation_unit_size                               number  

 state                                              varchar2(11)  

 type                                               varchar2(6)  

 total_mb                                           number  

 free_mb                                            number  

 hot_used_mb                                        number  

 cold_used_mb                                       number  

 required_mirror_free_mb                            number  

 usable_file_mb                                     number  

 offline_disks                                      number  

 compatibility                                      varchar2(60)  

 database_compatibility                             varchar2(60)  

 voting_files                                       varchar2(1)  

sql> select  group_number,name from v$asm_diskgroup;  

group_number name  

------------ ------------------------------  

           1 data  

           2 shflash  

sql> alter diskgroup data add directory '+data/arc1';  

diskgroup altered.  

sql>  alter diskgroup data add directory '+data/arc2';  

sql> exit  

disconnected from oracle database 11g enterprise edition release 11.2.0.1.0 - 64bit production  

二、under oracle environment  

[grid@node1 ~]$ su - oracle  

password:  

[oracle@node1 ~]$ sqlplus / as sysdba  

sql*plus: release 11.2.0.1.0 production on tue apr 9 15:15:38 2013  

with the partitioning, real application clusters, automatic storage management, olap,  

data mining and real application testing options  

sql> alter system set log_archive_dest_1 ='location=+data/arc1' scope=spfile sid='orcl1';  

system altered.  

sql> alter system set log_archive_dest_1 ='location=+data/arc2' scope=spfile sid='orcl2';  

sql> show parameter db_recovery  

name                                 type        value  

------------------------------------ ----------- ------------------------------  

db_recovery_file_dest                string      +data  

db_recovery_file_dest_size           big integer 3882m  

sql> alter system set  db_recovery_file_dest_size=2g scope=both sid='*';  

sql> alter system set db_recovery_file_dest ='+shflash' scope=both sid='*';  

sql> show parameter db_flashback  

db_flashback_retention_target        integer     1440  

三、shutdown immediate instance in all nodes  

on node1:  

sql> show user  

user is "sys"  

sql> shutdown immediate  

database closed.  

database dismounted.  

oracle instance shut down.  

sql> !       

[oracle@node1 ~]$ srvctl status database -d orcl  

instance orcl1 is not running on node node1  

instance orcl2 is running on node node2  

on node2:  

[oracle@node1 ~]$ export oracle_sid=orcl1  

instance orcl2 is not running on node node2  

四、startup mount one instance and enable archivelog and flashback  

sql*plus: release 11.2.0.1.0 production on tue apr 9 15:52:06 2013  

connected to an idle instance.  

sql> startup mount  

oracle instance started.  

total system global area 1269366784 bytes  

fixed size                  2212976 bytes  

variable size             889195408 bytes  

database buffers          369098752 bytes  

redo buffers                8859648 bytes  

database mounted.  

sql> alter database archivelog;  

database altered.  

sql> alter database flashback on;  

sql> desc v$database  

 dbid                                               number  

 name                                               varchar2(9)  

 created                                            date  

 resetlogs_change#                                  number  

 resetlogs_time                                     date  

 prior_resetlogs_change#                            number  

 prior_resetlogs_time                               date  

 log_mode                                           varchar2(12)  

 checkpoint_change#                                 number  

 archive_change#                                    number  

 controlfile_type                                   varchar2(7)  

 controlfile_created                                date  

 controlfile_sequence#                              number  

 controlfile_change#                                number  

 controlfile_time                                   date  

 open_resetlogs                                     varchar2(11)  

 version_time                                       date  

 open_mode                                          varchar2(20)  

 protection_mode                                    varchar2(20)  

 protection_level                                   varchar2(20)  

 remote_archive                                     varchar2(8)  

 activation#                                        number  

 switchover#                                        number  

 database_role                                      varchar2(16)  

 archivelog_change#                                 number  

 archivelog_compression                             varchar2(8)  

 switchover_status                                  varchar2(20)  

 dataguard_broker                                   varchar2(8)  

 guard_status                                       varchar2(7)  

 supplemental_log_data_min                          varchar2(8)  

 supplemental_log_data_pk                           varchar2(3)  

 supplemental_log_data_ui                           varchar2(3)  

 force_logging                                      varchar2(3)  

 platform_id                                        number  

 platform_name                                      varchar2(101)  

 recovery_target_incarnation#                       number  

 last_open_incarnation#                             number  

 current_scn                                        number  

 flashback_on                                       varchar2(18)  

 supplemental_log_data_fk                           varchar2(3)  

 supplemental_log_data_all                          varchar2(3)  

 db_unique_name                                     varchar2(30)  

 standby_became_primary_scn                         number  

 fs_failover_status                                 varchar2(22)  

 fs_failover_current_target                         varchar2(30)  

 fs_failover_threshold                              number  

 fs_failover_observer_present                       varchar2(7)  

 fs_failover_observer_host                          varchar2(512)  

 controlfile_converted                              varchar2(3)  

 primary_db_unique_name                             varchar2(30)  

 supplemental_log_data_pl                           varchar2(3)  

 min_required_capture_change#                       number  

sql> select  log_mode , flashback_on  from v$database;  

log_mode     flashback_on  

------------ ------------------  

archivelog   yes  

sql> alter database open  

  2  ;  

五、startup node2  

[oracle@node2 ~]$ sqlplus / as sysdba  

sql> startup  

六、test and verify  

sql*plus: release 11.2.0.1.0 production on tue apr 9 15:55:23 2013  

sql> archive log list;  

database log mode              archive mode  

automatic archival             enabled  

archive destination            +data/arc1  

oldest online log sequence     15  

next log sequence to archive   16  

current log sequence           16  

sql> select status from gv$instance;  

status  

------------  

open  

sql> desc v$asm_diskgroup  

sql> select group_number ,name  from v$asm_diskgroup;  

sql> select name from v$datafile  

  2  union all  

  3  select name from v$controlfile  

  4  union all  

  5  select member from v$logfile;  

name  

--------------------------------------------------------------------------------  

+data/orcl/datafile/system.256.811903481  

+data/orcl/datafile/sysaux.257.811903483  

+data/orcl/datafile/undotbs1.258.811903483  

+data/orcl/datafile/users.259.811903483  

+data/orcl/datafile/undotbs2.267.811903583  

+data/orcl/controlfile/current.261.811903555  

+data/orcl/controlfile/current.260.811903555  

+data/orcl/onlinelog/group_2.264.811903559  

+data/orcl/onlinelog/group_2.265.811903559  

+data/orcl/onlinelog/group_1.262.811903559  

+data/orcl/onlinelog/group_1.263.811903559  

+data/orcl/onlinelog/group_3.268.811903615  

+data/orcl/onlinelog/group_3.269.811903617  

+data/orcl/onlinelog/group_4.270.811903617  

+data/orcl/onlinelog/group_4.271.811903617  

15 rows selected.  

archive destination            +data/arc2  

sql> desc v$archived_log  

 recid                                              number  

 stamp                                              number  

 name                                               varchar2(513)  

 dest_id                                            number  

 thread#                                            number  

 sequence#                                          number  

 resetlogs_id                                       number  

 first_change#                                      number  

 first_time                                         date  

 next_change#                                       number  

 next_time                                          date  

 blocks                                             number  

 creator                                            varchar2(7)  

 registrar                                          varchar2(7)  

 standby_dest                                       varchar2(3)  

 archived                                           varchar2(3)  

 applied                                            varchar2(9)  

 deleted                                            varchar2(3)  

 status                                             varchar2(1)  

 completion_time                                    date  

 dictionary_begin                                   varchar2(3)  

 dictionary_end                                     varchar2(3)  

 end_of_redo                                        varchar2(3)  

 backup_count                                       number  

 archival_thread#                                   number  

 is_recovery_dest_file                              varchar2(3)  

 compressed                                         varchar2(3)  

 fal                                                varchar2(3)  

 end_of_redo_type                                   varchar2(10)  

 backed_by_vss                                      varchar2(3)  

sql> alter system switch logfile;  

sql> select thread# sequence# , archived from v$archived_log;  

 sequence# arc  

---------- ---  

         2 yes  

         1 yes  

25 rows selected.  

27 rows selected.  

開啟歸檔和flashback，現在對于11g來說開啟rac和單執行個體沒有什麼差别，測試了這麼的一個例子，

需求：把歸檔日志存放到asm上，orcl1的歸檔存放在+data/arc1下，orcl2的歸檔放到+data/arc2下。

flashbask area是需要單獨的一個diskgroup，是以特地給他建立了個新的dg -- shflash