now i try to restart the server without success. i try to recreate an undo tablespace too, but it is not possible due to "database not open" error and if i try to "alter database open" i get "ORA-01092: oracle instance terminated. disconnection forced".
On 1 Aug, 11:24, de12261 <de12...@gmail.com> wrote:
> Hello
> I made a mistake and deleted undotbs01.dbf.
> now i try to restart the server without success. > i try to recreate an undo tablespace too, but it is not possible due > to "database not open" error and if i try to "alter database open" i > get "ORA-01092: oracle instance terminated. disconnection forced".
> Please, HELP!!
> thankyou
Operating system? Oracle version?
Anyway, if the database is in ARCHIVELOG mode and you have datafile backups, restore the latest copy of UNDOTBS01.DBF at the operating system level then recover your database.
If you're not in ARCHIVELOG mode, you will have to restore you your last consistent (cold) backup.
On Aug 1, 5:24 am, de12261 <de12...@gmail.com> wrote:
> Hello
> I made a mistake and deleted undotbs01.dbf.
> now i try to restart the server without success. > i try to recreate an undo tablespace too, but it is not possible due > to "database not open" error and if i try to "alter database open" i > get "ORA-01092: oracle instance terminated. disconnection forced".
> Please, HELP!!
> thankyou
If you don't have a valid backup, either cold or hot, of this database you really have no other option other than to recreate this database. I hope you have at least a recent export if you don't have a backup. Any port is better than no port in this storm.
> now i try to restart the server without success. > i try to recreate an undo tablespace too, but it is not possible due > to "database not open" error and if i try to "alter database open" i > get "ORA-01092: oracle instance terminated. disconnection forced".
If you comment UNDO_MANAGEMENT = auto in your pfile/spfile can you open the database ?
On Aug 1, 2:54 pm, "astalavista" <nob...@nowhere.com> wrote:
> > I made a mistake and deleted undotbs01.dbf.
> > now i try to restart the server without success. > > i try to recreate an undo tablespace too, but it is not possible due > > to "database not open" error and if i try to "alter database open" i > > get "ORA-01092: oracle instance terminated. disconnection forced".
> If you comment UNDO_MANAGEMENT = auto > in your pfile/spfile > can you open the database ?
The tablespace and datafile info is still in the controlfile. Is not going to work.
On Aug 1, 8:59 am, gazzag <gar...@jamms.org> wrote:
> On 1 Aug, 14:36, sybrandb <sybra...@gmail.com> wrote:
> > The tablespace and datafile info is still in the controlfile. > > Is not going to work.
> > -- > > Sybrand Bakker > > Senior Oracle DBA
> Sybrand,
> Do you think an ALTER DATABASE BACKUP CONTROLFILE TO TRACE might help?
> Just a thought...
Since the only rollback segment available would be the SYSTEM rollback segment I doubt even that would get this database open; it might allow it to mount, however, which may be enough to create a new undotbs1.dbf file.
It's probably worth a try; as I said earlier any port in this storm is better than no port at all.
On 1 Ago, 16:30, "fitzjarr...@cox.net" <fitzjarr...@cox.net> wrote:
> Since the only rollback segment available would be the SYSTEM rollback > segment I doubt even that would get this database open; it might allow > it to mount, however, which may be enough to create a new undotbs1.dbf > file.
> It's probably worth a try; as I said earlier any port in this storm is > better than no port at all.
> David Fitzjarrell
Hello
i cannot open... when I try "alter database open" it gives me the error ORA-01092: oracle instance terminated....
so I cannot create a new undo tablespace...
is there any other solution to recreate a tablespace????
> On 1 Ago, 16:30, "fitzjarr...@cox.net" <fitzjarr...@cox.net> wrote:
> > Since the only rollback segment available would be the SYSTEM rollback > > segment I doubt even that would get this database open; it might allow > > it to mount, however, which may be enough to create a new undotbs1.dbf > > file.
> > It's probably worth a try; as I said earlier any port in this storm is > > better than no port at all.
> > David Fitzjarrell
> Hello
> i cannot open... > when I try "alter database open" it gives me the error ORA-01092: > oracle instance terminated....
> so I cannot create a new undo tablespace...
> is there any other solution to recreate a tablespace????
> they do not have a backup ...
> :-(
> thank you
Try this
SQL> startup mount
SQL> Alter database datafile < datafile path or file number> offline drop;
SQL> alter database open;
Then * create a new Undo Tablespace * Make the newly created Undo tablespace as default undo tablespace * drop the old undo tablespace.
> On Aug 1, 10:50 am, de12261 <de12...@gmail.com> wrote:
> > On 1 Ago, 16:30, "fitzjarr...@cox.net" <fitzjarr...@cox.net> wrote:
> > > Since the only rollback segment available would be the SYSTEM rollback > > > segment I doubt even that would get this database open; it might allow > > > it to mount, however, which may be enough to create a new undotbs1.dbf > > > file.
> > > It's probably worth a try; as I said earlier any port in this storm is > > > better than no port at all.
> > > David Fitzjarrell
> > Hello
> > i cannot open... > > when I try "alter database open" it gives me the error ORA-01092: > > oracle instance terminated....
> > so I cannot create a new undo tablespace...
> > is there any other solution to recreate a tablespace????
> > they do not have a backup ...
> > :-(
> > thank you
> Try this
> SQL> startup mount
> SQL> Alter database datafile < datafile path or file number> offline > drop;
> SQL> alter database open;
> Then > * create a new Undo Tablespace > * Make the newly created Undo tablespace as default undo > tablespace > * drop the old undo tablespace.
> Thanks, > Krishna- Hide quoted text -
> - Show quoted text -
This is not going to work. This will drop the datafile, it won't drop the tablespace. Oracle will try to online the tablespace and halt.
de12261 wrote: > On 1 Ago, 16:30, "fitzjarr...@cox.net" <fitzjarr...@cox.net> wrote: >> Since the only rollback segment available would be the SYSTEM rollback >> segment I doubt even that would get this database open; it might allow >> it to mount, however, which may be enough to create a new undotbs1.dbf >> file.
>> It's probably worth a try; as I said earlier any port in this storm is >> better than no port at all.
>> David Fitzjarrell
> Hello
> i cannot open... > when I try "alter database open" it gives me the error ORA-01092: > oracle instance terminated....
> so I cannot create a new undo tablespace...
> is there any other solution to recreate a tablespace????
> they do not have a backup ...
> :-(
> thank you
Push yourself away from the keyboard and stop doing stuff.
You are as likely to be making things worse as better.
Go to metalink.oracle.com and open an SR.
And generic advice to everyone and anyone: If you aren't doing regular backups with RMAN seriously consider getting another form of employment. -- Daniel A. Morgan University of Washington damor...@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org
> On Aug 1, 10:50 am, de12261 <de12...@gmail.com> wrote:
> > On 1 Ago, 16:30, "fitzjarr...@cox.net" <fitzjarr...@cox.net> wrote:
> > > Since the only rollback segment available would be the SYSTEM rollback > > > segment I doubt even that would get this database open; it might allow > > > it to mount, however, which may be enough to create a new undotbs1.dbf > > > file.
> > > It's probably worth a try; as I said earlier any port in this storm is > > > better than no port at all.
> > > David Fitzjarrell
> > Hello
> > i cannot open... > > when I try "alter database open" it gives me the error ORA-01092: > > oracle instance terminated....
> > so I cannot create a new undo tablespace...
> > is there any other solution to recreate a tablespace????
> > they do not have a backup ...
> > :-(
> > thank you
> Try this
> SQL> startup mount
> SQL> Alter database datafile < datafile path or file number> offline > drop;
> SQL> alter database open;
> Then > * create a new Undo Tablespace > * Make the newly created Undo tablespace as default undo > tablespace > * drop the old undo tablespace.
> Thanks, > Krishna- Hide quoted text -
I tested this script and worked for me on my laptop ( running Oracle 10.2.0.1 on windows).
Check your alert log for a more descriptive report of the exact startup problem. post if you find any new error messages .
> Push yourself away from the keyboard and stop doing stuff.
> You are as likely to be making things worse as better.
> Go to metalink.oracle.com and open an SR.
> And generic advice to everyone and anyone: If you aren't doing > regular backups with RMAN seriously consider getting another form > of employment. > -- > Daniel A. Morgan > University of Washington > damor...@x.washington.edu (replace x with u to respond) > Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
> - Show quoted text -
This is sound advice. However, if you must insist on fiddling, shutdown the database and take a filesystem backup before you do anything further. If the worse comes to the worse, you can then restore from this backup or even transfer it to another server.
de12261 wrote: > On 1 Ago, 17:27, DA Morgan <damor...@psoug.org> wrote: >> Push yourself away from the keyboard and stop doing stuff.
>> You are as likely to be making things worse as better.
>> Go to metalink.oracle.com and open an SR.
>> And generic advice to everyone and anyone: If you aren't doing >> regular backups with RMAN seriously consider getting another form >> of employment.
> I think the same... > but it is not my responsibility if one of our customers do not make > backups of their data....
If it is your responsibility to recover it then it is your responsibility to make sure it is backed up: If not then just go do something else or go home. <g> -- Daniel A. Morgan University of Washington damor...@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org
On 1 Ago, 22:11, DA Morgan <damor...@psoug.org> wrote:
> If it is your responsibility to recover it then it is your > responsibility to make sure it is backed up: If not then just go do > something else or go home. <g>
in fact it is not my responsability to recover this database but because of the kind of these people (that do not make a backup) you probably understand why I try by myself to recover data ... I need this data to do some query ...
On Wed, 01 Aug 2007 13:02:29 -0700, de12261 <de12...@gmail.com> wrote: >I think the same... >but it is not my responsibility if one of our customers do not make >backups of their data....
Are you seriously stating you can't be held responsible for screwing up a database when there is no back up? Evidently your customer will held you responsible and kick you out. And rightly so.
> Are you seriously stating you can't be held responsible for screwing > up a database when there is no back up? > Evidently your customer will held you responsible and kick you out. > And rightly so.
i do nothing of wrong, they deleted a file not me!! they asked me to recover data because oracle do not work anymore.... in the first message I do not explain all because this is not the problem....
On Aug 1, 2:36 pm, sybrandb <sybra...@gmail.com> wrote:
> On Aug 1, 2:54 pm, "astalavista" <nob...@nowhere.com> wrote:
> > > I made a mistake and deleted undotbs01.dbf.
> > > now i try to restart the server without success. > > > i try to recreate an undo tablespace too, but it is not possible due > > > to "database not open" error and if i try to "alter database open" i > > > get "ORA-01092: oracle instance terminated. disconnection forced".
> > If you comment UNDO_MANAGEMENT = auto > > in your pfile/spfile > > can you open the database ?
> The tablespace and datafile info is still in the controlfile. > Is not going to work.
well the following worked for me after moving the datafile (6) for the undo tablespace.
> > Are you seriously stating you can't be held responsible for screwing > > up a database when there is no back up? > > Evidently your customer will held you responsible and kick you out. > > And rightly so.
> i do nothing of wrong, they deleted a file not me!! > they asked me to recover data because oracle do not work anymore.... > in the first message I do not explain all because this is not the > problem....
> bye
In your first message you stated you deleted it, what do you expect people to think?
Even so, as gazzag said, the first thing you should do in this sort of crisis is take a filesystem backup, so you can undo any damage _you_ inflict.
I'm still unclear as to whether you are in archivelog mode.
On Wed, 01 Aug 2007 03:24:54 -0700, de12261 <de12...@gmail.com> wrote: >Hello
>I made a mistake and deleted undotbs01.dbf.
>now i try to restart the server without success. >i try to recreate an undo tablespace too, but it is not possible due >to "database not open" error and if i try to "alter database open" i >get "ORA-01092: oracle instance terminated. disconnection forced".
>Please, HELP!!
Open a metalink SR, and hope you get an engineer that has a clue. With some help, you might be able to bring up the db and imp/exp your data elsewhere. ....... We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc) remove NSPAM to email
On Wed, 01 Aug 2007 13:45:20 -0700, de12261 <de12...@gmail.com> wrote: >On 1 Ago, 22:23, sybra...@hccnet.nl wrote: >> Are you seriously stating you can't be held responsible for screwing >> up a database when there is no back up? >> Evidently your customer will held you responsible and kick you out. >> And rightly so.
>i do nothing of wrong, they deleted a file not me!! >they asked me to recover data because oracle do not work anymore.... >in the first message I do not explain all because this is not the >problem....
>bye
Quoting from your original post
Hello
I made a mistake and deleted undotbs01.dbf.
Please do not try to chicken out and blame someone else.
|
