Data Guard :: ORA-16401 / Archivelog Rejected By RFS

Sep 1, 2011

initial configuration:

cta: physical standby
ctastd: primary

I cancel my failover at cta half way, from [URL]

Quote:

Step 4 Initiate a failover on the target physical standby database.

Issue the following statement to initiate the failover:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE;

during the above process it took too long so I opened up another session and cancel the above process

SQL>alter database recover managed standby database cancel;

the data guard configuration is left as it is, i.e.

cta: physical standby
ctastd: primary

I discover the following findings in the alertcta.log, i.e. in cta database,

Primary database is in MAXIMUM PERFORMANCE mode
RFS[8]: Successfully opened standby log 4: 'D:ORA102CTAREDO04.LOG'
Thu Sep 01 10:38:08 2011
Errors in file d:ora102ctaudumpcta_rfs_536.trc:
ORA-16401: archivelog rejected by RFS

Quote:

ORA-16401: archivelog rejected by RFS

Cause: An attempt was made to re-archive an existing archivelog. This usually happens because either a multiple primary database or standby database(s) or both are trying to archive to this standby database.

Action: See alert log and trace file for more details. No action is necessary; this is an informational statement provided to record the event for diagnostic purposes.

it seems to be that there are multiple primary database, but it is not based on the information from v$database.Right now the physical standby database cannot received any archive logs from the primary.I've checked the database_role in both servers, they are as they are designated.

from the physical standby database

SYS@cta>select db_unique_name, database_role, switchover_status from v$database;
DB_UNIQUE_NAME DATABASE_ROLE SWITCHOVER_STATUS
------------------------------ ---------------- --------------------
CTA PHYSICAL STANDBY NOT ALLOWED
SYS@cta>alter database recover managed standby database disconnect from session

[code]....

the standby is always busy, i.e. SESSIONS ACTIVE. i.e make sure the archived logs are shipped and apply over to physical standby.

I'm using Oracle 10.2.0.4 and os is windows.

View 6 Replies


ADVERTISEMENT

Data Guard :: FAL Request Rejected Error And Log Shipping Not Working?

Apr 7, 2011

I have a 10gR2 standby database.Normally when logs are created in primary they automatically get shipped to standby but sometimes I get FAL request rejected or connection lost contact error and the logs are not automatically shipped .

Then when I manually switch a logfile the RFS process copies the old logs into DR site(around 4 or 5 logs).What is the problem...How to resolve this???

View 2 Replies View Related

Data Guard :: RMAN Refuses To Delete Old Archivelog

Apr 10, 2013

We have two Windows 2008 VMs with Oracle 11G configured as primary and standby.This configuration has been defined by a partner who is no longer working for us.We have broken the correct application of the redo log on the standby when we have not correctly restored some snapshots on those two VMs.I would like to create a new Oracle server that will become the new standby. For that, I need too :

- Display the full dataguard configuration to reproduce it on the new server
- Stop (delete ?) the configuration on the primary server.

We also have the current problem that RMAN refuses to delete old archivelog since they have not been applied to the standby.

View 3 Replies View Related

Data Guard :: Archivelog Source Directory In Standby Database

Jul 15, 2013

I created a standby database yesterday and everything is working correctly.  I need to make some tweaks, however, and one of those is the directory that the standby database expects the archivelogs to be.

I found that the archivelogs were being shipped to $ORACLE_HOME/dbs and named arch*.arc.  Interestingly a log switch ships the archivelog minus the "arch" at the front and all archivelogs now do not have that format. I moved the archivelogs to the correct location and renamed them.  I have been able to set the correct location using standby_archive_dest and can see that the archivelogs are shipped to there.

Also, v$archived_log shows the correct path and filename. The problem I have is that when I come to apply the archivelogs it still seems to think that they should be in $ORACLE_HOME/dbs and named with "arch" at the front.  what parameter I need to change to tell oracle the correct path and filename to use when applying the archivelogs? 

View 9 Replies View Related

Data Guard :: How To Delete Archivelog In Standby Database When Applied Successfully

Aug 20, 2008

How to make the automatic deletion of all the archivelogs when it is applied successfully on the standby database? We have 1 primary database and 1 standby database using oracle physical dataguard.

In the primary database, we have daily backup job so that the applied archivelogs are deleted automatically, no problem

But in the standby database ( physical standby) I have to go there and delete manually because I don't issue backup on this database. Is there any solution for this problem.

View 3 Replies View Related

Data Guard :: Configure Archivelog Deletion Policy To Applied On Standby

Nov 16, 2012

I have a DR setup with the following configuration

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY

I dont want to backup the STDBY DB but I want the ARC files to be removed when applied so my flash area does not fill up. Is there some command(rman or not) that can fire off this policy?

View 6 Replies View Related

Data Guard :: Unable To Transfer Archivelog Wrong Pass File

Aug 2, 2010

I am creating physical standby database through Rman duplicate command from 2 node rac cluster. rman do all its work. now am try to start the mrp process on physical standby database. I am getting following errors

------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
ORA-16191: Primary log shipping client not logged on standby
------------------------------------------------------------

I copied the same pass file from primary to standby and many times verify the same but i got the same error.

View 4 Replies View Related

Data Guard :: Rolling Upgrade Physical Data Guard

Jul 5, 2011

We have physical data guard configured version (10.2.0.4). We are in need to upgrade primary & standby database to 11G R2. Can we perform rolling upgrade.

View 3 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

PL/SQL :: Timestamps - All Rows Are Getting Rejected?

Oct 5, 2012

My control file

LOAD DATA
Infile code_val_new.dat
BADFILE sample.bad
DISCARDFILE sample.dsc

[code]...

18 7BLM AGS ELEM BUILDING MATHEMATICAL EXTRACT Oct 4 2012 3:19:26:000AM

But all rows are getting rejected. What modification should i make?

View 26 Replies View Related

Server Utilities :: Getting Error At Import - Row Rejected

Dec 18, 2010

While importing I am getting this below error.

================================================
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (JD_HO.SYS_C001087) violated

View 3 Replies View Related

Server Utilities :: To Capture Rejected Records Into A Table Using Sql Loader

Sep 5, 2012

Is there any process to capture rejected data(bad data) in a table when data is moved using SQL Loader.

View 5 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 :: Changing Dbname / Sid / Data / Control File Locations?

Nov 5, 2010

I want to change dbname,sid,data/control file locations in operational dataguard setup i plan to follow as below

1)shutdown primary and standby (stop managed recovery)

2)change db name in init.ora of primary and standby change database name control file location

3)create control file for primary from trace(script) make changes for db name and file locations

4)mount and open primary database

5)create standby control file

6) transfer standby control file to standby

7) mount stand by database and start manage recovery

If this steps will error free do i need to follow any thing additional to this or what is other best way for this or its not possible at all

View 1 Replies View Related

Data Guard :: Buffer Busy Waits On UNDO Data In Active DG

Feb 24, 2013

Oracle Version: 11.1.0.7.0
Active Dataguard

Statspack has been configured for Active Dataguard on Primary database.We got an spike of Buffer busy waits for about 5 min in Active Dataguard, this was causing worse Application SQL's response time during this 5 min window.Below is what i got from statspack report for one hour

Snapshot       Snap Id     Snap Time      Sessions Curs/Sess Comment
~~~~~~~~    ---------- ------------------ -------- --------- -------------------
Begin Snap:      18611 21-Feb-13 22:00:02      236       2.2
  End Snap:      18613 21-Feb-13 23:00:02      237       2.1
   Elapsed:               60.00 (mins)
[code]...

Why there could sudden spike of demand on UNDO data in Active Data Guard ?

View 2 Replies View Related

Data Guard :: DATA FILES IN Storage Area Network (SAN)

Mar 29, 2011

I am working in a bank as an system consultant, i have a SAN Storage Area and oracle as below.

SAN 1

This interface includes the DATA FILES of the oracle tablespace

SAN 2

SAN1 Mirrors the DATA FILES of the oracle tablespace to SAN 2

1. Can i rely on real time data recovery from SAN2 ?
2. if SAN1 (Data Files are currupted) will the SAN2 Data Files will be currupted as well.
3. If the SAN2 is currupted then what Oracle Features can be used to have uncurrupted data.

View 5 Replies View Related

Data Guard :: ORA-01157 / Cannot Identify / Lock Data File 1

Jul 23, 2010

i did everything writen but when i do *SQL>alter database recover managed standby database disconnect from session;*

i go and look in the standby database AlertLog file ,and thats whats writen

*ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'F:ORACLEPRODUCT10.2.0ORADATADBSYSTEM01.DBF'
ORA-27041: unable to open file
OSD-04002: غير قادر على فتح الملف
O/S-Error: (OS 3) The system cannot find the path specified.

[code]....

strange thing that it realises the primary database in drive F and it goes to it but i dont understand what could be the reason of this ,although im doing this command while primary database is shutdown!

View 2 Replies View Related

Data Guard :: ORA-01354 / Supplemental Log Data Must Be Added To Run This Command

May 2, 2012

I configure logical standby online .when I execute dbms_logstdby.buid,first

SQL> EXECUTE DBMS_LOGSTDBY.BUILD;

it was blcoked by other sesson,then i kill the holding session,but no work.then i cancel this step and execute it again . the error is

SQL> EXECUTE DBMS_LOGSTDBY.BUILD;
BEGIN DBMS_LOGSTDBY.BUILD; END;
*
ERROR at line 1:
ORA-01354: Supplemental log data must be added to run this command
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 3669
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 3755
ORA-06512: at "SYS.DBMS_LOGMNR_D", line 12
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_INTERNAL_LOGSTDBY", line 370
ORA-06512: at "SYS.DBMS_LOGSTDBY", line 157

[code]....

View 3 Replies View Related

Data Guard :: Data Files Locations On Oracle 11gR2

Jun 15, 2012

I have set up a cross platform (Microsoft Windows IA (32-bit) -> Linux x86 64-bit) data guard and it worked fine.Then I did a switch over (which again worked) and found out the data is not getting replicated at all.. checked the data files available from the new primary database and found out they are in the windows format as below..

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
D:ORACLEAPPADMINISTRATORORADATAMFSSYSTEM01.DBF
D:ORACLEAPPADMINISTRATORORADATAMFSSYSAUX01.DBF
D:ORACLEAPPADMINISTRATORORADATAMFSUNDOTBS01.DBF
D:ORACLEAPPADMINISTRATORORADATAMFSUSERS01.DBF
D:ORACLEAPPADMINISTRATORORADATAMFSRMANRMAN_TS01.DBF

and physically they were created at '/home/app/oracle/product/11.2.0/db_1/dbs/' and as

D:ORACLEAPPADMINISTRATORORADATAMFSREDO02.LOG
D:ORACLEAPPADMINISTRATORORADATAMFSREDO03.LOG
D:ORACLEAPPADMINISTRATORORADATAMFSRMANRMAN_TS01.DBF

View 5 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 :: Data Change In Metro Cluster

Oct 21, 2012

Our organization has recently decided to go for storage metro cluster solution for disaster recovery. In a Data guard environment, we normally calculate how much archive log is generating and based on that value we calculate the required bandwidth.

For storage metro cluster, we need to find how much block is changing in our primary database, and the same rate of change would apply on DR cluster. Now, i need to give the assumption how much changing is happening in my system. How to calculate the change.

View 4 Replies View Related

RAC And Data Guard On 11.1?

May 13, 2011

i'm using a mixture of Oracle� Data Guard Concepts and Administration11g Release 1 (11.1) And Bulletin : MAA - Creating a RAC Physical Standby for a RAC Primary 10g ( on oracle support) But neither is comprehensive for what i'm trying to do.

setting up Data Guard Broker on a RAC Data Guard environment?

View 1 Replies View Related

Data Guard Failover

Jan 7, 2011

I am very new to data guard...I have a primary and a physical standby database...If the primary got crashed, are the users directly switched to physical standyby (is it automated) or the DBA has to manually do the fail over or switch over....is it the same concept as in RAC like TAF....How can the DBA know that the users are disconnected from the database.....explain with some steps...

the version is 10.2.0...

View 2 Replies View Related

Oracle Data Guard?

Feb 16, 2012

Log shipping stopped logging/shipping into the Standby Database in one of our Oracle Data Guard Servers about two month ago and there was no change carried out as at that time. The Data Guard has only one Standby database. I have been managing the log shipping and recovery manually.

View 1 Replies View Related

Data Guard :: Implement On Same PC

Apr 5, 2010

I want to implement data guard on same PC.

View 1 Replies View Related

Data Guard :: Upgraded 10.2.0.1 To 10.2.0.4

Sep 25, 2012

I did upgrade from 10.2.0.1 to 10.2.0.4 on the secondary database , the primary database version is 10.2.0.4,i took cold backup from the primary to the secondary database , when i try to create control file on the secondary , i am getting this ORA-01130: database file version 10.2.0.3.0 incompatiable with ORACLE version 10.2.0.1.0.*

Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
PL/SQL Release 10.2.0.4.0 - Production
CORE     10.2.0.4.0     Production
TNS for 64-bit Windows: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

View 2 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 Check Synchronization

May 29, 2011

how to check dataguard synchronization?

View 2 Replies View Related

Data Guard :: Archive Gap Script

Mar 6, 2012

I am working on Data Guard concepts. I have configured Data Guard which is working fine.

Now I am trying to work on script which can give me output on OS prompt if there are any archive gaps..

I tried to use few commands on a script archgap.sh as

archgap.sh
sqlplus "/ as sysdba"
select * from v$archive_gap;

I am trying to run above script on OS prompt as

ABC:/home/oracle>sh archgap.sh

but I am not getting output ... I want it a way that this script should run within interval of 5 min and give output on OS prompt.

View 2 Replies View Related







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