CREATE DATABASE PROD5
        USER SYS IDENTIFIED BY
        USER SYSTEM IDENTIFIED BY
        LOGFILE GROUP 1 ('/u01/app/oracle/oradata/PROD5/redo01a.log','/u01/app/oracle/oradata/PROD5/redo01b.log') SIZE 100M BLOCKSIZE 512,
                GROUP 2 ('/u01/app/oracle/oradata/PROD5/redo02a.log','/u01/app/oracle/oradata/PROD5/redo02b.log') SIZE 100M BLOCKSIZE 512,
                GROUP 3 ('/u01/app/oracle/oradata/PROD5/redo03a.log','/u01/app/oracle/oradata/PROD5/redo03b.log') SIZE 100M BLOCKSIZE 512,
        MAXLOGHISTORY 1
        MAXLOGFILES 16
        MAXLOGMEMBERS 3
        MAXDATAFILES 1024
        CHARACTER SET AL32UTF8
        NATIONAL CHARACTER SET AL16UTF16
        EXTENT MANAGEMENT LOCAL
        DATAFILE 'u01/app/oracle/oradata/PROD5/system01.dbf'
                SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
        SYSAUX DATAFILE '/u01/app/oracle/oradata/PROD5/sysaux01.dbf'
                SIZE 550M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
        DEFAULT TABLESPACE users
                DATAFILE '/u01/app/oracle/oradata/PROD5/users01.dbf'
                SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
        DEFAULT TEMPORARY TABLESPACE tempts1
                TEMPFILE '/u01/app/oracle/oradata/PROD5/temp01.dbf'
                SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
        UNDO TABLESPACE undotbs1
                DATAFILE '/u01/app/oracle/oradata/PROD5/undotbs01.dbf'
                SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
        USER_DATA TABLESPACE usertbs
                DATAFILE '/u01/app/oracle/oradata/PROD5/usertbs01.dbf'
                SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
2025-01-07T09:32:50.472125+08:00
Expanded controlfile section 32 from 31 to 128 records
Requested to grow by 97 records; added 3 blocks of records
.... (PID:12784): Redo network throttle feature is disabled at mount time
2025-01-07T09:32:50.486377+08:00
Database mounted in Exclusive Mode
Lost write protection disabled
.... (PID:12784): Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST [krsd.c:18157]
2025-01-07T09:32:55.679304+08:00
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/PROD5/onlinelog/o1_mf_1_mqs127dx_.log
2025-01-07T09:32:55.686622+08:00
Errors in file /u01/app/oracle/diag/rdbms/prod5/PROD5/trace/PROD5_ora_12784.trc:
ORA-01501: CREATE DATABASE failed
ORA-01505: error in adding log files
ORA-01184: logfile group 1 already exists
Error 1505 happened during database creation, shutting down database
Errors in file /u01/app/oracle/diag/rdbms/prod5/PROD5/trace/PROD5_ora_12784.trc  (incident=1481):
ORA-00603: ORACLE server session terminated by fatal error
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-01501: CREATE DATABASE failed
ORA-01505: error in adding log files
ORA-01184: logfile group 1 already exists
Incident details in: /u01/app/oracle/diag/rdbms/prod5/PROD5/incident/incdir_1481/PROD5_ora_12784_i1481.trc
2025-01-07T09:32:56.878525+08:00
opiodr aborting process unknown ospid (12784) as a result of ORA-603
2025-01-07T09:32:57.226485+08:00
ORA-603 : opitsk aborting process
License high water mark = 1
USER (ospid: (prelim)): terminating the instance due to ORA error
2025-01-07T09:32:58.260211+08:00
Instance terminated by USER(prelim), pid = 12784
复制