-
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
_______
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:
[url]http://support.oracle.com.sg/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=30598.1[/url]
[url]http://support.oracle.com.sg/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=1012929.6[/url]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|