Data Guard :: Is It Necessary To Shutdown Primary And Then Copy Datafiles

Sep 15, 2013

im on 11G R2 database on linux 5.4, while configuring a physical standby from scratch, remember i dont want to use RMAN,  when i copy datafiles from primary to standby, is it necessary to shutdown primary and then copy datafiles ? or i can use SCP command and copy even though primary is up in read write mode?

View 4 Replies


ADVERTISEMENT

Data Guard :: Shutdown Down In Primary Database In Environment

Jun 29, 2010

I have configured data Guard on oracle 11gR2. It is working fine. The only issue i am facing is that when i am stopping the database on the primary server, it is taking a long long time to down the database.

Is it normal?

Furthermore, regarding backup i used veritas Netbackup to perform hotbackup. Can i still used the same principle.

View 3 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 :: Changing Primary DB Password?

Dec 16, 2011

I've 2 DB : One primary and One physical standby. I want to change SYS password on primary DB. Can I do it without any action on standby DB side ? If not, give me a step by step details to perform this action properly.

View 4 Replies View Related

Data Guard :: Delete Datafile In Primary?

May 26, 2012

I haved drop a datafile on Primary,and the archived log has transported to Standby,but the datafile is still exist in Standby.

Primary

alter tablespace tps_hxl
drop datafile '/u02/app/oracl/oradata/hxl10.dbf';

View 7 Replies View Related

Data Guard :: How To Manually Set Database_role To PRIMARY

Dec 11, 2010

I am getting error ORA-16816: incorrect database role. The reason is my switch over to standby become failed and now both primary and standby databases showing 'database_role' as 'Physical Standby'.My question is how to manually set 'database_role' to 'PRIMARY' on primary database.

--------------------------------------------
DGMGRL> show configuration
Configuration - dgproj
Protection Mode: MaxPerformance
Databases:
repl - Primary database
Error: ORA-16816: incorrect database role
dgrepl - Physical standby database
--------------------------------------------

View 8 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 :: Refresh Primary Using Standby Database?

Feb 2, 2013

I was using physical standby but my primary database had had some HW issue.So I had activated standby database to handle production.During 3 months, standby database was our live database and our old primary was unavailable.Now HW issue on primary has been fixed.And I want to set again my old configuration : means set primary and standby db.

I'm trying this :

1) check the SCN on old primary

2) Rman incremantal backup from scn

3) on primary db : catalog

4) on primary db : recover database noredo

View 1 Replies View Related

Data Guard :: Primary Not Open After Standby Configuration

Jul 19, 2011

I did standby before and it works wighout any disturbations and even configuration seems to me not very complicated - but it was before. now i am trying to do standby configuration once again. there is database named DESK.

two physical serwers:
sczepl-db07 - primary
r00979 - standby

on each for this serwer there is listener listening on port 1521, and on each is tnsnames configured properly:

for sczepl-db07
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sczepl-db07)(PORT = 1521))
[code]....

so why primary don't see standby db and claims that ther is no standby service? i proved that there is connection primary <--> standby.

View 21 Replies View Related

Data Guard :: Copying Archived Log File From Primary To DR

Sep 21, 2011

1) How to copy the ARCHIVED LOG FILE from Primary to DR location. Where if the DR is having the file already, how to SKIP that Particular Archived log file?
2) I have Checked with the FILE_TRANSFER DBMS package, but it gives the error if any file existing already.

View 2 Replies View Related

Data Guard :: Changing Password On Primary Database?

Nov 10, 2011

I'm using 2 databases : Primary and Standby DB. It working fine. I've just one question : I want to change SYS password on primary DB. Can I change it without any action on Standby DB?

View 8 Replies View Related

Data Guard :: App Archive Logs Which Come From Primary Database?

Feb 16, 2012

If my standby database is read only mode,does it can app the archive logs which come from primary database?

View 2 Replies View Related

Data Guard :: One Primary And 2 Physical Standby Databases

Sep 29, 2010

I have one primary database and one physical standby database on my data guard environment.

Now i want one more physical standby database in my data guard environment, meaning i want 2 physical standby. since this is a production environment, i need to take great care. However, downtime will be mandatory.

[u]init.ora for production:[/u]

pup2.__db_cache_size=6241124352
pup2.__java_pool_size=33554432
pup2.__large_pool_size=134217728
pup2.__oracle_base='/oracle/app/oracle'#ORACLE_BASE set from environment
pup2.__pga_aggregate_target=5771362304
[code]......

init.ora for my first primary standby

pup2.__db_cache_size=6509559808
pup2.__java_pool_size=33554432
pup2.__large_pool_size=67108864
pup2.__oracle_base='/oracle/app/oracle'#ORACLE_BASE set from environment
pup2.__pga_aggregate_target=5502926848
[code].......

View 5 Replies View Related

Data Guard :: Upgrade Primary And Standby Database?

Apr 30, 2012

I have a primary and standby DB using data guard 10.2.0.3.I want to upgrade oracle to 11G.I know that primary and standby should have same version even if data guard will not work again.I want to know what is the steps by steps action to properly upgrade both DB : primary and Standby.

View 1 Replies View Related

Data Guard :: Change Some Parameters On Primary Database?

Sep 29, 2012

I am going to change some parameters on primary database (db cache, java pool etc.). I am not sure, if the changes are automaticallly propagated to standby or if I have to make the changes manually on stanby site too? I couldn't find clear answer in documentation. how parameter changes work in dg physical configuration?

View 2 Replies View Related

Data Guard :: Upgrade Stand By To Primary Version

Feb 6, 2013

Mistakenly I have configure dataguard on different versions. Primary is 11.2.0.3.0 and Stand By is 11.2.0.1.0. Log shipping is perfectly working, but cannot put Stand By in read only mode.

View 3 Replies View Related

Data Guard :: 11.1.0.7 RAC Primary To Single Instance Standby Using 11.1.0.6

Mar 2, 2011

Primary:

2 NODE RAC Cluster/Linux x86-64/11.1.0.7.4 RDBMS

Standby server:

Brand new box, and I installed 11.1.0.6 (software only)

I have a brand new box set-up for a single-instance standby database, and I have installed 11.1.0.6 software only.

Do I need to patch 11.1.0.6 to 11.1.0.7 before I send a copy of the primary over to be set-up as a standby? If so, how do I patch 11.1.0.6 without having a local database in place as this server will only be used for a standby? Can patching the oracle_home only be done?

View 2 Replies View Related

Data Guard :: Maintain Replicated Copy Of Database In Remote Office

Feb 18, 2011

I was considering a solution to maintain a replicated copy of a database in a remote office. However we are using SE One edition of oracle, so native support for dataguard is not available. There definitely should be some scripting solutions for this task, but I can't find any to date.

View 7 Replies View Related

Data Guard Switchover - Broker Cannot Restart Primary Instance

Nov 22, 2011

I am fairly new to Oracle and have recently started learning the basics of Data Guard. I have set-up a Primary 11g database which successfully ships and applies logs to a Single Standby (on the same server) as expected. Manual switchovers work fine; however, I have found a slight problem when performing switchovers using the Data Guard Broker utility.

The switchover is successful- but the broker cannot restart the Primary instance. The strange thing is that when I perform a switchover in the opposite direction (i.e. the new Primary goes back to standby again) it works fine. The error is receive is: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.

The majority of posts I have seen on this topic seem to point to incorrect listener / tnsnames set up but they have exactly the same values. If both databases are identical, why does it work one way but not the other? I will provide any necessary files to pinpoint where the issue could be.

View 5 Replies View Related

Data Guard :: Changing Redo Log Folder On Primary Database

Mar 3, 2012

I want to replace one redo log on the primary database. actually this redo log is on G:oracleoradata; I want to move it on F:oracleoradata. How to do that cause the same redo log is also on standby database?

View 3 Replies View Related

Data Guard :: How To Convert Primary Control File For Standby

Dec 29, 2009

I try to recover standby db from a primary db backup set,but the standby control file is different.

to create primary controlfile by rman:
backup control file format '/home/cur_control';

to create standby controlfile:
backup control file for standby format '/home/std_control';

I want to know if there is method to convert cur_control to std_control.

View 3 Replies View Related

Data Guard :: Switchover From Physical Standby To Primary Fails

May 9, 2010

i have a db's in maximum protection mode and i am trying to perform a switchover of physical standby database to primary role. but it failed., the steps followed is as follows. everything is fine with old primary site and the it is now in mounted state. When I went through the log file, I got the error message as "ORA-16072: a minimum of one standby database destination is required".the standby_archive_dest is as follows.

old primary database

SQL> alter system switch logfile;
SQL> alter system archive log current;

old standby database...Disconnect the managed recovery mode in Standby database.

SQL> recover managed standby database cancel;
Media recovery complete.
SQL> recover standby database;
AUTO
SQL> exit
[code]....

View 1 Replies View Related

Data Guard :: Check If Database Encrypted Or Not On Primary / Standby?

Jul 25, 2013

We have a primary and a standby (Physical Dataguard) site.

1. How do i check if the database is encrypted or not on primary as well as standby ?
2. If primary and standby are encrypted, does the data that gets replicated from primary to standby also in encrypted form ? If not, does it make sense to encrypt that ?

View 2 Replies View Related

Data Guard :: Take Clone Primary Database At Specific Time?

May 29, 2013

Can we make Data Guard to take clone Primary Database at Specific Time?

e.g. Clone Primary Database at 10 AM and at 6 PM?

View 10 Replies View Related

Data Guard :: Find Archive Log Gap From Primary Database Site?

Mar 23, 2013

I am new to Oracle and a beginner in Data Guard.

1) How to find archive log gap from Primary Database site?
2) Do I need the DB_UNIQUE_NAME when setting the LOG_ARCHIVE_DEST_2 ? What is the purpose of DB_UNIQUE_NAME in LOG_ARCHIVE_DEST parameter?
3) If archivelog gap happens standby db goes out of sync with the primary database. What does out of sync actually mean?
4) Primary DB knows where to transport redo data based on the location mentioned in LOG_ARCHIVE_DEST_n of Primary DB. Am I correct in my understanding?

View 3 Replies View Related

Data Guard :: Running Observer On Different OS As Compared To Primary And Secondary DBs

Jan 28, 2013

Primary RAC and Standby RAC databases are using version 10.2.0.4. They are configured & controlled via Data Guard Broker. Currently, the observer runs from one of the Standby nodes. All are on Solaris x86 64bit OS version 10.

Now, I have to move Observer to 3rd DC and I am looking If I could use another OS for observer instead of same as DB OS version. Why? Our new infrastructure is on RHEL Linux, therefore, I would like to deploy observer once and then wait for existing databases to be upgraded and moved to RHEL. Also, i understand that database and observer software should be of same version e.g. 10g, 11g.

My question is what if i install & configure observer on RHEL ? The end result would be:

1. Primary DB: Solaris 10, Oracle Software binaries version 10.2.0.4
2. Secondary/Standby DB: Solaris 10, Oracle Software binaries version 10.2.0.4
3. Observer: RHEL 5.8, Oracle Software binaries version 10.2.0.4

Is it accepted mix configuration say e.g. to run for six months? Also, it would be grateful to know if there any license implications when running observer on a different node running no databases at all.

View 2 Replies View Related

Data Guard :: Configuring Primary For A Failover (alternate) Remote Destination?

Aug 2, 2012

I have a situation where I want to configure primary database (11.2) with 2 remote destinations. dest_2 is the default and points to a standby on host_2. However, I also want the primary db to continue transporting redo to dest_3 on node_3 when node_2 is taken down (planned or unplanned).

1) Configure the ALTERNATE attribute of dest_2 to point to dest_3.

2) Configure tnsnames client-side failover on primary host to point to 2 nodes (node_2 and node_3).

View 1 Replies View Related

Data Guard :: Convert Snapshot Database (standby) Directly To Primary?

Dec 16, 2012

(Oracle 11gR1 OEL 5)Is there any possibility to convert snapshot database (standby) directly to Primary. Instead of manual switchover I want to do this

I have checked that snapshot creates a guaranteed restoration point which reverts back changes in Standby.

View 3 Replies View Related

Data Guard :: Logs Get Shipped But Not Applied - Due To Primary Database Reset

Jul 22, 2013

I have a Sap Primry Database and also a standby db that was working perfectly.. We migrated the primary db from windows 2003 to windows 2008 and brought the primary db up.. I had to create a controlfile and do a system copy and had to reset the logs on the Primary.. All came up and when i checked the standby it was receiving the logs but after a month. i see that it was not applying the logs as I think because of the sequence number .. it stopped.

I did the ffg as per the attachement...My logs have been shipped across but not applied, But What worrries me is the log sequence number on my Primary

SQL> select max(sequence#),thread# from gv$archived_log group by thread#;

MAX(SEQUENCE#) THREAD#
-------------- ----------
27727 1

View 15 Replies View Related







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