Home » RDBMS Server » Server Administration » ORA-00205: Standby database (12.2 linux)
- ORA-00205: Standby database [message #675953] Wed, 01 May 2019 14:49 Go to next message
petar97
Messages: 120
Registered: October 2018
Senior Member
I trying to create physical standby database, I followed this steps https://dbaclass.com/article/how-to-create-physical-standby-database/

I got to the last step, but when I try to startup standby db in mount mode I got ORA-00205: error in identifying control file, check alert log for more info

I don't know, what is happening with controlfile - there is no explanation in this link

- Re: ORA-00205: Standby database [message #675955 is a reply to message #675953] Wed, 01 May 2019 15:06 Go to previous messageGo to next message
John Watson
Messages: 8974
Registered: January 2010
Location: Global Village
Senior Member
I do wonder why you are asking here, rather than asking the owner of that web site.
I also wonder why you are following some third party routine when you could follow the Oracle docs.

However, I do not see any instruction to start the database in mount mode. So I don't know what you are doing at all. You have provide more information.
- Re: ORA-00205: Standby database [message #675956 is a reply to message #675955] Wed, 01 May 2019 15:11 Go to previous messageGo to next message
petar97
Messages: 120
Registered: October 2018
Senior Member
to start the last step
SYS> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
*
ERROR at line 1:
ORA-01507: database not mounted
because the database is not in the mount mode

[Updated on: Wed, 01 May 2019 15:11]

Report message to a moderator

- Re: ORA-00205: Standby database [message #675957 is a reply to message #675956] Wed, 01 May 2019 17:05 Go to previous messageGo to next message
John Watson
Messages: 8974
Registered: January 2010
Location: Global Village
Senior Member
so presumably the previous step failed. You say your attempt to mount the standby also failed. If you were to show what happened, it might help.
- Re: ORA-00205: Standby database [message #676155 is a reply to message #675957] Fri, 17 May 2019 11:38 Go to previous messageGo to next message
petar97
Messages: 120
Registered: October 2018
Senior Member
I think the error is on the website, I followed Oracle docs, and I am succeeded to create a standby DB.

P.S. Sorry for the late answer.
- Re: ORA-00205: Standby database [message #677211 is a reply to message #675953] Fri, 30 August 2019 13:03 Go to previous message
hammadahmed
Messages: 1
Registered: August 2019
Junior Member
its a valid info, thanks for sharing.
Previous Topic: ASM interview question
Next Topic: Query to get the maxsize and unlimited of the TableSpace
Goto Forum:
  


Current Time: Thu Apr 17 09:15:58 CDT 2025