Data Guard :: Configure Non-RAC DG For RAC Instance
Jun 13, 2011
We are in project design phase and following is the hardware setup:
Database (2 node RAC)-Solaris 10
Application server server (2 server) -Solaris 10
Web server (2 server for Failover)= RHEL
For DR
Database (1 node)-Solaris 10
need to know
1.What are the best practice to implement and to configure DR as Non-RAC physical standby for RAC database server.
2.What are implication if we go for single node except failover node unavailability for DR.
3.What are the steps of Switchover in this case.
4.What's the recommended backup solution for 8-10 Terabyte database
View 1 Replies
ADVERTISEMENT
Jul 1, 2010
Is it possible to use oracle dataguard from single instance to RAC instance ? Does Oracle dataguard support this ?
View 1 Replies
View Related
Mar 29, 2011
I am trying to configure physical standby(s) across two boxes. I am getting the errors
ORA-12154: TNS:could not resolve service name
ORA-16055: FAL request rejected
I am able to communicate between the two servers, tnsping both of them, sqlplus to each of the instances, but getting the TNS issue.
Tue Mar 29 13:21:55 2011
ARC0: Evaluating archive log 6 thread 1 sequence 73594
ARC0: Destination LOG_ARCHIVE_DEST_2 archival not expedited
ARC0: Beginning to archive log 6 thread 1 sequence 73594
Creating archive destination LOG_ARCHIVE_DEST_3: '/tmp_archive_dest/DLXMTY/arch_
DLXMTY_1_73594.dbf'
Creating archive destination LOG_ARCHIVE_DEST_1: '/archives/DLXMTY/arch_DLXMTY_1
_73594.dbf'
[code]....
View 1 Replies
View Related
Jul 17, 2012
step by step procedure to configure physical standby database.....
i have to create on windows not in linux...so simple step by step procedure,once configured it should be up and running;
View 3 Replies
View Related
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
Jan 18, 2011
i want to configure my present Data Guard Setup with Enterprise Manager...and on the Enterprise Manager grid control page i am not seeing any Data Guard option.....i am using oracle 10gR2 and Windows XP.
How to use enterprise manager for configuring Data Guard.
View 9 Replies
View Related
Jul 13, 2010
We are planning to change the dbname from appr to apdr. Its a DR (Standby Database).
a. NID option will work for this? - DB in mount state (Standby db)
b. Is that possible to change the Instance name also?
c. Any Prerequsities and postrequirments for this change? (ie,Data Broker, communication with Primary and Standby etc?
Oracle 10g, OS - Sun Solaris
View 2 Replies
View Related
Feb 17, 2011
There is a Single Instance production server Oracle 9iR2 [9.2.0.8] OS HP-UX PARISC 11i v1 to RAC.
Now we want to migration this server with minimum downtime to Oracle 11gR2 [11.2.0.2] in RAC environment OS HP-UX 11i v3 Itanium DOwn time must be minimum. what will be the procedure ?
View 6 Replies
View Related
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
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
Jul 24, 2012
I am not able to find any document that shows steps to create a SINGLE INSTANCE LOGICAL STANDBY database for a 2 NODE ORACLE RAC database. I have found documents for RAC to Single Instance Physical standby database. But not for Logical Standby.
Details:
OS: Redhat 5
DB: 10.2.0.4(shared file system, not using ASM/Standby also file system)
Status: Single instance physical standby database created, need to convert it to Logical standby.
View 11 Replies
View Related
Nov 29, 2011
I have a requirement to change the instance parameter of the primary database and standby in the data guard. Any procedure to do the same. I have to do it directly on production and there is no test set up so I cannot experiment . The procedure I am thinking of is as below.
1. Stop the standby
2. backup the primary
3. Change the parameter and restart to make it effective
4. Start the primary
5. Go to stand by
6. Change the parameter and mount the database.
7. Check if both are in sync and apply logs if not.
View 6 Replies
View Related
Mar 27, 2013
I am using Oracle RAC 11.2.0.3 as primary database, we are going to start using Oracle data guard. So I am designing my infrastructure and planing to use Oracle 11.2.0.3 Single instance as my physical stand by database.
My question is it feasible to have my standby database as single instance while the primary is RAC? is it feasible to build my Oracle single instance standby database from the RMAN backup of the RAC primary database? Is there any restrictions (or any points to be taken into consideration) since my primary database is RAC while the physical standby is Oracle single instance?
in the below link
[URL].......
it was mentioned that primary can be RAC or single and same for standby, but my question is it feasible to have primary as RAC while standby as single instance? or it should be like each others?
The primary database can be either a single-instance Oracle database or an Oracle Real Application Clusters (RAC) database. Similar to a primary database, a standby database can be either a single-instance Oracle database or an Oracle RAC database.
View 7 Replies
View Related
Dec 12, 2010
I've checked ALL the parameters. It seems to be OK.The db is running and OK.But when I try to configure the EM I get the following error Says that the databse instance is not available.But, tnsping works ok, and I can connect as sys without problems. the DB is OK.
EMCA iniciado en 12-dic-2010 12:54:17
Asistente de Configuraci¾n EM, Versi¾n 11.2.0.0.2 Producci¾n
Copyright (c) 2003, 2005, Oracle. Todos los Derechos Reservados.
[code]....
View 3 Replies
View Related
Mar 2, 2013
I am trying to configure a new ASM instance. I am getting error " -bash: crsctl: command not found" .. where should i actually look for the error. crsctl command not found.... I am doing this as a root user .
View 5 Replies
View Related
Dec 11, 2012
How to configure Oracle EM with newly created Oracle Instance on Oracle 10g DB,which is Single Instance DB but not RAC ,when I start the Oracle EM it is starting the default DB which created during Oracle Server Installation.
View 0 Replies
View Related
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
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
Jul 21, 2011
Is there any document out there for OEM11gR2? Particulary how to configure/clean up unwanted old data within OEM repository.
View 1 Replies
View Related
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
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
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
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
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
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
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
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
Mar 16, 2011
My context on our servers is the following one:
- one ASM instance
- X DB instances
- each DB instance uses 2 or more dedicated diskgroups from the ASM instance
- there is one diskgroup named FREEDISK that contains spare disks
On each DB instance you can see:
- the list and global parameters of all diskgroups using v$asm_diskgroup view
- the list and parameters of all disks the instance is using with v$asm_disk view
So my question is: how (if this is possible) to know the list of (spare) disks in FREE DISK disk group?
View 6 Replies
View Related
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
Jul 3, 2013
I'm basically experimenting with the concept of replicating data from one instance to the other. Using this thread as a guide, I was wondering if I could create a service on an Apex 4.0 instance, and have an application apex.oracle.com consume that service?
View 0 Replies
View Related