Data Guard :: Removed Standby But Getting Interesting Alert Log Entry?

Jul 31, 2012

So, we had multiple set ups of primary database in our local data center, standby in remote location.

We're in the process of shutting down our remote location and have shut down our standbys gracefully, i.e., shutdown managed standby mode, removed archive_log_dest, changed archive_log_dest_state, etc. However, in some primary databases, I'm seeing a weird entry in the alert log:

Changing destination 2 from remote to local during archival of log#: 2 sequence#: 48708 thread#: 1

If I check my local destination, the archive log is created fine. In the remote location, no archives are being created.

Oracle version is 11.1.0.7

View 2 Replies


ADVERTISEMENT

Data Guard :: Apply Standby Redo Log To Physical Standby Database

May 26, 2013

I have dataguard configuration operating in maximum availability mode with a local standby db (A - lgwr sync not using real time apply) and a remote standby db (B - lgwr async). I then simualted a crash of my primary database with batch jobs running. Since the stby db A is in lgwr sync option ,all the commited data in the current online redo log has been transmitted to stby A and is present in its stby redo log (Group 2).How do I apply this stby redo log to the remote stby db.

Tried the following methods.

1.ftp the stby redo log to the remote db and tried to regiter it, got an error that it is not completely archived.

2.issued the recover standby database command and supplied the stby redo log when it asked for the sequence in the stby redo, got an error saying there is corruption in a block(tried this option multiple times ended up with the same result.)

View 5 Replies View Related

Data Guard :: Possible To Convert Logical Standby To Physical Standby

Aug 30, 2013

My steps for testing as below:

1.create a primary database
2.duplicate a physical standby database;
3.turn on flashback on both databases.
4.record SCN xxx on physical standby database.
5.convert physical standby to logical standby (using keep identity statement)
6.flashback to logical standby to xxx
7.convert logical standby to physical standby
8.using real time apply I got errors: Fast Parallel Media Recovery enabledManaged Standby Recovery starting Real Time ApplyMRP0:

Background Media Recovery waiting for new incarnation during transient logical upgrade procedure

Errors in file /home ora/ app/ oracle/ diag/ rdbms/ ora11gr1dg/ora11gr1dg/trace/ora11gr1dg_mrp0_10120.trc:ORA-19906: recovery target incarnation changed during recoveryManaged Standby Recovery not using Real Time ApplyErrors in file /home/ ora/app/ oracle/diag/ rdbms/ ora11gr1dg/ ora11gr1dg/ trace/ora11gr 1dg_mrp0_ 10120.trc:ORA-19906: recovery target incarnation changed during recovery  

Errors appears every 10 seconds. Seems MPR0 is waiting for new incarnation for a long time. So am I.Standby database incarnation:

List of Database IncarnationsDB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time-------1 1 ORA11GR1 3853851354 CURRENT 1 08/09/2013 01:02:182 2 ORA11GR1 3853851354 ORPHAN 2127877 08/28/2013 19:22:01     BGV

View 2 Replies View Related

Data Guard :: How To Know Current Active Guard Settings In Standby Database

Oct 17, 2012

Controlling User Access to Tables in a Logical Standby Database can be controlled using the following command:

ALTER DATABASE GUARD STANDBY;

My simple question is: how can I know the current active Guard setting in the standby database?

Oracle 11g R2.

View 1 Replies View Related

Data Guard :: Standby Redo Log On Standby

Apr 24, 2011

GROUP# THREAD# SEQUENCE# sizeMB ARC STATUS T
---------- ---------- ---------- ---------- --- ---------------- -
1 1 115 512 YES CLEARING O
2 1 116 512 YES CURRENT O
6 1 114 512 YES CLEARING O
4 1 112 512 YES CLEARING O
5 1 113 512 YES CLEARING O
3 1 111 512 YES CLEARING O

6 rows selected.
[code]...

Above result is from standby database.I am trying to understand the concept of standby redo log.My stadby database protection_mode is MAXIMUM PERFORMANCE.

View 10 Replies View Related

Data Guard :: Unable To Get Data Of Primary In Standby Database (dataguard)

Jan 16, 2013

i have configured physical standby in my local system, to check logshipping i created a table at primary db, wen i tried to check in standby, it says table does not exist..below are primary & standby alert entries..

Primary alert log

Fatal NI connect error 12514, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.0.98)(PORT=1522))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=STAND)(SERVER=dedicat ed)(CID=(PROGRAM=d:oracle11gappadministratorproduct11.1.0db_1inORACLE.EXE)(HOST=A960M)(USER=SYSTEM))(SERVER=dedicated)))
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.1.0.6.0 - Production

[code]....

View 1 Replies View Related

Data Guard :: Unable To Get Data Of Primary In Standby Database

Jan 16, 2013

I configured dataguard in my local system.

1) scn differs wrt primary in standby (i checked, 1day difference), how to make scn same?

2)i created a table in primary, its not refelecting in standby, (below i ve pasted alertlog entries)

ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Errors in file d:oracle11gappadministratordiag
dbmsstandstand racestand_dbw0_6916.trc:
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: 'D:ORACLE11GAPPADMINISTRATORORADATASTANDSYSAUX01.DBF'

[code]....

3)wen i try to open standby database in read only mode gives below error..

ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1:
'D:ORACLE11GAPPADMINISTRATORORADATASTANDSYSTEM01.DBF'

View 31 Replies View Related

Data Guard :: Can't Connect To Standby DB

Jan 5, 2011

I'm trying to prepare data guard operation on the virtual machines.

1. I have install Oracle database without start up database on the standby server.

2. I try to connect this db by sysdba, but failed!

Quote:
C:>sqlplus "/as sysdba"
SQL*Plus: Release 11.1.0.6.0 - Production on Wed Jan 5 20:03:33 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

ERROR:
ORA-12560: TNS:protocol adapter error

Enter user-name:SQL*Plus: Release 11.1.0.6.0 - Production on Wed Jan 5 20:03:33 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

ERROR:
ORA-12560: TNS:protocol adapter error

Enter user-name:

I'm using instruction below: [URL]

Why I can't login to database?

View 7 Replies View Related

Data Guard :: Physical Standby With Same SID

Sep 22, 2010

I have to implement Physical standby using same SID. parameters required to set on Primary and standby. Also what entries are required to do in TNS file. Recently we have faced hardware failure.

View 10 Replies View Related

Data Guard :: How To Apply Archives In Standby

Sep 1, 2010

i have attended an interview there i got a question like--->There are 100 archives generated in standby in that a series of five archives are missing and those are not available in the primary then how will you do.....

View 2 Replies View Related

Data Guard :: How To Get SQL Plan In Standby Database

Mar 14, 2012

I want to get the execute plan of a sql in standby database(read only),but failed,how can i do?

SQL> explain plan for select count(1) from hxl.tb_objects;
explain plan for select count(1) from hxl.tb_objects
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 2
ORA-16000: database open for read-only access

SQL> select count(1) from hxl.tb_objects;

COUNT(1)
----------
22238018

SQL> select open_mode from v$database;

OPEN_MODE
----------
READ ONLY

View 4 Replies View Related

Data Guard :: Recreating Physical Standby

Jun 4, 2010

I have an issue whereby our standby instance was down for a couple of days and when it came back online we found an archivelog file was missing, so recovery only happened up to a point. It appears that the archivelog was deleted therefore we are unable to continue with this standby. We are now planning to rebuild the standby database. As far as i know all of the steps originally performed need not be performed to complete this task.

1. Shutdown standby
2. Delete all datafiles & redo logs
3. Copy over datafiles to respective directories
4. Copy online logs and archivelogs to standby.
5. Create a control file for standby database
6. Startup mount standby database
7. start redo apply

View 5 Replies View Related

Data Guard :: Oracle 9i Logical Standby

Feb 28, 2012

There are two servers.one in HP-UNIX and another is solaris.

I would like to configure a logical standby using oracle 9i...Is it possible in 9i?

View 7 Replies View Related

Data Guard :: Difference Between Standby And Dataguard

Jun 29, 2010

Difference between standby and dataguard. I assume standby and dataguard are same?

View 4 Replies View Related

Data Guard :: How To Delete Archive Log On Standby

Jun 18, 2011

We are planning to setup a data guard (Maximum performance configuration ) between two Oracle 9i databases on two different servers.

The archive logs on the primary servers are deleted via a RMAN job bases on a policy , just wondering how I should delete the archive logs that are shipped to the standby.

Is putting a cron job on the standby to delete archive logs that are say 2 days old the proper approach or is there a built in data guard option that would some how allow archive logs that are no longer needed or are two days old deleted automatically.

View 1 Replies View Related

Data Guard :: Standby Activation Error?

Oct 22, 2010

I m facing trouble to following trouble.

SQL> ALTER DATABASE OPEN READ ONLY;
ALTER DATABASE OPEN READ ONLY
*
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u01/app/oracle/oradata/PBLSTAN/system01.dbf'

View 1 Replies View Related

Data Guard :: Query Regarding Standby Server

Oct 25, 2011

I want to know that what will happen when I will resize database file from 32G to 5G on primary server or add file to tablespace. Will standby server do the same automatically or I have to to something with standby server?

View 4 Replies View Related

Data Guard :: How To Create Standby Database For RAC

Mar 10, 2010

I have two node rac running on SAN with ASM , i want to configure a single instance standby database for this.

View 2 Replies View Related

Data Guard :: Standby Database Architecture

Jul 8, 2011

To have physical standby database, the hardware and software versions should be same, including patch sets?

View 3 Replies View Related

Data Guard :: Physical Standby Configuration

Mar 10, 2011

I did the all necessary steps required for the physical standby configuration. My standby db is mounted but not able to open.

Below are the steps.

SQL> startup mount

ORACLE instance started.

Total System Global Area 1845493760 bytes

Fixed Size 2021568 bytes
Variable Size 452986688 bytes
Database Buffers 1375731712 bytes
Redo Buffers 14753792 bytes
Database mounted.

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=demodb' scope=both;

System altered.

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE SCOPE=BOTH;

System altered.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

Database altered.

SQL> recover managed standby database cancel;
Media recovery complete.
SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u002/app/OraDB10g/stdemo/oradata/system01.dbf'

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH; ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH
*
ERROR at line 1:

ORA-00600: internal error code, arguments: [kcrfrsetnab_found], [1], [136], [],
[], [], [], []
ORA-00600: internal error code, arguments: [kcrfrgv_scn7], [], [], [], [], [],
[], []

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kccocx_01], [], [], [], [], [], [],
[]

View 3 Replies View Related

Data Guard :: Deleting Logs In Standby

Jan 27, 2011

I've a primary database and a physical standby.Logs are shipping perfectly from primary to standby.The logs that are applied on the standby are getting stored in a mount point(LINUX-/opt2) which consumes more space(160 GB). Will that be right if I go ahead and delete them?

My rman configurations in primary is:

RMAN> show all;

using target database control file instead of recovery catalog

RMAN configuration parameters are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 4;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;

[Code]....

View 2 Replies View Related

Data Guard :: Archive Not Applied On Standby

Mar 25, 2013

We recently configured data guard in test machine.Archives not applied in physical standby.Where i need to start investigation?

Primary
SQL> select THREAD#,max(sequence#) from v$archived_log where applied='YES' group by thread#;
THREAD# MAX(SEQUENCE#)
---------- --------------
1 301
[code]...

View 8 Replies View Related

Data Guard :: Managing Physical Standby

Sep 17, 2013

Today, I am learning dataguard 11.2.0.1. The docs said:A. Monitoring Standby DB Application of redo logs may be monitored by issuing the SQL command:

SQL> select client_dbid, process, sequence#, status from v$managed_standby;

In the primary database, the sequence# with the status “WRITING” would refer to the current redo log sequence#In the standby database, if the status of the process MRPO is “APPLYING LOG” and the status of the process LGWR is “IDLE”, then application of redo logs is up to dateI see that that MRPO at standby is "WAIT_FOR_GAP". How do I resolve this gap.

View 15 Replies View Related

Data Guard :: Standby Not Applying After Outage

Sep 5, 2013

We have a 11r2 primary and standby running on RHEL 5. The primary lost network connectivity for a time and VMWare locked up. The VM admin restarted the primary VM (it was a hard-boot). This all happened while I was gone and when I came into work, the primary database appeared to be working. I decided to dig deeper and check out the standby. On the standby... 

SQL> select * from v$archive_gap;
Thread#: 1
low_sequence: 123120
high_sequence: 123120
 
[Code]...

 It appears all is well (just very far behind) but when I run the last code block (show database prodDB2;) again ... 

DGMGRL> show database prodDB2;
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 2 days 1 hour(s) 42 minutes 37 seconds
Apply Lag: 2 days 1 hour(s) 42 minutes 37 seconds
Real Time Query: OFF
Instance(s): prodDB

it looks as if the massive backlog is just increasing. How can I confirm that everything that things are going well? I am still learning Data Guard. 

View 8 Replies View Related

Data Guard :: Stop Instances At Standby?

Aug 30, 2012

My oracle version is 11.2.0.2 RAC RDBMS on RHEL 5.6.

At my standby site my physical standby database is on 4 node cluster with all 4 instances up. I need to disable 3,4 instances so that we want it to run on only 1,2 instances.To disable the instances do i need to stop apply(mrp) process. And the apply node is node 1.

View 9 Replies View Related

Data Guard :: 10g Physical Standby Database

Sep 17, 2012

DB1 <Primary> - Production
DB2 <Physial Standby> - DR

I will need to startup my DB2 in DR segment for testing.If i perform the below, will it affect my Production DB? I need it to be up and running as well.

DR:
recover managed standby database cancel;
shutdown immediate;
startup nomount;
alter database mount standby database;
recover standby database until cancel;
alter database activate standby database;

View 11 Replies View Related

Data Guard :: Oracle Diagnostics On Standby

Oct 17, 2012

My physical standby - Oracle 11gr2 on RHEL5.6

I want to run RDA on the physical standby, should I run in open read-only mode ?

View 3 Replies View Related

Data Guard :: Getting Standby Host And DB Name From Primary

Oct 25, 2012

I'd like to know the Standby hostname and database name (db_unique_name) from primary using SQL. Simply put, which table in primary datbase gives us the standby host and the database name. I am aware that TNSNAMES.ORA contains details, but we cannot use SQL for that. I am also aware of V$ARCHIVED_LOG's DEST_ID column. But, the DEST_ID will not show the host and the db names, neither does V$PARAMETER's LOG_ARCHIVE_DEST_n if SERVICE parameter is set to Connect Identifier.

If I further paraphrase my problem, how I'd relate a dest_id to a standby host and database using SQL.

SELECT <columns> FROM <v$some_view> WHERE dest_id IN (2, 3);

DEST_ID      HOST_NAME      DATABASE_NAME
--------------------------------------------------------
2            host2           standby_1
3            host3           standby_2DB version : 10g
OS : Solaris 10

View 3 Replies View Related

Data Guard :: Standby In Oracle 10gR1

Apr 1, 2011

As I have implemented data guard in my server. But its not generating archive in standby. May be I am missing some steps. Can any one share Dataguard / standby in oracle 10gR1 steps to be followed.

View 7 Replies View Related

Data Guard :: Sudden Lost To A Standby Box

Mar 24, 2011

While i'm trying some of fail over and switch over scenario's on my primary and standby db configuration. But suddenly i completely loss my standby db box, due to hardware failure. so now i'm not able to recover that box. It is almost non recoverable hardware failure to that box. My primary db is still up and running well. When i check the alert logs of primary db it has some errors related to standby db. Due to configuration it tries to sync the standby db, which is not possible to connect anymore. So my main question is how get rid of that errors/stop that errors from primary db. which parameter's i've to turn off in primary db. Herewith i'm giving some of initSID parameter of Primary db and a snap of alert log from primary db.

My primary db is in MAXIMUM AVAILABILITY mode. Snap from alert files

Errors in file /ora9isoft/odb/OH1/admin/wbdata/bdump/wbdata_lgwr_1248.trc:
ORA-12541: TNS:no listener
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
Creating archive destination LOG_ARCHIVE_DEST_2: 'wbdata.wbhouse'
LGWR: Transmitting activation ID a043c21d
[code]....

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved