DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: help!!

  1. #1
    Join Date
    Nov 2000
    Posts
    157
    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

  2. #2
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342

    Unhappy

    You have to recreate you controlfile with changed maxdatafiles parameter.

    Gert


  3. #3
    Join Date
    Sep 2000
    Posts
    128
    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
  •  


Click Here to Expand Forum to Full Width