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

Thread: Question

  1. #1
    Join Date
    Jul 2001
    Posts
    15

    Question

    Folks,

    Database is archive log mode.
    One datafile from tools tablespace deleted while installing a s/w.
    Now the database needs to be set in non archivelog mode.

    When trying to set it nonarchivelog mode get error related to the datafile that it needs receovery apply all the archive logs. The archive logs unavailable as the instance is a test instance.

    If I backup the controlfile and modify the controlfile to noarchivelog mode, set the datafile as offline and create the control files will the database be set in nonarchivelog mode.

    Please help.
    Thanks.

  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    How did you delete datafile?
    Best wishes!
    Dmitri

  3. #3
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    Originally posted by kgb
    How did you delete datafile?
    When Oracle encounter a write error to a datafile, does it take the datafile offline?
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

  4. #4
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    I think you can 'offline drop' the datafile after taking the tablespace offline. Then you can shut down , take a backup and restart the database normally, set it to noarchivelog or whatever mode you want.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    say bye bye to your tools tablespace

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