There are many parameters that need to be adjusted for a period of time, and some parameters can be adjusted in the $ Oracle_Home / DBS / INITXX.ORA file, and some parameters must be adjusted in Oracle's control files. For example, the number of default data files in Oracle is 30, and the number of data files need to be expanded in the system is not enough.
One way is to fill all the data out, rebuild the library, and then put the data into and out. This method is more troublesome.
The two methods are only rebuild the control file because the limit parameters of the data file are stored in the control file.
The following is a good method for rebuilding control files:
1. Back up the data in the database to prevent it.
2. SVRMGRL
3. SVRMGRL> Connect Internal
4. SVRMGRL> ALTER DATABASE BACKUP ControlFile to TRACE; Backup Control File
5. Under / Home / Oracle // Admin / Ora7 / Udump, you can find the latest TRACE file, assuming ORA_15269.TRC, this file contains the parameters of the current control file and generating syntax.
6. Extract ORA_15269.TRC to save the statement generated by the control file as creatl.sql.
7. Creatl.sql's content is:
Startup Nomount
Create ControlFile Reuse Database "Ora7" NoreSetLogs NoarchiveLog
MaxLogfiles 32
MaxLogmembers 2
MaxDataFiles 50
MaxInstances 8
MaxLoghistory 800
Logfile
Group 1 '/ dev / vg00 / RoraredOa1' size 500K,
Group 2 '/ dev / vg00 / RoraredOa2' size 500K,
Group 3 '/ dev / vg00 / RoraredOa3' Size 500K
DataFile
'/ dev / vg00 / rasys',
'/ dev / vg00 / RORARBS',
'/ dev / vg00 / roomemp',
'/ dev / vg00 / raoatools',
'/ dev / vg00 / Rorauser'
;
8. You can edit the parameters in Creatl.sql in your own needs, such as MaxDataFiles, MaxInstances, etc.
9. SVRMGRL
10. SVRMGRL> Connect Internal
11. SVRMGRL> Shutdown Immediate
12. SVRMGRL> @ creatl.sql
13. SVRMGRL> ALTER DATABASE OPEN;
At this time the database is running in a new parameter.
