在重建控制文件时

SQL> CREATE CONTROLFILE REUSE DATABASE \"HOST\" NORESETLOGS FORCE LOGGING ARCHIVELOG
2 MAXLOGFILES 192
3 MAXLOGMEMBERS 3
4 MAXDATAFILES 1024
5 MAXINSTANCES 32
6 MAXLOGHISTORY 292
7 LOGFILE
8 GROUP 1 \'+DATA/dbjx/onlinelog/group_1.373.871427395\' SIZE 50M BLOCKSIZE 512,
9 GROUP 2 \'+DATA/dbjx/onlinelog/group_2.265.864426495\' SIZE 50M BLOCKSIZE 512,
10 GROUP 3 \'+DATA/dbjx/onlinelog/group_3.264.864426511\' SIZE 50M BLOCKSIZE 512,
11 GROUP 4 \'+DATA/dbjx/onlinelog/group_4.276.864426525\' SIZE 50M BLOCKSIZE 512
12 DATAFILE
13 \'+DATA/dbjx/datafile/system.281.864425653\',
14 \'+DATA/dbjx/datafile/sysaux.282.864425855\',
15 \'+DATA/dbjx/datafile/undotbs1.256.864426041\',
16 \'+DATA/dbjx/datafile/users.258.864426167\',
17 \'+DATA/dbjx/datafile/ischedule.259.864426229\'
18 CHARACTER SET AL32UTF8
19 ;

收到如下错误

解决方法

SQL> CREATE CONTROLFILE SET DATABASE \"HOST\" RESETLOGS FORCE LOGGING ARCHIVELOG

ITPub博客

创建控制文件 ORA-01192 解决方法