Oracle reconstruction Control File Syntax

When the control file is lost in Oracle, sometimes we can only recreate the control file. The specific syntax is as follows:

Create controlfile reuse database "SQUAN" NORESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
# MAXLOGHISTORY 292
LOGFILE
GROUP 1'/opt/oracle/oradata/squan/redo01.log' SIZE 50 M,
GROUP 3 '/opt/oracle/oradata/squan/redo03.log' SIZE 50 M
-- STANDBY LOGFILE
DATAFILE
'/Opt/oracle/oradata/squan/system01.dbf ',
'/Opt/oracle/oradata/squan/undotbs01.dbf ',
'/Opt/oracle/oradata/squan/sysaux01.dbf ',
'/Opt/oracle/oradata/squan/users01.dbf ',
'/Opt/oracle/oradata/squan/test01.dbf ',
'/Opt/oracle/oradata/squan/test02.dbf'
Character set ZHS16GBK;

Note: The preceding statement does not contain the temp tablespace. After the database is restored, the temporary tablespace needs to be rebuilt.

Alter tablespace temp add tempfile '/opt/oracle/oradata/squan/temp01.dbf' size 30 m reuse;
Create temporary tablespace temp tempfile '/opt/oracle/oradata/squan/temp01.dbf' size 30 m

Backup, recovery, and multiplexing of Oracle Control Files

Oracle 10g Control File Corruption recovery

Oracle 10 Gb control file backup to file and manual recovery

Oracle 11g ORA-03113 failure, rebuilding Control Files

RMAN backup and recovery control file loss