Jump to content

Recommended Posts

I Activated the ArchiveLog in my Oracle DB and now i can't connect on it. When i try to connect i see the message "connected to an idle instance". I can not run any query and also can't to revert the archivelog process. How can i revert this and acces my db?

 

Ativei o ArchiveLog no banco do Oracle, agora não consigo mais acessar o bando de dados. Quando tento conectar aparece que me conectei a uma instância inativa. Não consigo executar mais as querys nem reverter o processo do ArchiveLog. O que pode ter acontecido? Como reverto isso?

1.png

2.png

3.png

Share this post


Link to post
Share on other sites

Hi Renan and welcome to the forum!

Your message says that the Oracle instance is not running.

The startup command should get the instance running.

Also, note this on the shared memory realm:

http://www.dba-oracle.com/sf_ora_27101_shared_memory_realm_does_not_exist.htm

Try these steps to get into archive log mode:

http://www.dba-oracle.com/concepts/archivelog_archived_redo_logs.htm

Good luck!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×