-
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'
-
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?
This is not very nice stuff what we are doing.
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.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
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;
-
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'
That's OK, because you obviously have given a wrong name of the file.
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
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
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;
That's OK, then lets:
DROP tablespace RBS including contents and datafiles;
Is the name RBS?
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
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..
-
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.
It should be 9:30 in South Africa :-) Try to take all RBSs online, if not possible open an iTar with Oracle Metalink.
Let me know if you are able to online all RBSs. Try to drop the ones that you cannot take online.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Originally posted by charlton
How do I check the name?
I must be a pain in the @ss, hey!
Sorry..
Select tablespace_name from dba_tablespaces;
Take some other DBA with you. Don't do that stuff alone! I wouldn't :-)
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|