Data Guard :: Oracle 9i - Cannot Mount Database In EXCLUSIVE Mode

Jun 30, 2008

I'm trying to create a physical standby database on my Oracle9i DB runing on WinXP.

Note: I have both Primary and Standby on the same system.

Actually everything went well .... I did created the standby DB but the problem is I can not start my primary DB if my standby DB is mounted. I get this error:

ORA-01102: cannot mount database in EXCLUSIVE mode

And when I read about the error message I learnt that I should start my DB in compatible mode ...

View 5 Replies


ADVERTISEMENT

Data Guard :: ORA-01102 / Cannot Mount Database In EXCLUSIVE Mode

Apr 28, 2003

How i create Standby Database in Same HOST, we using SUN OS 5.8.

I read form Oracle DOC that i can create Standby Database in Same HOST and follow the tutorial , but when i try to mount standby database using ALTER DATABASE MOUNT STANDBY DATABASE EXCLUSIVE; i got a error message ORA-01102: cannot mount database in EXCLUSIVE mode

View 6 Replies View Related

Server Administration :: ORA-01102 Cannot Mount Database In Exclusive Mode

May 10, 2002

I performed Shutdown Immediate in Oracle 8I and now I am unable to mount the database.I'm getting the following message: ORA-01102 Cannot mount database in Exclusive mode/I only have one database running on this machine. It was automatically created by Oracle installer upon installation of Oracle software. I can no longer connect via SQL * Plus,Only through Server Manager (connect internal)

View 8 Replies View Related

Data Guard :: ORA-01154 / Database Busy - Open / Close / Mount And Dismount Not Allowed Now

Sep 21, 2010

I am trying to create the Physical StandBy Database in the same server. Till last 2 Final steps, everything went on well. In the final steps, when I try to open the StandBy Database, it throws the following Error:

*******************************************************
SQL...> alter database open;
alter database open
*
ERROR at line 1:
ORA-01154: database busy. Open, close, mount, and dismount not allowed now
*******************************************************

I tried creating the Physical Standby with the following Steps.

Environment: Oracle Release 10.2.0.1.0 / Windows 2003 Server Enterprise Edition SP2
Primary DB = 'PrimDB'
StandBy DB to be created ='StBy1DB'

In the same Server, location for

PrimDB datafiles='F:oracleproduct10.2.0oradataPrimDBData',
StandBy Datafiles='E:StandBy_DBData'
PrimDB Control Files='F:oracleproduct10.2.0oradataPrimDBControl'
StandBy Control Files= 'E:StandBy_DBControl'

[code]....

Step 1 Create the Oracle Service for StandBy DB "StBy1DB' and Create the Standy DB Password file.

ORADIM -NEW -sid StBy1DB -intpwd passwd -startmode manual

Step 2 Shut down the primary database.

SQL> SHUTDOWN IMMEDIATE;

Step 3 Copy the datafiles to 'E:StandBy_DBData'. (including Temp01.dbf is it Right?)

Step 4 Restart the primary database.

Restart the primary database:

SQL> STARTUP;

Step 5 Create a Control File for the Standby Database (Should this command be given in Mount Status or Open Status?)

From Primary database,

SQL> ALTER DATABASE CREATE STANDBY CONTROLFILE AS 'E:StandBy_DBControlStByControl01.ctl';

Step 6 Prepare the Initialization Parameter File to be Copied to the Standby Database

SQL> CREATE PFILE='E:StandBy_DBPFileinitStBy1DB.ora' FROM SPFILE;

Step 7 Set Initialization Parameters on a Physical Standby Database

db_cache_size=444596224
java_pool_size=4194304
large_pool_size=4194304
shared_pool_size=150994944
streams_pool_size=0

[code]....

Now When I type the following command, it throws an error:

SQL...> alter database open;
alter database open
*
ERROR at line 1:
ORA-01154: database busy. Open, close, mount, and dismount not allowed now

View 2 Replies View Related

Server Administration :: Which Commands Only Can Use In Database Mount Mode

May 3, 2011

which commands only we can use in database mount mode?

View 7 Replies View Related

Data Guard :: How To Find Applied_time In Standby Database Managed Recovery Mode

Sep 10, 2012

How to find applied_time in standby database managed recovery mode (*PHYSICAL STANDBY*).

View 3 Replies View Related

Table Locks In Exclusive Mode

Jan 6, 2011

Under what scenarios do we lock a table in the exclusive mode.

View 1 Replies View Related

Data Guard :: What Is The Most Common Mode

Feb 27, 2012

what is the most common mode in dataguard? maximize protection or maximize availability or maximize performance

View 6 Replies View Related

Data Guard :: LGWR Sync - Maximum Availability Mode

Mar 10, 2013

I have few queries regarding standby database.

1)On primary Database Standby Redo log is required for switchover and on standby database Standby Redo log is required for

--Real time Apply
--Maximum protection or Maximum availability

Am I correct?

2)My database is in Maximum Performance mode. I set up following entry on init.ora:
LOG_ARCHIVE_DEST_2='service=standby LGWR ASYNC'. My question is do I need to have STANDBY Redo log file on standby database in order to use LGWR transport (LGWR ASYNC)mode from primary? Without Standby redo log on standby database can it transport redo data from primary to standby using LGWR transport mode (LGWR ASYNC)?

3)I have changed from the "ARCH" attribute to "LGWR" attribute of the LOG_ARCHIVE_DEST_n initialization parameter. But I have not changed the protection mode. I would like to know whether is there any impact in the behavior of the database, if we do not change the mode from "MAXIMUM PERFORMANCE" to "MAXIMUM AVAILABILITY"?

View 1 Replies View Related

Data Guard :: Apply Redo While Standby Open In Read Only Mode?

Apr 9, 2013

1) If i do changes in table on primary database and if i open standby database in Read-Only mode, i can see those changes immediately only if Real Time Apply is enabled. Am i correct? Database version is 10.2.0.4

2) From 11g, It is possible to apply redo while the standby is open in read only mode. prior to 11g, it was not possible. Right?

3) Should I first cancel Managed Recovery prior to issuing “ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY”?

View 1 Replies View Related

11.2 - How To Mount Oracle Database

Jun 10, 2013

While I was trying to configure an Oracle DB called "NW6" using the Database Configuration Assistant, I have Oracle 11.2 database installed on a Windows 2008 Server, the configuration wizard thrown an error : ORA-01507:database not mounted

So I am not able to successfully complete the DB configuration. Also I tried to test the service using the net configuration assistant, it throws an error: ORA-27101 shared memory realm does not exist.

View 9 Replies View Related

Data Guard :: Apply Patches On Oracle Database With Logical Standby Database?

Apr 22, 2011

I got a primary database with a logical standby database running Oracle 11g. I got two client applications, one is the production site pointing to the primary one, another one is just a backup site pointing to the logical one.Things will only be written into the primary database every mid night and client applications can only query the database but not add, update nor delete.And now, I want to apply the latest patch on both of my databases. I am also the DNS administrator, I can make the name server pointing to the backup site instead of the production one.I want to firstly apply the patch on the logical one, and then the physical one.

I found some reference which explains how to apply patches by adopting "Rolling Upgrade Method". however, I want to avoid doing any "switch over" mentioned in the reference because I can make use of name server. Can I just apply patches as the following way?

1)Stop SQL apply
2)Apply patches on logical standby database
3)let the name server point to the backup site
4)Apply patches on the primary database
5)Start SQL apply
6)Let the name server point back to the production site

View 2 Replies View Related

Data Guard :: Installation In Oracle 10g Database?

Sep 14, 2010

I am planning to use Data Guard facility in Oracle 10g database.

1) I would like to have a standby database, which can be used if the primary goes down and also for reporting and other queries (read-Only).
2) What is the difference between Physical and Logical standby database. I have to explain non-technical users (management) regarding this.
3) What is Sync and Async redo log apply?
4) When i manipulate data (Insert,Delete,Update) in logical standby database, will these changes reflect in Primary database synchronously?
5) Which type of REDO APPLY is better: Managed Recovery Process(MRP) or Real Time Apply(RTA)?
6) can the redo data be deleted if its obsolete or is it deleted automatically by oracle?
7) If i want to take backup, should i take it from primary or standby database? If standby, then the database should be in which mode (Read-only or Recovery Mode)

View 1 Replies View Related

Data Guard :: Oracle Standby Database Recovery

Mar 31, 2011

i have done oracle data guard between two databases (database A is the primary) and (database B is the standby), and it was working fine for two weeks, then the network admin did some changes on the firewall on standby side, which made the primary database can not write on standby redo log , so archives was generated on primary and do not generated on standby by, now we solve the firewall probelm and new archives generated on primary is generated on atandby too, but now i have a gap in archives on standby database and standby database now is not synchronized with primary database, and data changes happen on primary is not reflected on standby, also archives that were generated on primary and did not generated on standby during the problem time is not registered in V$ARCHIVED_LOG neither on primary database nor on standby database

View 1 Replies View Related

Data Guard :: Standby Database With Oracle Standard Edition?

Nov 6, 2012

my customer wants to create a standby database for his production database (Oracle Standard Edition 11g R2 @ Windows 2008 R2 64 Bit). Now any proof-of-concept which explains shortly the concept and how to achieve it.

View 4 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 :: Oracle Application 12.1.1 / Database 10.2.0.4 - Disaster Recovery Site

Aug 18, 2012

We have an Oracle application 12.1.1 running with oracle database 10.2.0.4 and we're using HP-UX itanium 11i v3 servers for both application and database, our requirement is to establish a Disaster Recovery site out of our building to ensure data protection.

What is the best option we can use to reduce the cost and to implement the DR site? can we use data guard ? and will be the configurations and requirements for it?

View 9 Replies View Related

How To Mount A Database From Dbf And Ctl Files

May 20, 2013

I recovered dbf and ctl files, how to mount that database again. Using oracle 9i.

View 1 Replies View Related

Data Guard :: Flashback Snapshot Standby Database Or New Primary Database After Failover?

Aug 30, 2013

If flashback is enable in physical standby database 1. If we failover at 11AM can I flash back NEW primary database to 6 AM ? 2. if I convert physically standby database to snapshot standby database at 11AM ,  Can I  flashback snapshot standby database to 6 AM and do some works on it (DML operations)  then   converting the snapshot standby database into physical standby database ?  

View 1 Replies View Related

Data Guard :: Creating Standby Database From Active Database Using RMAN

Dec 21, 2012

creating the standby database from Active database using RMAN and getting the below issue after i executed the duplicate command.

Version of Database:11g(11.2.0.1.0)
Operating System:Linux 5
Error:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 12/21/2012 17:26:52
RMAN-03015: error occurred in stored script Memory Script
RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
[code]....

provide any work arounds to proceed further in creating the standby database.

View 1 Replies View Related

Data Guard :: Switch (convert) Primary Database To Standby Database?

Jan 30, 2013

I have installed oracle 11g standard edition one and created both primary and standby database. now i want to know how to switch(convert) primary database to standby database.

View 8 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 :: Registering Primary Database To Catalog Database

Oct 9, 2012

Here we have a data guard environment with db1(db_unique_name) as primary and db2(db_unique_name) as physical standby database. Also we configured one schema on a third machine as catalog database using following steps. The steps executed in catalog database(appsdb):

SQL> create tablespace rmancatlog_tbs datafile '/u01/app/oracle/oradata/NEW/rman_catalog.dbf' size 500M autoextend off extent management local segment space management auto;

SQL> create user rman identified by oracle
2 default tablespace rmancatlog_tbs
3 quota unlimited on rmancatlog_tbs
4 ;SQL> GRANT connect, resource, recovery_catalog_owner TO rman;

RMAN> create catalog;
recovery catalog created

Added tns entries of catalog database in primary and standby. Then from primary database we tried to register to catalog database. It is showing that it is registering. But every query afterwards in rman is throwing the error. Below are the steps and error:

[oracle@db1 ~]$ rman target sys/oracle catalog rman/oracle@appsdb
Recovery Manager: Release 10.2.0.3.0 - Production on Mon Aug 13 21:39:32 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: NIOS (DBID=1589015669)
connected to recovery catalog database
[code]....

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

RMAN :: Oracle Recovery Catalog Database In Primary And Standby Mode

Jul 9, 2013

The customer wants the RMAN recovery catalog database to be highly available so that none of the RMAN database backup jobs are impacted at the time of taking the database backups. There are are 200+ databases running on OEL, RHEL and Windows. So we planned to host the recovery catalog database on Oracle Active DataGuard 11.2.0.1 Enterprise Edition on RedHat EL 5.8 version on two physical servers.

The Primary Instance will be in one server in the Primary DC and the Standby Instance will be on another server in another DC. Also all the database datafiles are hosted in ASM Diskgroups on SAN (DATA, FRA, REDO, ARCH diskgroups). Are there any specific RPM/patch/OS user custom/specific settings or configurations needed..?

View 5 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 :: 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 :: Replication From Many To Single Database

Jan 12, 2011

I have a clients who currently implementing an application that using Oracle 10g in 20 distributed location. Each location will have its own database server and locally managed. I plan to create a Disaster Recovery (DR) Centre for this client in centralised location. I plan to setup 20 Application Server but only one database server with 20 instances. My question, can the Dataguard manage the replication between 20 database (with single instances) and single database (with 20 instances? The reason we design such way is to reduce the license cost of Oracle.

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







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