**** ATTENTION: ****
The controlfile header block returned by the OS has a sequence number that is too old.
The controlfile might be corrupted.
PLEASE DO NOT ATTEMPT TO START UP THE INSTANCE without following the steps below.
RE-STARTING THE INSTANCE CAN CAUSE SERIOUS DAMAGE TO THE DATABASE, if the controlfile is truly corrupted.
In order to re-start the instance safely,
Please do the following:
(1) Save all copies of the controlfile for later analysis and contact your OS vendor and Oracle support.
(2) Mount the instance and issue:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE'
(3) Unmount the instance.
(4) Use the script in the trace file to RE-CREATE THE CONTROLFILE and open the database.
**** -- ****
SQL> create pfile='/oracle/app/oracle/product/19.12.0/dbs/initRECO.ora' from spfile;
SQL> shut immediate;
SQL> startup mount pfile='/oracle/app/oracle/product/19.12.0/dbs/initRECO.ora'
SQL> alter database backup controlfile to trace;
SQL>
create controlfile reuse database "DBDB" noresetlogs archivelog
maxlogfiles 192
maxlogmembers 3
maxdatafiles 1024
maxInstances 32
maxLoghistory 292
LOGFILE
GROUP 1 (
'+DATA/DBDB/ONLINELOG/group_1.290.102934',
'+DATA/DBDB/ONLINELOG/group_1.257.'656753'
) SIZE 2000M BLOCKSIZE 512,
GROUP 2 (
'+DATA/DBDB/ONLINELOG/group_2.291.1029453',
'+DATA/DBDB/ONLINELOG/group_2.258.'656723'
) SIZE 2000M BLOCKSIZE 512
-- standby logfile
DATAFILE
'+DATA/DBDB/DATAFILE/system.298.24891235',
'+DATA/DBDB/DATAFILE/sysaux.298.24891235',
'+DATA/DBDB/DATAFILE/undotbs1.298.24891235',
'+DATA/DBDB/DATAFILE/undotbs2.298.24891235',
'+DATA/DBDB/DATAFILE/users.298.24891235',
CHARACTER SET AL32UTF8
;
SQL> shut immediate
SQL> startup nomount pfile='/oracle/app/oracle/product/19.12.0/dbs/initRECO.ora';
-- create database 문 실행
SQL>
create controlfile reuse database "DBDB" noresetlogs archivelog
maxlogfiles 192
maxlogmembers 3
maxdatafiles 1024
maxInstances 32
maxLoghistory 292
LOGFILE
GROUP 1 (
'+DATA/DBDB/ONLINELOG/group_1.290.102934',
'+DATA/DBDB/ONLINELOG/group_1.257.'656753'
) SIZE 2000M BLOCKSIZE 512,
GROUP 2 (
'+DATA/DBDB/ONLINELOG/group_2.291.1029453',
'+DATA/DBDB/ONLINELOG/group_2.258.'656723'
) SIZE 2000M BLOCKSIZE 512
-- standby logfile
DATAFILE
'+DATA/DBDB/DATAFILE/system.298.24891235',
'+DATA/DBDB/DATAFILE/sysaux.298.24891235',
'+DATA/DBDB/DATAFILE/undotbs1.298.24891235',
'+DATA/DBDB/DATAFILE/undotbs2.298.24891235',
'+DATA/DBDB/DATAFILE/users.298.24891235',
CHARACTER SET AL32UTF8
;
SQL> recover database;
SQL> alter database open;
SQL> alter tablespace temp add tempfile '+DATA/DBDB/TEMPFILE/temp.291.12930124' REUSE;
끝.