recover non-systems datafile with rollback segments
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: recover non-systems datafile with rollback segments

  1. #1
    Join Date
    Jan 2002
    Posts
    474
    if we have the case where we lost the rollback segment datafiles for examplyas follow:

    1. the database crashed or shutdown abort
    2. del rbs1orcl.ora
    3. copy backup\rbs1orcl.ora
    4. in init.ora ---> comment out the ROLLBACK_SEGMENTS
    5. startup mount
    6. alter database datafile 'c:\oradata\rbs1orcl.ora' offline;
    7. alter database open.


    two questions:
    1. even I comment out the ROLLBACK_SEGMENTS out so I thought Oracle won't find the existing rollback segments but I think it's still use the existing rollback_segments
    2. on number 7, when I tried to open the database, even I took the missing datafile offline, but it still looks for that file and the database couldn't open.

    please advise


  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Are you modiying the correct init.ora file?
    Can you post the error messages?

    Sanjay

  3. #3
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Have you removed your rollback segments in the init.ora file? If not do it and try again.

    If it doesn't work, try the next:

    You have dropped the datafile, and put offline the datafile, but your rollback segments for the database are online. Put in the init.ora the parameter _offline_rollback_segments=(your rollback segments). Drop the rollback segments, and after reboot your database without this parameter.

    Cheers

    Angel

  4. #4
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    I wonder wether the instance recovery process need the rollback sgement to success.
    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

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