Oracle创建控制文件时报错ORA-15173
👉 本文共约222个字，系统预计阅读时间或需1分钟。
现象
创建控制文件时报错：
1 2 3 4 5 6 7 8 | RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of sql statement command at 02/27/2022 18:01:46 ORA-01503: CREATE CONTROLFILE failed ORA-01565: error in identifying file '+DATA/odsdw/onlinelog/group_1a.log' ORA-17503: ksfdopn:2 Failed to open file +DATA/odsdw/onlinelog/group_1a.log ORA-15173: entry 'group_1a.log' does not exist in directory 'onlinelog' |
解决
由于是新环境，肯定没有redo文件，所以，首先需要手动创建目录“+DATA/odsdw/onlinelog/”，然后创建控制文件时，需要使用RESETLOGS选项，而不能使用NORESETLOGS。
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信db_bao，谢谢！
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 | alter database backup controlfile to trace as '/tmp/control_rebuild.trc'; STARTUP FORCE NOMOUNT; CREATE CONTROLFILE REUSE DATABASE "LHR11G" RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE GROUP 1 '/u01/app/oracle/oradata/LHR11G/redo01.log' SIZE 50M BLOCKSIZE 512, GROUP 2 '/u01/app/oracle/oradata/LHR11G/redo02.log' SIZE 50M BLOCKSIZE 512, GROUP 3 '/u01/app/oracle/oradata/LHR11G/redo03.log' SIZE 50M BLOCKSIZE 512 DATAFILE '/u01/app/oracle/oradata/LHR11G/system01.dbf', '/u01/app/oracle/oradata/LHR11G/sysaux01.dbf', '/u01/app/oracle/oradata/LHR11G/undotbs01.dbf', '/u01/app/oracle/oradata/LHR11G/users01.dbf', '/u01/app/oracle/oradata/LHR11G/example01.dbf' CHARACTER SET AL32UTF8 ; catalog start with '/home/oracle/bk/'; recover database; ALTER DATABASE OPEN RESETLOGS; |
