| Primary/Logical/Physical [message #288768] |
Tue, 18 December 2007 11:14  |
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 #288872 is a reply to message #288785] |
Wed, 19 December 2007 00:15  |
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 |
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 |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
