ORA-01153: an incompatible media recovery is active

5 de October de 201631 de January de 2017matheusboesing 1 Comment

When trying to start or increase parallel of recover manager on datagauard (MRP):

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active

I simply happen because there already are a process runnning, let’s check:

Continue reading →

After adding Datafile in Primary the MRP Stopped in Physical Standby (Dataguard)

17 de August de 201631 de January de 2017matheusboesing Leave a comment

Hi all!
After add a datafile in PRIMARY database, the STANDBY MRP stopped. An “ALTER DATABASE RECOVER MANAGED STANDBY DATABASE” does not solved te problem, as you see:

SQL> SELECT SEQUENCE#, Name, APPLIED FROM V$ARCHIVED_LOG where APPLIED  'YES' and SEQUENCE#  ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
Database altered.
SQL> SELECT SEQUENCE#, Name, APPLIED FROM V$ARCHIVED_LOG where APPLIED  'YES' and SEQUENCE# < (select max(SEQUENCE#) -1 from V$ARCHIVED_LOG);
SEQUENCE#  NAME                                                                              APPLIED
----------  --------------------------------------------------------------------------------  ---------
15075  /db/u1004/oracle/admin/MYDB/arch/arch_1_823102978_15075.arc                    NO

Continue reading →

nc -l – Starting up a fake service

22 de April de 201631 de January de 2017Rafael Nólio 1 Comment

Hi everyone!

Recently i have faced a situation that made me find out a very nice and useful command that helped me a lot, and i hope it comes to help you guys as well, and it’s named:

Situation: We have a replicated environment from one datacenter to another (Using Golden Gate), where the ETL happens. So basically is:

Datacenter 1 (root data)

Replicates to datacenter 2 (transforming the data)

that replicates to datacenter 3 (production itself)

In Datacenter level 2, we have a dataguard configured. So then came the question:

What if we need to do the switchover to the standby environments?
Will we gonna have everything we need properly set up for the replication?
How are we going to test the ports if nothing is up in there? Aren’t we gonna get “connection refused”?

Calm down! There is a very nice workaround for this.

All you need to do is install the nc command as root (if it is not installed already):

yum install nc

Then execute it as follows, on the server you wanna test:

nc -l

example:

I wanna make sure that on the standby server the port 7809 (Golden Gate MANAGER port) is open. On the standby server you run:

nc -l 7809

Then, from a remote server, you are going to be able to connect through a simple telnet command:

telnet server.domain port

example:

telnet standby.company.com 7809

ON PRACTICE:

Try the telnet from the remote server to the standby:

remoteserver {/home/oracle}: telnet standby.server 7809

Trying 192.168.0.10…

telnet: connect to address 192.168.0.10: Connection refused

Then we start the fake service on the standby server!

standby.server {/home/oracle}: nc -l 7809

And try the telnet again:

remoteserver {/home/oracle}: telnet standby.server 7809

Trying 192.168.0.10…

Connected to standby.server.

Escape character is ‘^]’.

Cheers!

Rafael.

ORA-10456: cannot open standby database; media recovery session may be in progress

22 de February de 201631 de January de 2017matheusboesing Leave a comment

A dataguard quick tip!

# Error

SQL> ALTER DATABASE OPEN READ ONLY;
ALTER DATABASE OPEN READ ONLY
*
ERROR at line 1:
ORA-10456: cannot open standby database; media recovery session may be in progress

# Solution

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Database altered.
SQL> ALTER DATABASE OPEN READ ONLY;
Database altered.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;
Database altered.

See ya! 🙂
Matheus.

ORA-10456: cannot open standby database; media recovery session may be in progress

4 de June de 201531 de January de 2017matheusboesing Leave a comment

Easy, easy… Take a look:

# Error

db2database2p:>srvctl status database -d database Instance database1 is running on node db1database1p Instance database2 is not running on node db2database2p db2database2p:>srvctl start instance -d database -i database2 PRCR-1013 : Failed to start resource ora.database.db PRCR-1064 : Failed to start resource ora.database.db on node db2database2p CRS-5017: The resource action "ora.database.db start" encountered the following error: ORA-10456: cannot open standby database; media recovery session may be in progress . For details refer to "(:CLSN00107:)" in "/grid/product/11.2.0/log/db2database2p/agent/crsd/oraagent_oracle/oraagent_oracle.log". CRS-2674: Start of 'ora.database.db' on 'db2database2p' failed.

# Solution

Connected to an idle instance.

SQL> startup ORACLE instance started. Total System Global Area 1.1224E+11 bytes Fixed Size 2234920 bytes Variable Size 6.1472E+10 bytes Database Buffers 5.0466E+10 bytes Redo Buffers 299741184 bytes Database mounted. ORA-10456: cannot open standby database; media recovery session may be in progress

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; Database altered. SQL> ALTER DATABASE OPEN READ ONLY; Database altered. SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options

db2database2p:>srvctl status database -d database Instance database1 is running on node db1database1p Instance database2 is running on node db2database2p

Matheus.