One, 11g RAC rebuild control file
1.---"Create Controlfile" command is generated into the trace file:
ALTER DATABASE backup Controlfile to trace;
2.--Confirm the path of the trace file:
Sql> Select value from V$diag_info where Name= ' Default Trace File ';
3.---The Intercept script finds and executes the noresetlogs version of the "Create Controlfile" command in the trace file to End of tempfile additions.
As follows:
--Set #1. Noresetlogs case
--
--The following commands would create a new control file and use it
-To open the database.
--Data used by Recovery Manager would be lost.
--Additional logs May is required for media recovery of offline
--Use the If the current versions of all online logs is
--Available.
--After mounting the created Controlfile, the following SQL
--statement'll place, the database in the appropriate
--Protection mode:
--ALTER database SET STANDBY database to maximize performance
STARTUP Nomount
CREATE controlfile Reuse DATABASE "Yndss" Noresetlogs Noarchivelog
Maxlogfiles 192
Maxlogmembers 3
Maxdatafiles 2560
Maxinstances 32
Maxloghistory 292
LOGFILE
GROUP 1 (
' +data01/yndss/onlinelog/group_1.257.954170283 ',
' +fra/yndss/onlinelog/group_1.257.954170289 '
) SIZE 4096M BLOCKSIZE 512,
GROUP 2 (
' +data01/yndss/onlinelog/group_2.258.954170295 ',
' +fra/yndss/onlinelog/group_2.258.954170301 '
) SIZE 4096M BLOCKSIZE 512,
GROUP 3 (
' +data01/yndss/onlinelog/group_3.259.954170307 ',
' +fra/yndss/onlinelog/group_3.259.954170313 '
) SIZE 4096M BLOCKSIZE 512,
GROUP 4 (
' +data01/yndss/onlinelog/group_4.260.954170317 ',
' +fra/yndss/onlinelog/group_4.260.954170323 '
) SIZE 4096M BLOCKSIZE 512,
GROUP 5 (
' +data01/yndss/onlinelog/group_5.267.954172379 ',
' +fra/yndss/onlinelog/group_5.261.954172383 '
) SIZE 4096M BLOCKSIZE 512,
GROUP 6 (
' +data01/yndss/onlinelog/group_6.268.954172389 ',
' +fra/yndss/onlinelog/group_6.262.954172395 '
) SIZE 4096M BLOCKSIZE 512,
GROUP 7 (
' +data01/yndss/onlinelog/group_7.269.954172399 ',
' +fra/yndss/onlinelog/group_7.263.954172405 '
) SIZE 4096M BLOCKSIZE 512,
GROUP 8 (
' +data01/yndss/onlinelog/group_8.270.954172411 ',
' +fra/yndss/onlinelog/group_8.264.954172417 '
) SIZE 4096M BLOCKSIZE 512
--STANDBY LOGFILE
DataFile
' +data01/yndss/datafile/system.261.954170329 ',
' +data01/yndss/datafile/sysaux.262.954170337 ',
' +data01/yndss/datafile/undotbs1.263.954170349 ',
' +data01/yndss/datafile/undotbs2.265.954170389 ',
' +data01/yndss/datafile/users.266.954170413 ',
' +data01/yndss/datafile/etl001.dbf ',
' +data01/yndss/datafile/src001.dbf ',
' +data01/yndss/datafile/cdr001.dbf ',
' +data01/yndss/datafile/day001.dbf ',
' +data01/yndss/datafile/mon001.dbf ',
' +data01/yndss/datafile/detail001.dbf ',
' +data01/yndss/datafile/code001.dbf ',
' +data01/yndss/datafile/dss001.dbf ',
' +data01/yndss/datafile/dm001.dbf ',
' +data01/yndss/datafile/rpt001.dbf ',
' +data01/yndss/datafile/undotbs1.292.954498057 ',
' +data01/yndss/datafile/undotbs2.293.954498139 ',
' +data01/yndss/datafile/day002 ',
' +data01/yndss/datafile/day004 ',
' +data01/yndss/datafile/day005 ',
' +data01/yndss/datafile/day006 ',
' +data01/yndss/datafile/day007 ',
' +data01/yndss/datafile/day008 ',
' +data01/yndss/datafile/day009 ',
' +data01/yndss/datafile/day010 ',
' +data01/yndss/datafile/day011 ',
' +data01/yndss/datafile/day012 ',
' +data01/yndss/datafile/day013 ',
' +data01/yndss/datafile/day014 ',
' +data01/yndss/datafile/day015 ',
' +data01/yndss/datafile/day016 ',
' +data01/yndss/datafile/day017 ',
' +data01/yndss/datafile/day018 ',
' +data01/yndss/datafile/day019 ',
' +data01/yndss/datafile/day020 ',
' +data01/yndss/datafile/day021 ',
' +data01/yndss/datafile/day022 ',
' +data01/yndss/datafile/day023 '
CHARACTER SET ZHS16GBK
;
--Commands to re-create incarnation table
--Below log names must is changed to existing filenames on
--disk. Any one log file from each branch can is used to
--Re-create incarnation records.
-ALTER DATABASE REGISTER LOGFILE ' +fra ';
--Recovery is required if any of the datafiles is restored backups,
--or if the last shutdown is not normal or immediate.
RECOVER DATABASE
--Database can now is opened normally.
ALTER DATABASE OPEN;
--Commands to add tempfiles to temporary tablespaces.
--Online Tempfiles has complete space information.
--Other tempfiles may require adjustment.
ALTER tablespace TEMP ADD tempfile ' +data01/yndss/tempfile/temp.264.954170377 '
SIZE 20480M Reuse autoextend on NEXT 655360 MAXSIZE 131071M;
ALTER tablespace TEMP01 ADD tempfile ' +data01/yndss/tempfile/temp01.272.954431201 '
SIZE 30720M reuse Autoextend OFF;
ALTER tablespace TEMP01 ADD tempfile ' +data01/yndss/tempfile/temp01.273.954431229 '
SIZE 30720M reuse Autoextend OFF;
ALTER tablespace TEMP01 ADD tempfile ' +data01/yndss/tempfile/temp01.274.954431245 '
SIZE 30720M reuse Autoextend OFF;
ALTER tablespace TEMP01 ADD tempfile ' +data01/yndss/tempfile/temp01.275.954431255 '
SIZE 30720M reuse Autoextend OFF;
ALTER tablespace TEMP01 ADD tempfile ' +data01/yndss/tempfile/temp01.276.954431265 '
SIZE 30720M reuse Autoextend OFF;
ALTER tablespace TEMP02 ADD tempfile ' +data01/yndss/tempfile/temp02.277.954431307 '
SIZE 30720M reuse Autoextend OFF;
ALTER tablespace TEMP02 ADD tempfile ' +data01/yndss/tempfile/temp02.278.954431321 '
SIZE 30720M reuse Autoextend OFF;
ALTER tablespace TEMP02 ADD tempfile ' +data01/yndss/tempfile/temp02.279.954431347 '
SIZE 30720M reuse Autoextend OFF;
ALTER tablespace TEMP02 ADD tempfile ' +data01/yndss/tempfile/temp02.280.954431371 '
SIZE 30720M reuse Autoextend OFF;
ALTER tablespace TEMP02 ADD tempfile ' +data01/yndss/tempfile/temp02.281.954431381 '
SIZE 30720M reuse Autoextend OFF;
--End of tempfile additions.
Description: Reuse can reuse temporary files that already exist in the database itself
4 、--Formal reconstruction (can be CP backup control file before rebuilding)
Alter system set CLUSTER_DATABASE=FALSE scope=spfile sid= ' * ';
@ Script
Alter system set Cluster_database=true scope=spfile sid= ' * ';
Note: If the environment is a cluster, you need to adjust the cluster_database parameter.
——————————————————————————————
Second, 12c reconstruction control file
STARTUP Nomount
CREATE controlfile Reuse DATABASE "ORCL" Noresetlogs Noarchivelog
Maxlogfiles 16
Maxlogmembers 3
Maxdatafiles 1024
Maxinstances 8
Maxloghistory 292
LOGFILE
GROUP 1 '/home/oracle/app/oradata/orcl/redo01.log ' SIZE 50M BLOCKSIZE 512,
GROUP 2 '/home/oracle/app/oradata/orcl/redo02.log ' SIZE 50M BLOCKSIZE 512,
GROUP 3 '/home/oracle/app/oradata/orcl/redo03.log ' SIZE 50M BLOCKSIZE 512
DataFile
'/home/oracle/app/oradata/orcl/system01.dbf ',
'/home/oracle/app/oradata/orcl/sysaux01.dbf ',
'/home/oracle/app/oradata/orcl/undotbs01.dbf ',
'/home/oracle/app/oradata/orcl/pdbseed/system01.dbf ',
'/home/oracle/app/oradata/orcl/users01.dbf ',
'/home/oracle/app/oradata/orcl/pdbseed/sysaux01.dbf ',
'/home/oracle/app/oradata/orcl/pdb/system01.dbf ',
'/home/oracle/app/oradata/orcl/pdb/sysaux01.dbf ',
'/HOME/ORACLE/APP/ORADATA/ORCL/PDB/PDB_USERS01.DBF '
CHARACTER SET ZHS16GBK
;
RECOVER DATABASE
ALTER DATABASE OPEN;
ALTER pluggable DATABASE all OPEN;
ALTER tablespace TEMP ADD tempfile '/home/oracle/app/oradata/orcl/temp01.dbf '
SIZE 92274688 Reuse autoextend on NEXT 655360 MAXSIZE 32767M;
ALTER SESSION SET CONTAINER = pdb$seed;
ALTER tablespace TEMP ADD tempfile '/home/oracle/app/oradata/orcl/pdbseed/pdbseed_temp01.dbf '
SIZE 91226112 Reuse autoextend on NEXT 655360 MAXSIZE 32767M;
ALTER SESSION SET CONTAINER = PDB;
ALTER tablespace TEMP ADD tempfile '/home/oracle/app/oradata/orcl/pdb/temp01.dbf '
SIZE 20971520 Reuse autoextend on NEXT 655360 MAXSIZE 32767M;
ALTER SESSION SET CONTAINER = cdb$root;
——————————————————————————————
Add:
If necessary, use the strings command to locate the data file and the online log path
Oracle's use of Controlfile trace files to reconstruct control files