Auto Startup Active DataGuard After Reboot

Apr 6, 2011

I try to auto startup my standby database after reebot machine. I used trigger " on startup" , srvctl but still it doesn't work..Database 11g , operating system RedHat 5 or HP-UX.

View 2 Replies


ADVERTISEMENT

Active Dataguard Database

Jul 17, 2013

I've got a physical standby database and I'm now licensed for Active DataGuard. I would like to automate the ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION command to be executed right after the STARTUP command so that whenever the database is started by our DBSTART script, it activates READ ONLY W/APPLY immediately after start without manual intervention. This is probably simple, but I figured I'd ask before starting to pore through documentation.....!

View 6 Replies View Related

Recovery Manager (RMAN) :: Duplicate On Active Dataguard Physical Standby

Feb 8, 2013

In DR site. i have to clone the database from pshysical standby database and clone db will be normal db not standby. Is it possible to do rman duplicate from active dataguard? will it support the duplicate database from active database or i have to take the rman backup of standby database and duplicate from backup piece.

View 2 Replies View Related

Standby Auto Startup On OEL 5

Sep 14, 2012

I have to make this script . It should be something like this :

starting of lsnrctl.......
startup mount;
alter database open read only;
recover managed .....................;

and a second script is to shut down everything correctly during Linux shutdown..I think it would be better to make a new Linux service . make a whole script? Oracle 11.2, Oracle Linux 5

View 2 Replies View Related

RAC & Failsafe :: How To Set Auto Startup When OS Start

Mar 24, 2012

I have installed a rac database,when the os start,and the database can not auto start,how to make the database auto start when OS start?

View 1 Replies View Related

RAC & Failsafe :: Two Nodes Active / Active Configuration

Oct 15, 2013

I am getting starting with rac environments. I need to configure a two nodes active/active with rac and I need to know if always using rac both nodes will be active or if I have to do that at some point when installing. I have reading some docs from oracle and others authors about rac and its configuration process but that is not understood for my yet.

View 5 Replies View Related

Backup & Recovery :: RMAN Backup Strategy For Active-active Deployments Using Streams

Jul 25, 2012

We are using oracle as database in our application. For high availability we have a cluster of multiple nodes and the data is replicated using oracle streams. All the nodes in the cluster are active. We do not have any concept of stand-by.

Now we are planning to use oracle RMAN for backup and recovery. RMAN user's guide doesn't recommend any strategies for such deployments. It mainly focuses on primary/stand-by deployments.

View 1 Replies View Related

Windows :: Oracle Not Available After Reboot

Oct 16, 2010

my problem is

Sir, i have installed oracle8i successfully on my computer but when i reboot my computer & try to run SQL by using username:- system & password:- manager or scott/tiger i get message "Oracle not available".

im insert the after its working connection of data base

SQL> conn /as sysdba
Connected to an idle instance. (after)
SQL> startup mount
ORACLE instance started.

Total System Global Area 569496844 bytes
Fixed Size 70924 bytes
Variable Size 165638144 bytes
Database Buffers 403709952 bytes
Redo Buffers 77824 bytes
Database mounted.
SQL> alter database open;

Database altered.

SQL> alter user system identified by manager ;

User altered.

SQL> conn system/manager
Connected.

so this is process follwing is working but system is restart its not working...

View 1 Replies View Related

Server Administration :: Reboot DB For Better Performance?

Apr 20, 2011

question about DB, i wanna know if the DB performance will be better after the reboot of this db

View 12 Replies View Related

Queueing :: Propagation Not Working - Only After Reboot?

Sep 7, 2012

I migrated an AQ solution which sends messages between three instances from a development environment to an UAT environment and my propogation from one instance to another is not working as per development.

When I enqueue a message I note that the enq_time is one hour behind the actual sysdate.

All the messages are been stored in the queue table and are propogated through only when the instance is restarted.

FYI - the datbase is 11i Express.

The progration job is:

dbms_aqadm.schedule_propagation(queue_name => 'ITEMS',
destination => 'DIBS_MSG_DIBS_EXT'
,start_time => sysdate
,next_time => 'sysdate + 100/86400'
,duration => 60
,latency => 3000
,destination_queue => 'DIBS_STREAMS.ITEMS');

View 5 Replies View Related

ORA-01115 - ORA-01110 - Cannot Access Dbs.after Reboot Server Only Db?

Jul 22, 2012

After getting the following error ,Our production oracle db server is crashed,we cant access the dbs.after reboot the serveronly we can access the db,

ORA-01115: IO error reading block from file ORA-01115: IO error reading block from file 83 (block # 639938)
ORA-01110: data file 83: '/oradata/prod/prod_data04.dbf'
ORA-27091: unable to queue I/O
ORA-27072: File I/O error

[code]...

View 3 Replies View Related

RAC & Failsafe :: Oracle Server Reboot - IP Ping Failed

Jun 20, 2011

Every time interconnect IP ping failed between RAC servers,CRS causing reboot to the server. As documented,it is of 3 sec. Can we alter this setting to increase the ping failed (private IP) by more than 3secs.

View 4 Replies View Related

Performance Tuning :: DB Import Too Slow After Server Reboot

Jul 4, 2011

Few days ago, My database server no access to StorageBox then I reboot it then after works fine. But, know DB import process is too slow. Before 100GB DB import process completed within 10 hours when server normal running. Now 2 day working, but not complete

How to investigate this issue? Maybe I miss increase some parameters on the Server or Oracle?

Here is my server brief info:

RAM is 16GB,
SWAP size is 16GB,
CPU 12 cores

SQL> show sga;

Total System Global Area 4294967296 bytes
Fixed Size 1984144 bytes
Variable Size 369105264 bytes
Database Buffers 3909091328 bytes
Redo Buffers 14786560 bytes

View 11 Replies View Related

Real Application Clusters :: DB Not Coming Up Along With Crs After Node Reboot?

Oct 2, 2013

Grid Version: 11.2.0.3 OS: Red Hat Enterprise Linux 5.6  Node2 of our two node RAC got rebooted. Upon reboot, CRS and ASM instance came up. But the DB didn't come up.  How can I check if DB is linked to CRS startup ?How can I enable DB startup upon CRS startup ?

View 3 Replies View Related

Enterprise Manager :: Disable DB Console To Start On Server Reboot

Feb 20, 2012

$emctl stop dbconsole stops the OEM process.

however,it starts back up on server reboot,how can we prevent that is emca deconfig the only option?

View 6 Replies View Related

Server Administration :: Clone Database Cannot Be Connected After System Reboot

Oct 21, 2010

1. I installed oralce with Service_Name=DB1 it works fine,

2. I created another database with dbca named DB2,

3. I connected both system/password@db1 and system/password@db2 without any problem,

4. After rebooting the computer I can connect only the first database DB1 which I installed with Oracle installation. But, I can not connect to the 2nd database which I created with dbca. Error Message Shows: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

DB1 has no problem I can connect to that, but I can not connect to DB2 after rebooting the system. Now I need to know how to connect to DB2.

Quote:

connection messages:
oracle@pc ~]$ sqlplus
SQL*Plus: Release 11.1.0.6.0 - Production on Thu Oct 21 12:51:43 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter user-name: SYSTEM@DB1
Enter password:

[code]....

View 9 Replies View Related

RAC & Failsafe :: Can't START Instance After Apply Critical Patch And Reboot

Apr 21, 2011

This is 2 node RAC database. Usually every month my system admin was applying OS critical patch then reboot the server.

While doing this activity i have stop all CRS and DB services. As usual i have did same in both the nodes and applied the patch and reboot the server.

After tried to start the CRS service and database services was used the following command. Except node1 instances all services are started.

E:oraclecrsproduct11.1.0crsBIN>crs_Stat -t
Name Type Target State Host
------------------------------------------------------------
ora....main.db application ONLINE ONLINE inf-...b-03
ora....n1.inst application ONLINE OFFLINE
ora....n2.inst application ONLINE ONLINE inf-...b-04
ora....SM1.asm application ONLINE ONLINE inf-...b-03

[code].....

Then i have tried to applied to old ocr backup also, then also i am getting same error.

View 1 Replies View Related

RAC/ASM Clusterware Installation :: Installing 10.2.0.1 Database Binaries Machine Reboot?

Dec 7, 2012

I am installing RAC on my Laptop using VM ware workstation . I have created two linux machines on VM ware with 1 gb merory on each machine . I installed 10.2.0.1 clusterware successfully but when i am installing 10.2.0.1 database binaries my machine reboot every time .

View 3 Replies View Related

SQL & PL/SQL :: How To Configure RAC TO RAC Dataguard

Apr 27, 2012

i want to configure rac to rac dataguard 10g( primary is having 2 nodes and standby also 2 nodes).

oracle 10g/os linux5.

View 1 Replies View Related

Dataguard Log Query

Dec 3, 2012

This is my dataguard check script:

/home/oracle/bin/check
if [ $# -lt 1 ]; then
echo "usage: check <oracle_sid>"
echo
exit
fi

[Code]...

This is the output it gives on the primary:

INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_T STATUS PARTHREAD# ARCHIVE LOG_SWITCH_WAIT
----------------- --------- ------------ --- ---------- ------- ---------------
LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO
---------- --- ----------------- ------------------ --------- ---
1 prod
xxxx
11.2.0.3.0 29-NOV-12 OPEN NO 1 STARTED
ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO

[Code]....

SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

This is the output it gives on the standby:

INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_T STATUS PARTHREAD# ARCHIVE LOG_SWITCH_WAIT
----------------- --------- ------------ --- ---------- ------- ---------------
LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO
---------- --- ----------------- ------------------ --------- ---
1 prod_stby
xxxx
11.2.0.3.0 29-NOV-12 MOUNTED NO 1 STARTED
ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO

[Code]....

SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

When I run the following:

SQL> select archivelog_change#-1 from v$database;

On the primary I get:

ARCHIVELOG_CHANGE#-1
--------------------
4902447998

On the standby:

ARCHIVELOG_CHANGE#-1
--------------------
4902447999

Which makes sense to me as my understanding of this is that the log is written, send to the standby, applied, then applied on the primary, yes?

So my questions are:

Why is there a lower entry on the primary (234) marked as opening, when it's closing 235, and writing 236, what does LNS mean?

Why is the second archive on the standby saying "CONNECTED 0" and do RFS, & MPR0 mean?

My init files say this:

Primary:
log_archive_dest_1='LOCATION=/u01/archive/prod/arch'
log_archive_dest_2='SERVICE=prod_stby LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=prod_stby'

Standby:
log_archive_dest_1='LOCATION=/u01/archive/prod_stby/arch'
log_archive_dest_2='SERVICE=prod LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=prod'

Geek, scruff, economics wonk, a mind forever voyaging.

View 4 Replies View Related

Uses Of ORAPWD In RMAN And Dataguard

Aug 29, 2012

I know the uses of ORAPWD utility and REMOTE_LOGIN_PASSWORDFILE initialization parameter.I wish to know that, what will be the primary purpose of using ORAPWD passwordfile in the following situations.

1. RMAN Cloning.
2. Dataguard Standby configuration.

View 4 Replies View Related

DataGuard - Standby Redo Log Files

Sep 3, 2012

What is the purpose of Standby Redo Log Files in Data Guard configuration? When it is utilized by the database?

View 4 Replies View Related

SQL Script Validation For Use In Dataguard Environment?

Feb 21, 2013

We have a 10g environment with DataGuard running for reporting purposes. Our application team is getting ready to upgrade their application and it requires that several SQL Scripts be run to perform the primary database updates. A couple of them are over 1 MB in length. My concern is that these scripts will break DataGuard. I am not a DBA by any stretch, but I seem to remember there are certain limitations with DataGuard.

I have reached back to the team and asked them to have the Vendor confirm these scripts are validated for a DataGuard environment and I have also reached out to the System DBAs for review. I am wondering if there is an utiility available that can check the SQL to confirm if there are any DDL or DML statements that will not work in DataGuard. Likewise, we are going to run these scripts in a non-production DataGuard enabled environment first, but I want to have some level of confidence, that this will be a success.

View 3 Replies View Related

Dataguard Setup Primary And Standby

Dec 2, 2011

I have a dataguard setup, a primary and a standby.my instance is testdb.i have set all necessary dataguard parameters and everything seemed to work well initially with logs being moved from primary to secondary and being applied there.but all of a sudden i see that the primary pushes logs to the standby and at the standby end these logs are available but not applied.

when i try to execute the: alter database recover managed standby database cancel; it hangs for a long time and never returns to sql prompt.

i bascially want to stop and restart the MRP process to apply the logs but cannot cancel the managed recover mode.Is it advisable to kill the mrp process at os level using "kill -9 "?

View 7 Replies View Related

Exadata :: Configuring Dataguard With DR Server And DBM

Oct 10, 2012

Refer a MOS Note for configuring data-guard on Exadata with DR server being and Exadata DBM too.

View 4 Replies View Related

Dataguard / Logs Not Shipped To Standby With Error

Oct 26, 2010

I have two Oracle 10.2.0.4 databases, on two SUN M5000 (Solaris 5.10). One is primary (EXP1), the other is the standby (EXPBKP). Both SID is 'EXP'. If I do a manual recover (after I sync'ed primary archive logs from primary to standby), it works. If I do a manual log switch, logs are shipped AND applied on the standby. But after a while, I can see some errors on primary alert log , and logs are not shipped anymore :

CODE Errors in file /applications/oracle/admin/EXP/bdump/exp_arc2_1277.trc:
ORA-03135: connection lost contact
Tue Oct 26 08:30:14 2010
FAL[server, ARC3]: FAL archive failed, see trace file.
Tue Oct 26 08:30:14 2010
Errors in file /applications/oracle/admin/EXP/bdump/exp_arc3_1279.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing
[code]....

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

ORA-01109 - Setup 11g Dataguard - Physical Standby

Jul 12, 2011

I have setup 11g Dataguard - physical standby. Everything seems to be fine. I have also tested switchover and failover using DG broker which seems to work fine.All, I would like to know is abt ORA-01109 during switchover..

My config - RACprim- RACstby
Primary - TEST_prim (instances - TEST1, TEST2)
Standby - TEST_stby (instances - TEST1, TEST2)

DGMGRL> SWITCHOVER TO TEST_stby;
Performing switchover NOW, please wait...
New primary database "TEST_stby" is opening...
Operation requires shutdown of instance "TEST1" on database "TEST_prim"
Shutting down instance "TEST1"...
ORA-01109: database not open
[code].....

This ORA error occurs when it tries to shut down primary. When primary is in open state, why its saying that database not open. Operation requires shutdown of instance "TEST1" on database "TEST_prim"..Shutting down instance "TEST1"..

View 4 Replies View Related

Process To Refresh Schema In DataGuard Enabled Environment

Feb 21, 2013

We have a non-production Oracle 10g Cluster running on Linux, with DataGuard (logical standby). From time to time, we need to refresh the schema on primary, but to do so as always caused problems with the logical standby. Our DBAs can never get it to complete successfully. They have tried a bunch of different methods (even provided from Oracle), but it does not work. e have a bunch of skip statements on the

Everytime, we need to refresh the schema, we have to build the entire database (primary and logical standby) from production RMAN backup. As you can imagine this is a very time consuming ordeal. There has got to be a way this process can be completed in a timely manner.

I was thinking of the following....
1) shut down dataguard, log shipping
2) lock user, kill sessions, drop user from primary
3) lock user, kill sessions, drop user from logical standby
4) run impdb on production export file on primary
5) run impdb on production export file on logical standby
6) re-enable dataguard, log shipping
7) confirm logs being applied, databases in sync

We are only replicating the one schema to the logical standby. I am not clear on how redo logs would be applied to the logical standby. There are hundreds of them @ 100 mb each, so I would think if we do this independently, I could somehow sync primary and logical standby after the imports complete.

View 2 Replies View Related

DataGuard - Archive Log Apply Gap In Physical Standby Database

Nov 23, 2010

1) The Primary Database is UP. The Physical Stand By Database is DOWN. The Current Archive Log Sequence is 99 in Primary.

We have to apply Archive Log from 51 to 99 to the Standby Database. But Unfortunately, there is no backup of those Archivelogs and the ArchiveLogs from 51 to 98 have got deleted at Primary end.

Now how will you apply these Archive Logs from Primary Database to Physical Standby Database?

Note : The Physical StandBy Database is DOWN.

View 2 Replies View Related







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