OraFAQ Forum: Data Guard » ORA-01103 create physical standby database

Home » Server Options » Data Guard » ORA-01103 create physical standby database (Oracle 12.2, Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01103 create physical standby database [message #676394]

Fri, 07 June 2019 06:14

petar97
Messages: 120
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

John Watson
Messages: 8964
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

Report message to a moderator

Re: ORA-01103 create physical standby database [message #676396 is a reply to message #676395]

Fri, 07 June 2019 06:33

John Watson
Messages: 8964
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.

Report message to a moderator

Re: ORA-01103 create physical standby database [message #676397 is a reply to message #676396]

Fri, 07 June 2019 06:41

petar97
Messages: 120
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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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?

Report message to a moderator

Re: ORA-01103 create physical standby database [message #676403 is a reply to message #676399]

Fri, 07 June 2019 11:03

petar97
Messages: 120
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.

Report message to a moderator

Re: ORA-01103 create physical standby database [message #676438 is a reply to message #676403]

Sun, 09 June 2019 11:02

petar97
Messages: 120
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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It is not formatted.

Report message to a moderator

Re: ORA-01103 create physical standby database [message #676443 is a reply to message #676440]

Sun, 09 June 2019 12:08

petar97
Messages: 120
Registered: October 2018

Senior Member

Can you explain me a bit?

Report message to a moderator

Re: ORA-01103 create physical standby database [message #676444 is a reply to message #676443]

Sun, 09 June 2019 12:12

John Watson
Messages: 8964
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;

Report message to a moderator

Re: ORA-01103 create physical standby database [message #676445 is a reply to message #676444]

Sun, 09 June 2019 12:31

petar97
Messages: 120
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

Report message to a moderator

Re: ORA-01103 create physical standby database [message #676448 is a reply to message #676445]

Sun, 09 June 2019 15:01

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

Quote:

Try this, in both primary and standby:

Report message to a moderator

Re: ORA-01103 create physical standby database [message #676451 is a reply to message #676448]

Mon, 10 June 2019 01:09

petar97
Messages: 120
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

Report message to a moderator

Re: ORA-01103 create physical standby database [message #676452 is a reply to message #676451]

Mon, 10 June 2019 01:12

John Watson
Messages: 8964
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.

Report message to a moderator

Re: ORA-01103 create physical standby database [message #677986 is a reply to message #676395]

Mon, 28 October 2019 22:50

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

Report message to a moderator