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

Thread: Help with re-create DB scripts

  1. #1
    Join Date
    Sep 2001
    Posts
    112
    When DBA's maintain scripts to re-create there database.

    What exactly do they mean and what's the procedure.

    Is it dropping the tablespaces, deleting the files and recreating them all or......

    Thx

  2. #2
    Join Date
    Oct 2000
    Posts
    467
    it means to include all the controlfiles, datafiles, redologs whenever you recreate them.
    For this issue 'alter system backup controlfile to trace ' on your existing database.
    Vinit

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hello All

    DBA's maintian to scripts to recreate the database mens things like

    a)Rebuilding the Database on to a different machine which is identical to the one on the production.
    b)It could also mean that your script should rebuild the database on production server (say for example you want to change the db_block_size)

    the database scripts to rebuild the database includes scripts to create to Physical (like control file ,datfiles,rollbacksegments etc) and logical structures of the database like tables indexes users etc....but without the actual data...

    regards
    Hrishy

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hello All

    DBA's maintian to scripts to recreate the database mens things like

    a)Rebuilding the Database on to a different machine which is identical to the one on the production.
    b)It could also mean that your script should rebuild the database on production server (say for example you want to change the db_block_size)

    the database scripts to rebuild the database includes scripts to create to Physical (like control file ,datfiles,rollbacksegments etc) and logical structures of the database like tables indexes users constraints etc....but without the actual data...(in most cases the data is loaded separately)

    regards
    Hrishy

  5. #5
    Join Date
    Sep 2001
    Posts
    112
    Thanks very much

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