Describe MaxDataFile覲蟆 here

SQL> --Control File MAXDATAFILES 
SQL> connect internal
郁屋給.
SQL> alter database backup controlfile to trace;

一危覯伎り 覲蟆暑給.

SQL> --udump create control 朱  殊 覦煙 蟆企. 企 蟆暑襯 谿場覲碁.
SQL> shutdown immediate;
一危磯伎り 給.
一危磯伎り 襷危 伎給.
ORACLE 語ろ伎り 譬襭給.
SQL> 

Trace 伎 -- Create Controlfile 覈轟 覲伎 蟆企. 
==========================================================================================
Dump file e:\Oracle\admin\ora816\udump\ORA03404.TRC
Thu Oct 30 03:32:50 2003
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.2 , CPU type 586
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Windows 2000 Version 5.2 , CPU type 586
Instance name: ora816

Redo thread mounted by this instance: 1

Oracle process number: 14

Windows thread id: 3404, image: ORACLE.EXE


*** SESSION ID:(11.55) 2003-10-30 03:32:50.082
*** 2003-10-30 03:32:50.082
# The following commands will create a new control file and use it
# to open the database.
# Data used by the recovery manager will be lost. Additional logs may
# be required for media recovery of offline data files. Use this
# only if the current version of all online logs are available.
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "ORA816" NORESETLOGS NOARCHIVELOG
    MAXLOGFILES 32
    MAXLOGMEMBERS 2
    MAXDATAFILES 32
    MAXINSTANCES 16
    MAXLOGHISTORY 1815
LOGFILE
  GROUP 1 'E:\ORACLE\ORADATA\ORA816\REDO03.LOG'  SIZE 1M,
  GROUP 2 'E:\ORACLE\ORADATA\ORA816\REDO02.LOG'  SIZE 1M,
  GROUP 3 'E:\ORACLE\ORADATA\ORA816\REDO01.LOG'  SIZE 1M
DATAFILE
  'E:\ORACLE\ORADATA\ORA816\SYSTEM01.DBF',
  'E:\ORACLE\ORADATA\ORA816\RBS01.DBF',
  'E:\ORACLE\ORADATA\ORA816\USERS01.DBF',
  'E:\ORACLE\ORADATA\ORA816\TEMP01.DBF',
  'E:\ORACLE\ORADATA\ORA816\TOOLS01.DBF',
  'E:\ORACLE\ORADATA\ORA816\INDX01.DBF',
  'E:\ORACLE\ORADATA\ORA816\DR01.DBF',
  'E:\ORACLE\ORADATA\ORA816\WS_DATA1.ORA',
  'E:\ORACLE\ORADATA\ORA816\WS_IDX1.ORA',
  'E:\ORACLE\ORADATA\ORA816\TMP1ORCL.ORA'
CHARACTER SET KO16KSC5601
;
# Recovery is required if any of the datafiles are restored backups,
# or if the last shutdown was not normal or immediate.
RECOVER DATABASE
# Database can now be opened normally.
ALTER DATABASE OPEN;
# No tempfile entries found to add.
#
==========================================================================================

MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 32
MAXINSTANCES 16
MAXLOGHISTORY 1815

蠍一 覲   襦蠏誤殊 螳 襦蠏 襷企 螳, 豕 一危 殊煙  蟆
覲伎碁.  螳 願覃 る狩伎 蠍磯讌  蟆企. れ  . 

1. MAXDATAFILES螳 企企 襦 れ. 
	MAXDATAFILES 100000000000
	
2. 蠍一ヾ 危朱 覦蠑朱. 
    蟆曙 危殊 豺 れ螻 螳. 
   control_files = ("e:\Oracle\oradata\ora816\control01.ctl",
                    "e:\Oracle\oradata\ora816\control02.ctl", 
                    "e:\Oracle\oradata\ora816\control03.ctl")
   
   control01.ctl.old, control01.ctl.old, control01.ctl.old襦 覦蠑語.    

SQL> startup mount ora816 exclusive;
ORACLE 語ろ伎り 給.

Total System Global Area  237008140 bytes
Fixed Size                    70924 bytes
Variable Size              79572992 bytes
Database Buffers          157286400 bytes
Redo Buffers                  77824 bytes
ORA-00205: ????? ????? ??, ?? ??? ? ?? ??? ?? ??? ??????


SQL>  --  trace 蟆 Create Controlfile... ろ. 
SQL> CREATE CONTROLFILE REUSE DATABASE "ORA816" NORESETLOGS NOARCHIVELOG
  2      MAXLOGFILES 32
  3      MAXLOGMEMBERS 2
  4      MAXDATAFILES 100000000000
  5      MAXINSTANCES 16
  6      MAXLOGHISTORY 1815
  7  LOGFILE
  8    GROUP 1 'E:\ORACLE\ORADATA\ORA816\REDO03.LOG'  SIZE 1M,
  9    GROUP 2 'E:\ORACLE\ORADATA\ORA816\REDO02.LOG'  SIZE 1M,
 10    GROUP 3 'E:\ORACLE\ORADATA\ORA816\REDO01.LOG'  SIZE 1M
 11  DATAFILE
 12    'E:\ORACLE\ORADATA\ORA816\SYSTEM01.DBF',
 13    'E:\ORACLE\ORADATA\ORA816\RBS01.DBF',
 14    'E:\ORACLE\ORADATA\ORA816\USERS01.DBF',
 15    'E:\ORACLE\ORADATA\ORA816\TEMP01.DBF',
 16    'E:\ORACLE\ORADATA\ORA816\TOOLS01.DBF',
 17    'E:\ORACLE\ORADATA\ORA816\INDX01.DBF',
 18    'E:\ORACLE\ORADATA\ORA816\DR01.DBF',
 19    'E:\ORACLE\ORADATA\ORA816\WS_DATA1.ORA',
 20    'E:\ORACLE\ORADATA\ORA816\WS_IDX1.ORA',
 21    'E:\ORACLE\ORADATA\ORA816\TMP1ORCL.ORA'
 22  CHARACTER SET KO16KSC5601
 23  ;

 殊 焔給.
SQL> --企 覲糾規  る alter database open resetlog 豌 
SQL> --resetlog旧 覿譴 . 
SQL> alter database open;

一危覯伎り 覲蟆暑給.

SQL> 

貉碁, 殊  蟆暑襦 螳覲企 3螳 貉碁, 殊 焔  蟆企.  朱 PC
 貉碁, 殊  ろ . 襷 れ 觜れ DB覯 蟆曙磯 企蟆
貉碁ゼ 殊  ろ 伎 螻る. 蟾蟆 伎 貉碁, 殊 讌譴.