on 05-13-2010 4:42 PM
all,
I just installed a ECC system recently on oracle 10g. The system installed fine and i even created a client from 001 client. unfortunately, I had to reboot the system (solaris zone) and now my system tablespace file is missing !!! This was the only file belonging to system tablespace. And i do not have a backup of it because i havent set up any backup mechanism for this system yet !!! Any ways to restore this file or restore the db somehow ?? I have all the archive logs luckily and also the control file. Do i have any option here other than installing the system again, which I would hate to do. ?? experts, please help
Edited by: rajivshekhar on May 13, 2010 5:47 PM
Hi,
Is the tablespace missing just after reboot of the Solaris zone? Is the datafile for this tablespace is a different disc group? Can you check at the global zone if the data files exists? Many times if the share from global zone is not done properly we have the chance to miss out directories.
Regards
Santanu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you have no backups, even with archive logs, you are doomed.
it's time to re-install from scratch
case closed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Eric,
> you have no backups, even with archive logs, you are doomed.
That's a little bit too sketchy. If you are adding a data file and you have all archive logs (and online red logs) from the time of creation until now you are also still able to recover that data.
But to be honest i have never tried it with a data file that was created by a CREATE DATABASE statement - so no idea if this will work.
Regards
Stefan
>
> But to be honest i have never tried it with a data file that was created by a CREATE DATABASE statement - so no idea if this will work.
>
> Regards
> Stefan
Hi Stefan,
I haven't done this either, as usually the Creation SCN for datafile #1 is below 10 and you do in general
do not have all logs back to #0001 without gaps
But with TS extension datafiles it works. Been there done that !
It validates v$datafile for FILE# and CREATION_CHANGE#
you simply CREATE DATAFILE and recover, which will ask for logs since CREATION_CHANGE#.
I have a small example of about one and a half screen page how to do it,
but it garbles the Line Breaks when I clip it in.
Volker
Hello,
i have crosschecked that stuff on my 11gR2 database theoretically.
SQL> select CREATION_CHANGE#, name from v$datafile;
CREATION_CHANGE# NAME
---------------- --------------------------------------------------
7 /oracle/CAT/oradata/system01.dbf
2150 /oracle/CAT/oradata/sysaux01.dbf
.....
SQL> select RECID, FIRST_CHANGE# from v$log_history;
RECID FIRST_CHANGE#
---------- -------------
1 1
2 81671
3 141178
...
So if you create the database with archive log mode initially and you still have all archive logs from change #1 it should work. But i am not quite sure how the SAPinst does create the database (with or without archive log mode).
Regards
Stefan
> So if you create the database with archive log mode initially and you still have all archive logs from change #1 it should work. But i am not quite sure how the SAPinst does create the database (with or without archive log mode).
Sapinst creates the database with archive log enabled and then switches to noarchivelog as soon as the database load starts. After the loading is complete it switches back and does some dipgntab and other stuff.
Markus
> @ rajivshekhar:
> So in this case you are lost ... need to install the system again.
If you still have your old installation directory with inifile.xml you can use a call like
${DVD_LOCATION}/installation_master/<PRODUCT>_IM_<PLATFORM>_<OS>[_<DB>]/sapinst SAPINST_PARAMETER_CONTAINER_URL=${COMMON_FOLDER}/inifile.xml
so you don't need to re-enter all the parameters again.
If you didn't use a separate installation directory but /tmp the file will be gone since /tmp is cleared after a reboot.
Markus
Hi,
it would be possible to recover it if you really have
the current controlfile and ALL archivelogs since creation of the
datafile, but during the load the SAP-Installation disables DB-Logging,
so you will have gaps in archivelogs.
But if you lost the file in a reboot it may just be loacteted on a filesystem
that has not been mounted automaticly.
Otherwise I can think of no valid way to restore this situation.
Volker
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As you are saying physical file is not there and missing file is system data file.....may not be possible to recover.
But you can try as below:
make a data file with same name which one is showing as missed
And delete all your controll files from respective locations
Run controlfile (make the changes which usually make during system copies)
Regards,
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please check the at physical location that system( System TS) file is exist or not.
1:-If file does not exist at the physical location than it's not possible to recover it without DB backup.
2:-If file exist physically & file require recovery than you can recover this file using archive.
3:-use recover database from sql prompt than you will get the archive number which you need to recover the TS. Place these file to archive destination & start recovery.
Thanks & Regards
Karan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.