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

Thread: request help

  1. #1
    Join Date
    Jan 2003
    Posts
    6

    request help

    I have a problem with control files. I moved some dbf files and now I must config the new path in control files.
    How can I do this?
    Somebody told me that change the path in control files, but this files isn't a text file.
    I have Oracle 8.1.6 on HP/UX 11

    Thanks a lot for your help

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    tahiti.oracle.com

    search for ALTER DATABASE RENAME FILE

    Next time, RTFM first.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Sep 2001
    Location
    Mexico
    Posts
    93

    recreate the control file

    You can recreate the control file and modify the path of the datafiles.

    Shutdown your database and after that, startup nomount the db, recreate the control files adding the new datafile locations. AFTER this step is SUCCESS you CAN OPEN your database.

    The steps are below:

    1. SHUTDOWN

    $sqlplus /nolog

    SQL> CONNECT INTERNAL

    SQL> SHUTDOWN IMMEDIATE

    2. STARTUP NOMOUNT

    $sqlplus /nolog

    SQL> CONNECT INTERNAL

    SQL> STARTUP NOMOUNT

    3. RECREATE CONTROL FILE. In this step you can create a "test" control file modifying your parameter file FIRST so you can keep the old control files. In this step you can also change the database name, etc. Please verify the current settings of your db in order to configure the MAX clauses, CHARACTER SET, etc.

    VERY IMPORTANT: REMEMBER TO INCLUDE ALL THE DATAFILES AND THEIR PATHS.

    SQL> CREATE CONTROL FILE REUSE SET DATABASE "yourdatabasename" RESETLOGS NOARCHIVELOG
    MAXLOGFILES 5
    MAXLOGMEMBERS 3
    MAXINSTANCES 2
    MAXLOGHISTORY 113
    LOGFILE
    ...
    DATAFILE
    '/newroure1/datafile1.dbf',
    '/newroute2/datafile2.dbf',
    ...
    CHARACTER SET ...
    ;

    4) ALTER DATABASE OPEN RESETLOGS

    SQL> ALTER DATABASE OPEN RESETLOGS;

    This will open your database.

    5) Include your temp files.

    ALTER TABLESPACE TEMP ADD TEMPFILE /tempfileroute/temp01.dbf'
    SIZE .. REUSE ... AUTOEXTEND ON NEXT .. MAXSIZE ...;

    That's all good look.
    Last edited by Turin; 04-10-2003 at 12:36 PM.

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