Standby数据库常见错误处理

Standby数据库常见错误处理1、执行：alterdatabaserecovermanagedstandbydatabasedisconnectfromsession;后台alert文件报错如下：Errorsinfile/u01/oracle/admin/primary/bdump/primary_mrp0_2967.trc:ORA-19527:physicalstandbyredologmustberenamedORA-00312:onlinelog1thread1:'/u01/oracle/oradata/primary/redo01.log'出现这个错误是因为oracle为了降低不小心清空主库联机日志的风险而引起的。oracle不知道你的主备库分别是分别在一台机器上还是不同的机器上，如果是在相同的机器上，则有可能不小心把主库的联机清空了。女口果是先在主库switchlogfile后，再alterdatabaserecovermanagedstandbydatabasedisconnectfromsession;还会有如下扌艮错：Errorsinfile/u01/oracle/admin/primary/bdump/primary_mrp0_2967.trc:ORA-00313:openfailedformembersofloggroup1ofthread1ORA-00312:onlinelog1thread1:'/u01/oracle/oradata/primary/redo01.log'ORA-27037:unabletoobtainfilestatusLinuxError:2:NosuchfileordirectoryAdditionalinformation:3这个错误会在10g出现，9i是不会出现的。因为做switchover的时候需要清空联机日志，在10g中，oracle为了加快swichover的速度，在恢复过程中清空备库的联机日志。在最初创建备库时并没有redologs，要指定参数log_file_name_convert后，重新alterdatabaserecovermanagedstandbydatabasedisconnectfromsession;后就进程会自动创建redo文件。以上两个问题可以看作是一个问题，解决方法是在备库设置log_file_name_convert即可，如：log_file_name_convert='/u01/primary/','/u01/primary/'注意：即使是在目录结构完全一样的主备库中这个错误也会出现。2、执行：alterdatabaserecovermanagedstandbydatabasecancel;后台alert文件有如下错误：Errorsinfile/u01/oracle/admin/primary/bdump/primary_mrp0_2967.trc:ORA-16037:userrequestedcancelofmanagedrecoveryoperationRecoveryinterrupted!这个错误是正常的，不用在意。3、Errorsinfile/opt/u01/app/oracle/admin/ora8/bdump/ora8_arc1_27096・trc:ORA-16401:archivelogrejectedbyRFSORA-16401:archivelogrejectedbyRFSCause:Anattemptwasmadetore-archiveanexistingarchivelog・Thisusuallyhappensbecauseeitheramultipleprimarydatabaseorstandbydatabase(s)orbotharetryingtoarchivetothisstandbydatabase・Action:Seealertlogandtracefileformoredetails・Noactionisnecessary;thisisaninformationalstatementprovidedtorecordtheeventfordiagnosticpurposes・属于正常信息，通过观察备机的日志发现，redo还是被应用了。如：ThuOct1615:18:442008RedoShippingClientConnectedasPUBLIC--ConnectedUserisValidRFS[6]:AssignedtoRFSprocess14001RFS[6]:Identifieddatabasetypeas'physicalstandby'RFS[6]:Archivelogthread1sequenee7616cannotbereusedThuOct1615:18:442008Errorsinfile/u01/app/oracle/admin/ora8/udump/ora8_rfs_14001.trc:ORA-16401:archivelogrejectedbyRFSThuOct1615:19:142008MediaRecoveryLog/opt/archive/1_7616_652298303.arcMediaRecoveryWaitingforthread1sequenee7617(intransit)4、Errorsinfile/u01/oracle/admin/primary/udump/primary_rfs_3380・trc:ORA-00313:openfailedformembersofloggroup4ofthread1ORA-00312:onlinelog4thread1:'/u01/oracle/oradata/primary/standbyredo04.log'ORA-27037:unabletoobtainfilestatusLinuxError:2:NosuchfileordirectoryAdditionalinformation:3SunJun2415:36:052007Errorsinfile/u01/oracle/admin/primary/udump/primary_rfs_3380.trc:ORA-00313:openfailedformembersofloggroup4ofthread1ORA-00312:onlinelog4thread1:'/u01/oracle/oradata/primary/standbyredo04.log'ORA-27037:unabletoobtainfilestatusLinuxError:2:NosuchfileordirectoryAdditionalinformation:3SunJun2415:36:052007Errorsinfile/u01/oracle/admin/primary/udump/primary_rfs_3380.trc:ORA-00313:openfailedformembersofloggroup7ofthread1ORA-00312:onlinelog7thread1:'/u01/oracle/oradata/primary/standbyredo7.log'ORA-27037:unabletoobtainfilestatusLinuxError:2:NosuchfileordirectoryAdditionalinformation:3SunJun2415:36:052007Errorsinfile/u01/oracle/admin/primary/udump/primary_rfs_3380.trc:ORA-00313:openfailedformembersofloggroup7ofthread1ORA-00312:onlinelog7thread1:'/u01/oracle/oradata/primary/standbyredo7.log'ORA-27037:unabletoobtainfilestatusLinuxError:2:NosuchfileordirectoryAdditionalinformation:3RFS[1]:Unabletoopenstandbylog7:313RFS[1]:NostandbyredologfilescreatedRFS[1]:ArchivedLog:'/u01/archivelog/1_12_626106231.dbf'SunJun2415:36:072007RedoShippingClientConnectedasPUBLIC出现这个错误主要是因为在备份前主库创建了standbyredolog,备库是根据主库的信息创建的，一开始它是包含了主库的standbyredolog信息，如果主库设置的日志传送方式是LGWR,当主库发生日志切换时，备库的RFS会尝试使用standbyredolog来存储主库传送过来的日志，因为此时备库实际上是不存在standbyredolog的，所以备库会报错。当备库尝试打开字典信息的所有standbyredolog失败以后，备库会自动把日志传送方式转为ARCN，并同时清除数据字典中的standbyredolog信息。下面是清除standbyredolog信息前的数据字典信息：SQL>select*fromv$logfile;GROUP#STATUSTYPEMEMBERISONLINE/u01/oracle/oradata/primary/redo01.logNOONLINE/u01/oracle/oradata/primary/redo02.logNOONLINE/u01/oracle/oradata/primary/redo03.logNOSTANDBY/u01/oracle/oradata/primary/standbyredo04.logNOSTANDBY/u01/oracle/oradata/primary/standbyredo5.logNOSTANDBY/u01/oracle/oradata/primary/standbyredo6.logNOSTANDBY/u01/oracle/oradata/primary/standbyredo7.logNO7rowsselected.F面的信息是在备库尝试打开standbyredolog后的数据字典信息:SQL>select*fro