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

Thread: BACKUP/RECOVERY

  1. #1
    Join Date
    Aug 2001
    Location
    cuddapah
    Posts
    145

    Unhappy

    !HI

    Iam using Oracle 9i Database on winNT platform?

    I accidently delete one datafile by using OS command when database is in shutdown .

    Database IS in NO archivemode

    and i have no backup (NOTHING)?

    now i want recovery what i have do ?

    I don't want that datafile it is not important for me?

    Can i get the database back?


  2. #2
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    ALTER DATABASE DATAFILE ... OFFLINE DROP

    or

    DROP TABLESPACE ...
    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

  3. #3
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi;
    is your datafile in the Windows-Trashcan?

    Orca

  4. #4
    Join Date
    Jun 2002
    Posts
    5
    first u drop ur datafile by using this command

    ALTER DATABASE DTATAFILE .........................OFFLINE DROP

    after that

    start database in nomount stage
    create datafile
    and then
    alter databse open
    ALTER DATABASE DATAFILE .............................ONLINE
    or
    ALTER TABLESPACE ONLINE.




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