URGENT : Recovery of production DB
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: URGENT : Recovery of production DB

  1. #1
    Join Date
    Jul 2000
    Posts
    37
    Hi,

    I've got a problem with an index datafile. It was zipped accidently, during a db backup, so I've unzipped it. Now, the file in question is still in backup mode, when I check v$backup. I don't want to bounce the database, but need to get the datafile out of backup mode. When I do alter tablespace ... end backup, it says that I'm not accessing the current version. What should I do??

    thanks in advance

    chris.

  2. #2
    Join Date
    Feb 2001
    Posts
    163
    Chris,

    If this is an index only tablespace can you just drop and recreate those indexes in a new tablespace?

    dba

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