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

Thread: controlfiles

  1. #1
    Join Date
    Jun 2000
    Location
    Maputo, Maputo-Mozambique
    Posts
    96
    I'm recreating control files and i use the command
    'alter databse backup controlfile to trace '
    the question is, there is no size of the datafile. what will happen if i recreate them without the size of the datafiles;?

    Note that all files are there and not damaged.

    Regards
    Alexandre
    In god i trust

  2. #2
    Join Date
    Sep 2000
    Posts
    14
    CREATE CONTROLFILE REUSE DATABASE "SID" NORESETLOGS ARCHIVELOG

    it will reuse your datafile.

    Originally posted by alexandre
    I'm recreating control files and i use the command
    'alter databse backup controlfile to trace '
    the question is, there is no size of the datafile. what will happen if i recreate them without the size of the datafiles;?

    Note that all files are there and not damaged.

    Regards
    Alexandre

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    You never mention size for controlfile. Thats system generated file(Oracle internal specfic) which has the information of all the files associated with the database.
    Reddy,Sam

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