Error ORA-01033

DBA Geral (instalação, configuração do banco, scripts do Sql*Plus, shell scripts, batch scripts, etc...)
Post Reply
Edson Macedo
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 3
Joined: Fri, 28 Mar 2008 5:16 pm
Location: São Paulo

Environment Information:
* Oracle version: 9i
* Operating system: Windows XP Professional SP2

Dear friends,

I copied the database on an external disk without stopping the base, and then copied from the external disk to the server also without stopping the base. Now the system does not rise, every time I try to enter the base, I occur to me the message that can not go up because the base is initializing or being finalized.

I was able to express myself? Can anyone help me? I'vê tried everything, I followed several advice and the base does not initialize.

Thanks,
Edson
Dulima-SP
Rank: DBA Júnior
Rank: DBA Júnior
Posts: 193
Joined: Thu, 24 Jan 2008 1:56 pm
Location: SP
Dulima

DBA Oracle Jr

Friend problem zuado this huh ....

take a look at this link ... you if your problem can be solved with these tips ... otherwise a shout there ... .
http://en.glufke.net/oracle/viewtopic.php?t=104


ruevers
Rank: DBA Sênior
Rank: DBA Sênior
Posts: 324
Joined: Fri, 02 Jun 2006 1:48 pm
Location: sp
Contact:

Child,
bad news, it was ....
Edson Macedo
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 3
Joined: Fri, 28 Mar 2008 5:16 pm
Location: São Paulo

Dulima Thank you, I accessed the address you sent me, but I made many of the steps that were given and without success. According to Rueevers it was already, I lost everything ... is that right? Is there no way for me to recover this bank?
ruevers
Rank: DBA Sênior
Rank: DBA Sênior
Posts: 324
Joined: Fri, 02 Jun 2006 1:48 pm
Location: sp
Contact:

Friend,

I hate even given bad news, but the way it did it is almost impossible to recover, copy the direct base without putting the datafiles in backup mode, makes the recovery impossible It would be to have made a backup with RMAN or Export Import.
Dulima-SP
Rank: DBA Júnior
Rank: DBA Júnior
Posts: 193
Joined: Thu, 24 Jan 2008 1:56 pm
Location: SP
Dulima

DBA Oracle Jr

Good old ... I know very little administration and what I know can not affirm if it lost or not ...

more is a tip ... as far as I know ...

This type of manipulation should not be done with the base in the air ...
I do not have technician vocabulary to describe the porque .... masi zua everything .....

Of another time ...

Daki A little more opioes ...
Edson Macedo
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 3
Joined: Fri, 28 Mar 2008 5:16 pm
Location: São Paulo

Good friends, thank you very much for the support, it really had the mistrust of having lost the bank. I'll start all over again, that if I'm not sent away.

Hugs,
Edson
Dulima-SP
Rank: DBA Júnior
Rank: DBA Júnior
Posts: 193
Joined: Thu, 24 Jan 2008 1:56 pm
Location: SP
Dulima

DBA Oracle Jr

If you have a doubt ...
Send there ....

What can we help !!!
Marlon Costa
Rank: Programador Pleno
Rank: Programador Pleno
Posts: 32
Joined: Thu, 03 Apr 2008 10:44 pm
Location: Salvador - BA
Contact:
Saudações

Marlon Costa (marlonsc@conit.com.br)
DBA Sênior - Oracle OCP DB 9i e 10g, OCA AS 9i
CONIT - http://www.conit.com.br - Salvador - BA
Conectando Inteligência e Tecnologia

You can recover, but it will give a lot of work, the way is to force a bench opening in a non-consistent mode. And that, comment on Oracle's support.
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest