Home » Server Options » Data Guard » ORA-01103 create physical standby database (Oracle 12.2, Linux)
ORA-01103 create physical standby database [message #676394] Fri, 07 June 2019 06:14 Go to next message
petar97
Messages: 113
Registered: October 2018
Senior Member

I trying to create physical standby db.

I follow this steps https://oracledbwr.com/step-by-step-to-configure-oracle-12c-data-guard-physical-standby/

But after execution script:

{

allocate channel p1 type disk;

allocate channel p2 type disk;

allocate channel p3 type disk;

allocate channel p4 type disk;

allocate auxiliary channel s1 type disk;

duplicate target database for standby from active database nofilenamecheck

spfile

parameter_value_convert 'prodDB','stand'

set db_unique_name='stand'

set db_file_name_convert='/u01/app/oracle/oradata/prodDB/data/',
'/u01/app/oracle/oradata/stand/data/'

set log_file_name_convert='/u01/app/oracle/fast_recovery_area/
prodDB/PRODDB/onlinelog',
'/u01/app/oracle/fast_recovery_area/stand/STAND/onlinelog'

set control_files='/u01/app/oracle/fast_recovery_area/stand/STAND/onlinelog
/standby1.ctl'

set log_archive_max_processes='5'

set fal_client='stand'

set fal_server='prodDB'

set standby_file_management='AUTO'

set log_archive_config='dg_config=(prodDB,stand)'

set compatible='12.2.0.1.0'

set memory_target='500m';

}
I get this errors:


======== RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 06/07/2019 11:41:43

RMAN-05501: aborting duplication of target database

RMAN-03015: error occurred in stored script Memory Script

RMAN-03009: failure of sql command on clone_default channel at 06/07/2019 
11:41:43

RMAN-11003: failure during parse/execution of SQL statement: alter database 
mount standby database

ORA-01103: database name 'PRODDB' in control file is not 'STAND'

I tried to solve this problem with google search,
but I did not succeed

[Updated on: Fri, 07 June 2019 06:16]

Report message to a moderator

Re: ORA-01103 create physical standby database [message #676395 is a reply to message #676394] Fri, 07 June 2019 06:29 Go to previous messageGo to next message
John Watson
Messages: 8075
Registered: January 2010
Location: Global Village
Senior Member
I cannot understand why people follow articles on web sites like that. It is clearly not correct. For example, his step 4 tells you to start the standby instance off a pfile, but he has not told you what should be in that pfile. Going by the error you have, I would guess that you created one with db_name=stand. Something like that?

You really should direct your question to the person who wrote the article. Or follow the docs, and do it the correct way:
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sbydb/creating-oracle-data-guard-physical-standby.html
Re: ORA-01103 create physical standby database [message #676396 is a reply to message #676395] Fri, 07 June 2019 06:33 Go to previous messageGo to next message
John Watson
Messages: 8075
Registered: January 2010
Location: Global Village
Senior Member
Update: I see he did tell you what should be in pfile, step 2. Trouble is, it is wrong.
Re: ORA-01103 create physical standby database [message #676397 is a reply to message #676396] Fri, 07 June 2019 06:41 Go to previous messageGo to next message
petar97
Messages: 113
Registered: October 2018
Senior Member
Okay, now I know that the error is not mine.

I'll follow Oracle documents, thank you.

If I get an error again, I will put it.

[Updated on: Fri, 07 June 2019 06:45]

Report message to a moderator

Re: ORA-01103 create physical standby database [message #676399 is a reply to message #676394] Fri, 07 June 2019 07:37 Go to previous messageGo to next message
Michel Cadot
Messages: 66714
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So you can now connect to your Linux you couldn't in your previous topic.
So what was the problem?
And what was the solution?

Re: ORA-01103 create physical standby database [message #676403 is a reply to message #676399] Fri, 07 June 2019 11:03 Go to previous messageGo to next message
petar97
Messages: 113
Registered: October 2018
Senior Member
I updated the system and now works well(I posted this in previus topic).

The new update has several new things with the interface, but I do not mind.
Re: ORA-01103 create physical standby database [message #676438 is a reply to message #676403] Sun, 09 June 2019 11:02 Go to previous messageGo to next message
petar97
Messages: 113
Registered: October 2018
Senior Member
After I followed all the steps, I got two lines.

Oracle documents output is different, is it OK?

SYS@stand> SELECT CLIENT_PROCESS, PROCESS, THREAD#, SEQUENCE#, STATUS FROM 
V$MANAGED_STANDBY WHERE CLIENT_PROCESS='LGWR' OR PROCESS='MRP0';   2

CLIENT_P PROCESS      THREAD#  SEQUENCE# STATUS
-------- --------- ---------- ---------- ------------
LGWR	 RFS		    1	      29 IDLE
N/A	 MRP0		    1	       1 WAIT_FOR_GAP

--moderator edit: added [code] tags

[Updated on: Sun, 09 June 2019 12:10] by Moderator

Report message to a moderator

Re: ORA-01103 create physical standby database [message #676440 is a reply to message #676438] Sun, 09 June 2019 11:31 Go to previous messageGo to next message
Michel Cadot
Messages: 66714
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It is not formatted.

Re: ORA-01103 create physical standby database [message #676443 is a reply to message #676440] Sun, 09 June 2019 12:08 Go to previous messageGo to next message
petar97
Messages: 113
Registered: October 2018
Senior Member
Can you explain me a bit?
Re: ORA-01103 create physical standby database [message #676444 is a reply to message #676443] Sun, 09 June 2019 12:12 Go to previous messageGo to next message
John Watson
Messages: 8075
Registered: January 2010
Location: Global Village
Senior Member
I've added the [code] tags to your post (Sunday evening - I am feeling nice). Now it is readable.
The query your have run is not showing whole picture. Try this, in both primary and standby:

select process,status,sequence#,block# from v$managed_standby;

Re: ORA-01103 create physical standby database [message #676445 is a reply to message #676444] Sun, 09 June 2019 12:31 Go to previous messageGo to next message
petar97
Messages: 113
Registered: October 2018
Senior Member
I got this:

SYS@stand> select process,status,sequence#,block# from v$managed_standby;

PROCESS   STATUS	SEQUENCE#     BLOCK#
--------- ------------ ---------- ----------
ARCH	  CONNECTED		0	   0
DGRD	  ALLOCATED		0	   0
DGRD	  ALLOCATED		0	   0
ARCH	  CONNECTED		0	   0
ARCH	  CONNECTED		0	   0
ARCH	  CONNECTED		0	   0
RFS	  IDLE			0	   0
RFS	  IDLE		       30	 181

Re: ORA-01103 create physical standby database [message #676448 is a reply to message #676445] Sun, 09 June 2019 15:01 Go to previous messageGo to next message
John Watson
Messages: 8075
Registered: January 2010
Location: Global Village
Senior Member
Quote:
Try this, in both primary and standby:
Re: ORA-01103 create physical standby database [message #676451 is a reply to message #676448] Mon, 10 June 2019 01:09 Go to previous messageGo to next message
petar97
Messages: 113
Registered: October 2018
Senior Member
On the primary:
SYS@prodDB> select process,status,sequence#,block# from v$managed_standby;

PROCESS   STATUS	SEQUENCE#     BLOCK#
--------- ------------ ---------- ----------
DGRD	  ALLOCATED		0	   0
ARCH	  CLOSING	       29      22528
DGRD	  ALLOCATED		0	   0
ARCH	  CLOSING	       27	   1
ARCH	  CLOSING	       28	   1
ARCH	  CONNECTED		0	   0
LNS	  WRITING	       30      58087
DGRD	  ALLOCATED		0	   0
DGRD	  ALLOCATED		0	   0

On the standby:

SYS@stand> select process,status,sequence#,block# from v$managed_standby;

PROCESS   STATUS	SEQUENCE#     BLOCK#
--------- ------------ ---------- ----------
ARCH	  CONNECTED		0	   0
DGRD	  ALLOCATED		0	   0
DGRD	  ALLOCATED		0	   0
ARCH	  CONNECTED		0	   0
ARCH	  CONNECTED		0	   0
ARCH	  CONNECTED		0	   0
RFS	  IDLE			0	   0
RFS	  IDLE		       30      58078




Re: ORA-01103 create physical standby database [message #676452 is a reply to message #676451] Mon, 10 June 2019 01:12 Go to previous messageGo to next message
John Watson
Messages: 8075
Registered: January 2010
Location: Global Village
Senior Member
So redo is coming across no problem, you need to start managed recovery. Then run those queries again. Also,

select * from v$dataguard_stats.
Re: ORA-01103 create physical standby database [message #677986 is a reply to message #676395] Mon, 28 October 2019 22:50 Go to previous message
sam24
Messages: 1
Registered: October 2019
Junior Member
He is clearly mention in the second step.
You didn't read completely.

Step2:- Changing parameters in standby database

In the $ORACLE_HOME/dbs directory of the standby system, create an initialization parameter file named initstand.ora
Containing a single parameter: DB_NAME=stand

[oracle@standby admin]$ cd $ORACLE_HOME/dbs
[oracle@standby dbs]$ cat initstand.ora
db_name=stand
Previous Topic: RAC to RAC physical standby, why only one node to be applied?
Next Topic: not updating APPLIED column in v$archived_log.
Goto Forum:
  


Current Time: Sat Dec 07 06:39:50 CST 2019