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

Thread: control file

  1. #1
    Join Date
    Feb 2001
    Posts
    23
    pls...tell me how to create control file
    i already import the data....now i'm stuck on creating control file..........don't know how to get .DAT ext....

  2. #2
    Join Date
    Dec 2000
    Posts
    46
    I am not sure I understand your question properly.
    There are many ways to create a control file :

    If your database is up and running then you can execute the following command
    from server manager or from sqlplus with a dba role :

    SQL> alter database backup controlfile to trace;

    the above command would create a text file in your user dump dest directory.
    you can modify that file and use it to recreate your controlfile. otherwise you have
    to create a script file like the following (your file names and parameters may vary):


    STARTUP NOMOUNT
    CREATE CONTROLFILE REUSE DATABASE "DEV1" NORESETLOGS ARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 2
    MAXDATAFILES 1024
    MAXINSTANCES 1
    MAXLOGHISTORY 226
    LOGFILE
    GROUP 1 (
    '/oradata/ANP1/vg01_01/log01a.dbf',
    '/oradata/ANP1/vg01_01/log01b.dbf'
    ) SIZE 10M,
    GROUP 2 (
    '/oradata/ANP1/vg01_01/log02a.dbf',
    '/oradata/ANP1/vg01_01/log02b.dbf'
    ) SIZE 10M
    DATAFILE
    '/oradata/ANP1/vg01_01/system01.dbf',
    '/oradata/ANP1/vg01_01/rbs01.dbf',
    '/oradata/ANP1/vg01_01/temp01.dbf',
    '/oradata/ANP1/vg01_01/akx01.dbf',
    '/oradata/ANP1/vg01_01/akd01.dbf',
    '/oradata/ANP1/vg01_01/alrx01.dbf',
    '/oradata/ANP1/vg01_01/ctxd01.dbf'
    ;
    # Recovery is required if any of the datafiles are restored backups,
    # or if the last shutdown was not normal or immediate.
    RECOVER DATABASE
    # All logs need archiving and a log switch is needed.
    ALTER SYSTEM ARCHIVE LOG ALL;
    # Database can now be opened normally.
    ALTER DATABASE OPEN;


    once you have done this. start server manager (svrmgrl) and execute the
    script.

    Hope this helps

  3. #3
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356

    Smile

    Hi!
    You have imported your data into the database. Which means the database is up and running. Which further means your control file fit and fine and you don't need to create another control file. What you can do is to backup your current control file using the command
    ALTER DATABSE backup control file to TRACE;
    Which creates a text file for creating a control file
    OR you can use
    ALTER DATABASE backup control fiel to <FILENAME>;
    Which just duplicates your current control file to the name you specify.
    Regards

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