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: 8960
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: 8960
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 Nov 28 06:48:58 CST 2024