SQL> @E:\yoonus.sql
ORACLE instance started.
Total System Global Area 1358954496 bytes
Fixed Size 2077456 bytes
Variable Size 687869168 bytes
Database Buffers 654311424 bytes
Redo Buffers 14696448 bytes
CREATE CONTROLFILE REUSE DATABASE "GEP" NORESETLOGS ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01166: file number 255 is larger than MAXDATAFILES (254)
ORA-01110: data file 255: 'X:\GEPDB1010\SR3.DATA226'
Solution:
Edit the control file and increase the number of MAXDATAFILE VALUES
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "GEP" NORESETLOGS ARCHIVELOG
MAXLOGFILES 255
MAXLOGMEMBERS 3
MAXDATAFILES 254 increase to more than your data files count
MAXINSTANCES 50
MAXLOGHISTORY 1168
LOGFILE
GROUP 1 (
'E:\ORACLE\GEP\ORIGLOGA\LOG_G11M1.DBF',
'E:\ORACLE\GEP\MIRRLOGA\LOG_G11M2.DBF'
) SIZE 50M,
GROUP 2 (
'E:\ORACLE\GEP\ORIGLOGB\LOG_G12M1.DBF',
'E:\ORACLE\GEP\MIRRLOGB\LOG_G12M2.DBF'
Thanks
Yoonus
ORACLE instance started.
Total System Global Area 1358954496 bytes
Fixed Size 2077456 bytes
Variable Size 687869168 bytes
Database Buffers 654311424 bytes
Redo Buffers 14696448 bytes
CREATE CONTROLFILE REUSE DATABASE "GEP" NORESETLOGS ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01166: file number 255 is larger than MAXDATAFILES (254)
ORA-01110: data file 255: 'X:\GEPDB1010\SR3.DATA226'
Solution:
Edit the control file and increase the number of MAXDATAFILE VALUES
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "GEP" NORESETLOGS ARCHIVELOG
MAXLOGFILES 255
MAXLOGMEMBERS 3
MAXDATAFILES 254 increase to more than your data files count
MAXINSTANCES 50
MAXLOGHISTORY 1168
LOGFILE
GROUP 1 (
'E:\ORACLE\GEP\ORIGLOGA\LOG_G11M1.DBF',
'E:\ORACLE\GEP\MIRRLOGA\LOG_G11M2.DBF'
) SIZE 50M,
GROUP 2 (
'E:\ORACLE\GEP\ORIGLOGB\LOG_G12M1.DBF',
'E:\ORACLE\GEP\MIRRLOGB\LOG_G12M2.DBF'
Thanks
Yoonus
No comments:
Post a Comment
Ask Your Questions ?#