解决ORA-00349 错误的一般步骤: 检查归档日志位置: 确认LOG_ARCHIVE_DEST 参数设置的路径与实际存储归档日志的路径一致。 sql SHOW PARAMETER LOG_ARCHIVE_DEST; 验证归档日志文件是否存在: 检查归档日志文件是否存在于配置的路径中。如果文件丢失,可能需要从备份中恢复或重新生成。 检查文件权限: 确保Oracle 数据库...
SQL>ALTERDATABASEACTIVATESTANDBYDATABASE;ALTERDATABASEACTIVATESTANDBYDATABASE*ERRORat line1:ORA-00349:failure obtaining block sizefor'+JIEKE_DATA'ORA-15001:diskgroup"JIEKE_DATA"does not exist or is not mountedORA-15001:diskgroup"JIEKE_DATA"does not exist or is not mountedSQL>alter database recover ...
ORA-00349: failure obtaining block size for '+fra_grp01_d select group#,name,bytes,status from v$logfile; SQL> / 1 /paic/hq/bk/restore/data/oradata/aims/group_1.257.788444161 1 /paic/hq/bk/restore/data/oradata/aims/group_1.257.788444163 2 /paic/hq/bk/restore/data/oradata/aims/grou...
ERROR at line 1: ORA-00392: log 5 of thread 1 is being cleared, operation not allowed ORA-00312: online log 5 thread 1: '+test_dg' 21:18:58 SQL> alter database clear logfile group 4; alter database clear logfile group 4 * ERROR at line 1: ORA-00349: failure obtaining block siz...
ORA-00349: failure obtaining block size for '+reco_dm0 对所有文件数据头进行验证 SQL> select CHECKPOINT_CHANGE#,count(*) from V$DATAFILE_HEADER group by CHECKPOINT_CHANGE#; CHECKPOINT_CHANGE# COUNT(*) --- --- 15098820263819 76 可以看出所有文件SCN一致 重建控制文件...
Oracle Database - Enterprise Edition - Version 10.1.0.3 and later: 'ORA-00349: failure obtaining block size' On 'open resetlogs' During Incomplete Recovery
RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script RMAN-06136: ORACLE error from auxiliary database: ORA-00349: failure obtaining block size for '+AXIUMDATA' ORA-15001: diskgroup "AXIUMDATA" does not exist or is not mounted ...
RMAN-06136: ORACLE error from auxiliary database: ORA-01503: CREATE CONTROLFILE failedORA-00349: failure obtaining block size for '+DISK1'ORA-29701: unable to connect to Cluster Synchronization ServiceORA-29701: unable to connect to Cluster Synchronization ServiceORA-29701: unable to connect to ...
然后调整此参数比如 *.log_file_name_convert='+EBSPROD/PROD/ONLINELOG/','/u01/nuat/db/data/' 调整后,删除之前的恢复的数据,在重新进行恢复数据 参考文档:RMAN Duplicate failing with RMAN-06136, ORA-01503, ORA-00349 (Doc ID 2206423.1)