-
Hi Carp
In my init.ora the db_files=20
In my controlFile Maxdatafiles 20
In my database we already had 19 datafiles.
Now i want to add 3 more datafiles.
Databse : oracle 7.3.4
OS : Windows NT
Could you please let me know what should i do in detail
Thanks
Ravi
_______
-
You have to recreate you controlfile with changed maxdatafiles parameter.
Gert
-
Follow these steps to recreate your control file:
As SYS;
SVRMGR> alter database backup controlfile to trace;
Shutdown the database (immediate or normal - not abort)
*** Take a Full Cold Backup ***
Goto your user dump dest and find the control file produced by the above command (will be a .trc file - sort by date/time to find).
You will need to move/rename your existing control files at this point - also make sure you have sufficient space to create new ones as they will be bigger than the old.
Modify this trace file (call it control.sql or something as well) -
Delete any header information prior to the words Startup nomount.
Increase your maxdatafiles parameter and save the file.
Run:
svrmgrl
connect internal
@/patch/control.sql
**Shut down the database and take a full offline backup**
Hope this helps
Terry.
-------------------
Refer to below for more info:
http://support.oracle.com.sg/metalin...T&p_id=30598.1
http://support.oracle.com.sg/metalin...p_id=1012929.6