I get the following error:
SVRMGR> ALTER DATABASE DATAFILE 'rbs01.dbf' offline;
ALTER DATABASE DATAFILE 'rbs01.dbf' offline
*
ORA-01516: nonexistent log file, datafile or tempfile 'rbs01.dbf'
I get the following error:
SVRMGR> ALTER DATABASE DATAFILE 'rbs01.dbf' offline;
ALTER DATABASE DATAFILE 'rbs01.dbf' offline
*
ORA-01516: nonexistent log file, datafile or tempfile 'rbs01.dbf'
This is not very nice stuff what we are doing.Quote:
Originally posted by charlton
Julian, I am a bit scared so just confirm if this is correct:
ALTER DATABASE DATAFILE 'rbsxx.dbf' ONLINE;
Which I will do for all 7 rbs datafiles?
alter tablespace RBS offline;
DROP ROLLBACK SEGMENT rbs01.dbf
Is this correct?
If there is an active transaction in a rollback segment and that rollback segment is removed from the database without the transaction being able to undo the changes made to the database (e.g. rollback), then those changes will be assumed to be committed. This can lead to inconsistencies in application data and/or the data dictionary. There is no help that can be provided to determine what those changes were. While inconsistencies in application data may have an effect on a customers application (e.g. loss of data, loss of access to data), inconsistencies in the data dicationary can cause the database to hang and/or crash at some later point in time and require a restore at that time.
In the case of a lost rollback segment datafile, there is no way Oracle can guarantee that a data dictionary transaction was not active in the rollback segment as there is no way to view that information.
The proper way in this situation would be to open an iTar with Metalink.
If I was next to you, may be together we could fix it but that is difficult.
Try to take the RBSs offline first:
alter ROLLBACK SEGMENT rbs01 offline;
alter ROLLBACK SEGMENT rbs02 offline;
..
alter ROLLBACK SEGMENT rbs07 offline;
If this succeeds, then we are almost OK.
Do you have a MSN or AOL loggin? Would you be able to use it if you do?
SVRMGR> alter ROLLBACK SEGMENT rbs01 offline;
alter ROLLBACK SEGMENT rbs01 offline
*
ORA-01598: rollback segment 'RBS01' is not online
SVRMGR> alter ROLLBACK SEGMENT rbs02 OFFLINE;
That's OK, because you obviously have given a wrong name of the file.Quote:
Originally posted by charlton
I get the following error:
SVRMGR> ALTER DATABASE DATAFILE 'rbs01.dbf' offline;
ALTER DATABASE DATAFILE 'rbs01.dbf' offline
*
ORA-01516: nonexistent log file, datafile or tempfile 'rbs01.dbf'
It cannot be only rbs01.dbf. There is some directory before this.
I have to go to watch an Woody Allen moovie soon, so call me if you want. I will send you my phone number if you write me an email to ocp_9i@yahoo.com
That's OK, then lets:Quote:
Originally posted by charlton
SVRMGR> alter ROLLBACK SEGMENT rbs01 offline;
alter ROLLBACK SEGMENT rbs01 offline
*
ORA-01598: rollback segment 'RBS01' is not online
SVRMGR> alter ROLLBACK SEGMENT rbs02 OFFLINE;
DROP tablespace RBS including contents and datafiles;
Is the name RBS?
Sorry, Julian....
I am in South Africa and I can't call internationally.
It's 8:30 PM in the evening. Do you think I should just do a restore then? I really don't want to cause I know it takes 9 hours to do a restore.
How do I check the name?
I must be a pain in the @ss, hey!
Sorry..
It should be 9:30 in South Africa :-) Try to take all RBSs online, if not possible open an iTar with Oracle Metalink.Quote:
Originally posted by charlton
Sorry, Julian....
I am in South Africa and I can't call internationally.
It's 8:30 PM in the evening. Do you think I should just do a restore then? I really don't want to cause I know it takes 9 hours to do a restore.
Let me know if you are able to online all RBSs. Try to drop the ones that you cannot take online.
Select tablespace_name from dba_tablespaces;Quote:
Originally posted by charlton
How do I check the name?
I must be a pain in the @ss, hey!
Sorry..
Take some other DBA with you. Don't do that stuff alone! I wouldn't :-)