1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

'Alter tablespace indx begin backup' - failed

Discussion in 'Security, Backup and Recovery' started by cbgreen, Sep 11, 2009.

  1. cbgreen

    cbgreen Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    55
    'Alter tablespace indx begin backup' - failed Oracle Status=1128

    I am getting this error in Backup Exec 10d.

    This error has been happen for the last couple of days since I increased the tablespace of index in my database.

    From what i have been reading the problem is with the 'indx' tablespace not recognizing the new index datafiles that have been created.

    What do i have to do to correct this problem?
     
  2. tyro

    tyro Forum Genius

    Messages:
    368
    Likes Received:
    20
    Trophy Points:
    260
    Location:
    India
    Well are you using RMAN? I could only find this information...

     
  3. cbgreen

    cbgreen Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    55
    I dont believe it is using RMAN, the database was actually configured and setup in 2000/2001. it was configured to have a tablespace for the index and a seperate tablespace for the data.

    Right now backup exec is doing the database back up. can i switch to RMAN? and is there a good location to find out how to do that?
     
  4. tyro

    tyro Forum Genius

    Messages:
    368
    Likes Received:
    20
    Trophy Points:
    260
    Location:
    India
    Hmmm... you did not try to read the info i gave. Is any of your datafile of this tablespace offline?

    Does an offline backup of the directory run successfully..?

    About RMAN, sure you can switch to RMAN, just read some intro documentation.
     
  5. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Which release of Oracle is this? How did you 'increase the tablespace of index'? Did you use alter tablespace? Or did you use alter database and simply add datafiles without associating them to a tablespace? What does metalink report on this issue?
     
  6. cbgreen

    cbgreen Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    55
    the oracle version is 9i.

    What happened was i added a new datafile the indx tablespace by accident. and ever since i did that i haven't been able to get a backup.

    it keeps saying the datafile is online but needs recovery. i would like to just remove the datafile altogether because i will never use it. So if i remove the datafile is causing the issue will i solve the problem? or will that cause me even more of a problem since oracle is telling me the file needs recovery?
     
  7. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    So you issue a

    recover datafile '<file name here>';

    command while connected as SYS then issue an

    alter database datafile '<file name here>' online;

    and it should stop displaying errors. Then you can issue an

    alter database datafile '<file name here>' offline drop;

    and get rid of it from within the database. You should then be able to go to the operating system and remove the file.
     
  8. cbgreen

    cbgreen Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    55
    I am going to try that do i need to stop the database first or can that happen while the database is till running
     
  9. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    If you stop the database you can't run the commands provided. It needs to be running.
     
  10. cbgreen

    cbgreen Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    55
    that solved the problem thank you