Home » Server Options » Data Guard » Primary/Logical/Physical
Primary/Logical/Physical [message #288768] Tue, 18 December 2007 11:14 Go to next message
cleto
Messages: 5
Registered: February 2007
Junior Member
We have the following setup
primary db
==========
OPEN_MODE DATABASE_ROLE
---------- ----------------
READ WRITE PRIMARY
standby_file_management AUTO

LOGICAL STDBY
=============
OPEN_MODE DATABASE_ROLE
---------- ----------------
READ WRITE LOGICAL STANDBY
standby_file_management AUTO

PHYSICAL STDBY
==============
OPEN_MODE DATABASE_ROLE
---------- ----------------
MOUNTED PHYSICAL STANDBY
standby_file_management AUTO

All datafile paths are similar

I want to create a new tablespace on the primary DB will it be created automatically on the logical & physical standby db?

I do not have a test environment, as i have to do it on production, want to be sure if any of you guys have done this before. As of now all primary,logical,physical dbs are in sync. I don't want to disturb the replication.

Please advice.










Re: Primary/Logical/Physical [message #288785 is a reply to message #288768] Tue, 18 December 2007 11:52 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:

READ WRITE PRIMARY
standby_file_management AUTO



Quote:

I want to create a new tablespace on the primary DB will it be created automatically on the logical & physical standby db?


YES

Check this link or search that parameter..
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10755/initparams206.htm
Re: Primary/Logical/Physical [message #288872 is a reply to message #288785] Wed, 19 December 2007 00:15 Go to previous messageGo to next message
cleto
Messages: 5
Registered: February 2007
Junior Member
Thanks for your response,could tell me if the below steps are correct?How to check status before & after for all dbs

how to check the replication status on primary,logical stdby, physical stdby if everything is ok BEFORE to executing

the below steps

primarydb
=======
connect sys@constr as sysdba
create tablespace per datafile 'z:\DATA\perfstat.dbf' size 200M autoextend
on;

Logical stdby db [explicitly]
=====================
connect sys@constr as sysdba
create tablespace per datafile 'z:\DATA\perfstat.dbf' size 200M autoextend on;

Physical stdby db
=============
No statements to execute, the above changes to primary will automatically get
updated here.

how to check the replication status on primary,logical stdby, physical stdby if everything
is ok AFTER to executing
the below steps
Re: Primary/Logical/Physical [message #289101 is a reply to message #288872] Wed, 19 December 2007 13:12 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
I'm not sure about logical but for physical standby database cancel managed recovery open the database in read only mode and check the tablespace on standby,after checking put back physical standby in recover managed mode.

One other option when you creating files on primary or doing normal transaction you can check the status of MRP process by this query.

SELECT  PROCESS, STATUS,SEQUENCE#,BLOCK#,BLOCKS, DELAY_MINS FROM 
               V$MANAGED_STANDBY;


You will notice that the value for MRP will keep increasing if work is going on on primary database.
Re: Primary/Logical/Physical [message #289333 is a reply to message #289101] Thu, 20 December 2007 14:32 Go to previous messageGo to next message
cleto
Messages: 5
Registered: February 2007
Junior Member
I managed to create the per tablespace on the primary and automatically it got created on physical & logical stabdby, then i installed the statspac on the primary, and now the logs are not getting applied to the logical standby. Do i have to install the statspack on the standby as well.

in alert.log show this error.
Thu Dec 20 23:55:57 2007
LOGSTDBY stmt: grant execute on dbms_shared_pool to execute_catalog_role
LOGSTDBY status: ORA-04042: procedure, function, package, or package body does not exist
LOGSTDBY id: XID 0x000d.01b.00009d72, hSCN 0x0000.20c7cf14, lSCN 0x0000.20c7cf14, Thread 1, RBA 0x6642.0000433b.138, txnCscn 0x0000.20c7cf17, PID 12856, ORACLE.EXE (P006)
LOGSTDBY Apply process P006 pid=29 OS id=12856 stopped
Re: Primary/Logical/Physical [message #289469 is a reply to message #289333] Sat, 22 December 2007 00:50 Go to previous message
NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad
Member
In my opinion the statspack should be installed on the standby databases as well. On the logical standby you can query the dba_logstdby_events for checking the cause of failures.

[Updated on: Sat, 22 December 2007 00:51]

Report message to a moderator

Previous Topic: problem in achive log destination -2 after switchover
Next Topic: Switchover issues with 2 physical standby databases
Goto Forum:
  


Current Time: Thu Mar 28 11:31:36 CDT 2024