RAC & Failsafe :: RMAN Backup On Cluster

Dec 1, 2011

I have a table called dept table with nested collection as below. Nested Table Collection:

create or replace
type courselist as table of varchar2(64) Table Using Nested Table Collection: 
CREATE TABLE "FCSDWH_STG"."DEPT"
   ( "NAME" VARCHAR2(20 BYTE),
  "DIRECTOR" VARCHAR2(20 BYTE),
  "OFFICE" VARCHAR2(20 BYTE),
  "COURSES" "FCSDWH_STG"."COURSELIST"
   )  Content Of Table:NameDirectorofficecoursesAccountingJames CharlesUNOFCSDWH_STG.COURSELIST('natural science','chemistry','Computer Science','Computer Science') 

I am trying to select and print an element from nested table collection using below plsql block.

MY_COURSE VARCHAR2(64 CHAR);
BEGIN
SELECT courses INTO MY_COURSE FROM TABLE(SELECT COURSES FROM DEPT) where courses='chemistry';
DBMS_OUTPUT.PUT_LINE(MY_COURSE);
END; Error Message:
PL/SQL: ORA-00904: "COURSES": invalid identifier

View 6 Replies


ADVERTISEMENT

High Cluster Waits During RMAN Backup

Jul 1, 2010

We had a massive jump in cluster waits specifically; gc buffer busy acquire during an RMAN backup. We identified the cause of the waits to a few hot blocks with a table that may well need re-building in terms of ITLs and PCTFREE (Although I thorght ASSM would manage PCTFREE and PCTUSED..)

What happens during an RMAN backup that may cause huge cluster waits on hot tables? Is there some crazy redo issue going on or maybe flashback?

Either way the spike is there and we can pinpoint the activity on the database but just dont understand why RMAN would cause the issue.We have just found that the LARGE_POOL has not been set, in fact there is no SGA_TARGET either! Could this have an effect on RMAN and cluster waits?

View 3 Replies View Related

RAC & Failsafe :: RMAN Backup Status?

Oct 14, 2012

How to verify if the backups are successfully completed in RAC environment ?

View 9 Replies View Related

RAC & Failsafe :: RMAN Backup / Unable To Open Database

Aug 31, 2013

I tried to run the duplicate script after transferring new rman backup to standby. Even after transferring the backup, duplicate command and was unable to open the database.

View 1 Replies View Related

RAC & Failsafe :: Cluster In Oracle

Apr 23, 2013

Are Oracle cluster and Oracle clusterware are same and has same in meaning in RAC ?

View 6 Replies View Related

RAC & Failsafe :: Oracle Cluster 10 Installation

Oct 27, 2010

Steps for installing Oracle Cluster 10?

View 9 Replies View Related

RAC & Failsafe :: Download Cluster Ware 11g

Jan 22, 2013

I must setup RAC 11g but I haven't meta link account to download cluster ware.

View 2 Replies View Related

RAC & Failsafe :: 11.2.0.2 Patch For Oracle 11gR2 RAC Cluster?

Sep 29, 2010

Yesterday I was installing 11.2.0.2 patch to our Oracle 11gR2(11.2.0.1.0) Two node RAC cluster on OEL 5.4 x86 Linux.Before installing I have read [URL] support note which says "Note: All Oracle Grid Infrastructure patch set upgrades must be out-of-place upgrades, in which you install the patch set into a new Grid home. In-place patch set upgrades are not supported. "

During Installation I found following Installation Option :

1) Install and configure Oracle grid Infrastructure for a cluster

2) Configure Oracle Grid Infrastructure for a Standalone Server

3) Upgrade Oracle Grid Infrastructure or Oracle Automatic Storage Management

4) Install Oracle Grid Infrastructure Software Only

Which option should I have to choose here ?

View 1 Replies View Related

RAC & Failsafe :: CRS-4535 / Cannot Communicate With Cluster Ready Services

Nov 21, 2012

RAC star crs failed

[root@tyan147 crsd]# /orahome/grid/bin/crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
CRS-4534: Cannot communicate with Event Manager

cssd.log

2012-11-21 11:12:29.312: [ GPnP][3613030480]clsgpnpm_connect: [at clsgpnpm.c:1100] GIPC gipcretConnectionRefused (29) gipcConnect(ipc-ipc://GPNPD_tyan147)
2012-11-21 11:12:29.312: [ GPnP][3613030480]clsgpnpm_connect: [at clsgpnpm.c:1101] Result: (48) CLSGPNP_COMM_ERR. Failed to connect to call url "ipc://GPNPD_tyan147"
2012-11-21 11:12:29.312: [ GPnP][3613030480]clsgpnp_getProfileEx: [at clsgpnp.c:546] Result: (13) CLSGPNP_NO_DAEMON. Can't get GPnP service profile from local GPnP daemon
2012-11-21 11:12:29.313: [ default][3613030480]Cannot get GPnP profile. Error CLSGPNP_NO_DAEMON (GPNPD daemon is not running).
2012-11-21 11:12:29.313: [ CSSD][3613030480]clsgpnp_getProfile failed, rc(13)

[code]....

View 2 Replies View Related

RAC & Failsafe :: Installing / Configuring Real Application Cluster Using NFS Instead Of ASM?

Feb 28, 2012

i want to install oracle real application cluster using shared file system and not using ASM. we are not creating LUN for our data to kept and SAN admin will give us NFS share where we will place the database.

View 5 Replies View Related

RAC & Failsafe :: ORA-29701 / Unable To Connect To Cluster Manager

Aug 8, 2011

when i'm creating ASM instance, i'm getting an error

Quote:ora-29701: unable to connect to cluster manager

for this there were some workaround given to start css.

i tried everything from /etc/init.d/init.cssd start/enable but nothing worked, then i tried with executing

localconfig delete
localconfig add====>it failed and recommended to go for reset option

when i executed localconfig reset i get this following error:

Quote:
[root@rac2 bin]# sh localconfig add
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Configuration for local CSS has been initialized

[code]....

This is the same case when i used reset option.

View 3 Replies View Related

RAC & Failsafe :: Change Cluster Interconnection From Public To Private?

Jul 3, 2013

how to change the cluster interconnection from public to private.

View 6 Replies View Related

RAC & Failsafe :: Oracle CRS Failure / Rebooting For Cluster Integrity

Sep 7, 2013

I got following error on Oracle 10.2.0.4.0 RAC on solaris 10

Oracle clsomon failed with fatal status 12.

Oracle CRS failure. Rebooting for cluster integrity.

I think this problem in 11g but I am using 10g.

View 14 Replies View Related

RAC & Failsafe :: Create Setup On Oracle 10.2 Through NFS Cluster Configuration

Jun 29, 2012

I am trying to create a rac setup on oracle 10.2. through NFS cluster configuration .i succeeded with the installtion of cluster configuarion and installation of oracle software ,but when i am trying to create database ,

View 2 Replies View Related

RAC & Failsafe :: Root.sh Fails On Oracle Cluster Installation?

Sep 7, 2011

I am installaing oracle RAC 11.2.0.1. After I installed the grid infrastructure, when I ran root.sh, I got below errors;

ASM failed to start. Check /d1/app/grid/cfgtoollogs/asmca/asmca-1109068AM4612.log for details.

Configuration of ASM failed, see logs for details
Did not succssfully configure and start ASM
CRS-2500: Cannot stop resource 'ora.crsd' as it is not running

[Code]....

View 9 Replies View Related

RAC & Failsafe :: Oracle 9i - Difference Between Real Application Cluster And OPS

Jul 17, 2002

What is the different between the new RAC feature - real application cluster and OPS... for me it sound the same..

View 3 Replies View Related

RAC & Failsafe :: Cluster Does Not Recognize DBA Group Membership Assignment To User

Aug 18, 2011

It appears that the Oracle RAC cluster does not recognize the 'dba' group membership assignment to a user, unless it is assigned as the user's primary group.This also only affects newly created users, older users do not have this issue.

This affects us in the following way:

We are unable to create new cluster resources with the SAPCTL tool with the <sid>adm user.

When we try to create a resource using sapctl as the <sid>adm user we receive the following error:

CRS-0259: Owner of the resource does not belong to the group. SAP ABAP VIP creation failed.

The description of this error is that the resource owner (<sid>adm) is not a member of the group defined by 'osdbagrp' (what the cluster expects group membership for os users to control cluster resources), in our case this group is 'dba'.This is despite the user definitely being a member of the group.

Resource creation workaround:We are able to get around the resource creation by creating the resources either as root user, or by assigning 'dba' as <sid>adm's primary group.However, although we are able to control the VIP cluster resource, we are unable to control the other SAP enqueue resources as we assume that they need to be created by a user with 'sapsys' as a primary group (i.e. the resources do not start or it appears that there is not even an attempt to start the resources as there are no SAP startup logs created).

We have attempted multiple variations of creating and controlling cluster resources: changing <sid>adm primary group, changing cluster resource permissions, with nothing working for us.

The bottom line is that we need to be able to create these sapctl resources with a <sid>adm user that has 'sapsys' as a primary group while also being a member of the 'dba' group.

View 1 Replies View Related

RAC & Failsafe :: Failed To Upgrade Oracle Cluster Registry Configuration?

Sep 18, 2008

The installation of CRS is successfull & at end it ask to execute 2 scripts on both nodes i.e. orainstRoot.sh and root.sh

When the scripts are executed,the execution of orainstRoot.sh is successfull , but root.sh give following error:

[root@rac2host crs]# ./root.sh
WARNING: directory '/home/oracle/product' is not owned by root
WARNING: directory 'home/oracle' is not owned by root
Checking to see if Oracle CRS stack is already configured
/etc/oracle does not exist. Creating it now.

[code]....

Is this concerned with permissions on OCR, Voting Disk.

the ./cluvy shows the cluster is valid.

View 1 Replies View Related

RAC & Failsafe :: Stopping Oracle 11g R2 Cluster Services In Windows 2008

Jan 22, 2013

I am doing the following steps for stopping the Oracle RAC Services on a 2 node.(OS is Windows 2008 Release 2).

srvctl stop database -d <database_name>

Node 1:
crsctl stop has

Node 2:
crsctl stop has

But i am getting error like Oracle HAS Service not stopped successfully. Finally what i did was stopped the OHAS Service from Windows Services.

which is the right procedure to have a clean stopping of RAC Services in 11g R2.

View 4 Replies View Related

RAC & Failsafe :: 11g Oracle Grid Cluster Software Configuration - Getting Error?

Jan 31, 2013

While installing 11g oracle grid cluster software. I am getting below error.

[INS-40724] No locally defined network interface matches the SCAN VIP subnet.

i have given scan name as scan-cluster.invent

host-name virtual ip name
rac3 rac3-vip
rac5 rac5-vip

I am able to ping rac3 and rac5 from both nodes.

MY /etc/host file look like this.

192.168.2.133 rac3.invent.com rac3
192.168.2.132 rac3-priv.invent.com rac3-priv
192.168.122.1 rac3-vip.invent.com rac3-vip
192.168.2.136 rac5.invent.com rac5

[code]...

ssh connectivity everything works fine.

View 1 Replies View Related

RAC & Failsafe :: Creating Cluster Resources For Oracle Enterprise Manager Using Clusterware

Oct 24, 2012

My application consists of Oracle RAC and Oracle Enterprise Manage (OEM) on same two nodes. I am exploring the idea of utilizing Oracle Clusterware (which is already installed with Oracle RAC) to support OEM in active passive mode.

Here is the scenario.

Node A running Solaris 10.9 on SPARC and Node B running Solaris 10.9 on SPARC.
Node A and Node B are both Oracle RAC Nodes ( Active Active ) which use Shared Storage for Oracle using ASM.

Node A and Node B will run Oracle Enterprise Manager (OEM) Application in active passive scenario which will be using Oracle RAC for its database. So, both Oracle RAC and OEM are sharing same server A and B for its clusters.

Now, OEM application need a third party clusterware to fail it over. It needs clusterware to provide floating VIP and shared folder of the size of 20GB which will keep software libraries. If node A goes down, node B have access to same libraries and will come up as active.

Do you know if oracle clusterware which comes with Oracle RAC can support OEM for failing over i.e. it can provide floating VIP and shared file system?

View 3 Replies View Related

RAC & Failsafe :: Installation Error On Vmware - Failed To Initialize Cluster Registry

Nov 19, 2011

RAC installation on vmware is failing with following errors. I followed below link for installation. URL..... Found the following errors:

[root@rac2 ~]# cd /crs/oracle/bin/
[root@rac2 bin]# ./vipca
PRKR-1062 : Failed to find configuration for node rac1
PRKR-1062 : Failed to find configuration for node rac1
[code]....

The "/crs/oracle/cfgtoollogs/configToolFailedCommands" script contains all commands that failed, were skipped or were cancelled. This file may be used to run these configuration assistants outside of OUI. Note that you may have to update this script with passwords (if any) before executing the same.The "/crs/ oracle/cfgtoollogs/configToolAllCommands" script contains all commands to be executed by the configuration assistants. This file may be used to run the configuration assistants outside of OUI. Note that you may have to update this script with passwords (if any) before executing the same.

[root@rac2 bin]# /crs/oracle/bin/racgons add_config rac1.localdomain:6200 rac2.localdomain:6200
[root@rac2 bin]# /crs/oracle/bin/oifcfg setif -global eth0/192.168.2.0:public eth1/192.168.0.0:cluster_interconnect
PRIF-10: failed to initialize the cluster registry
[root@rac2 bin]# /crs/oracle/bin/oifcfg setif -global eth0/192.168.2.0:public eth1/192.168.0.0:cluster_interconnect
PRIF-10: failed to initialize the cluster registry

View 8 Replies View Related

Backup & Recovery :: SCN Based Backup Do RMAN Generate Backup From Archivelogs

Oct 18, 2012

understanding rman scn based Backup Algorithm .. In SCN based backup do rman generate backup from archivelogs ???

View 1 Replies View Related

Backup & Recovery :: 2 Separate RMAN Backup One Backup Is Of Only Datafile

Jan 24, 2011

I have 2 seperate rman backup one backup is of only datafile ,spfile and controlfile which i am able to restore and recover without any problem say bkp1 taken at 10 am

other set of backup is of only archive log files of same day but later time than datafile backup say bkp2 taken at 8pm...if i restore and recover bkp1 and try to restore bkp2 it gives error datafile exist (possibly due to fact both backup have control file)

if i just restore bkp1 and try to restore bkp2 so that i can do one recover at time
it gives error datafile permission issue (possibly due to fact both backup have control file)

I want to restore database upto 8pm time how can i use both bkp1 and bkp2 to do it(restore datafiles and apply all archive logs on it)

View 17 Replies View Related

RAC & Failsafe :: RMAN Duplicate DB For RAC

Jan 26, 2004

We have a script which uses the duplicate functionality of RMAN. It was designed for a standalone database. Now I need to make it work for a cluster DB (RAC installation).

1. Does RMAN support this?
2. Do I need to make separate executions for both the nodes of the cluster?

We are currently blocked because we have no way of getting our system running without this!
******************************8
First attempt:

oracle@sf23> ./nsr_adv_duplicate_db.sh -d ADVFRW_sf25 -t ADVFRW1 -r RCAT -n sys -p sys ->

3808 11:52:49 ----- Starting Cloning Procedure -----
3808 11:52:50 INFO: Client host 'sf25' says, it is 'sf25'.
3808 11:52:51 Getting Original DB Name on the source host (referred by ADVFRW_sf25 TNS-name)...
...
3808 RMAN: GROUP 8 ( '/export/home/oracle/dev/ADVFRW/ADVFRW.redo181' ) SIZE 134217728 REUSE
3808 RMAN: DATAFILE
3808 RMAN: '/export/home/oracle/dev/ADVFRW/ADVFRW.system'
3808 RMAN: CHARACTER SET WE8ISO8859P1
[code]....

Second attempt:

oracle@sf23> ./nsr_adv_duplicate_db.sh -d ADVFRW_sf25 -t ADVFRW -r RCAT -n sys -p sys -c sf25 -s sf04 -g Srv_scl04-backup_DB_grp -l american_america.WE8ISO8859P1

5548 12:27:05 ----- Starting Cloning Procedure -----
5548 12:27:06 INFO: Client host 'sf25' says, it is 'sf25'.
5548 12:27:07 Getting Original DB Name on the source host (referred by ADVFRW_sf25 TNS-name)...
5548 12:27:07 Original DB is 'ADVFRW'
5548 12:27:08 INFO: BGROUP=Srv
[code].......

Now we have contrary error messages. Target DB name ADVFRW does not work, because on the target nodes there are configuration files for the node specific DB names (ADVFRW1.ora on first node resp. ADVFRW2.ora on second node). But with the node specific DB name the script fails, because it does not match with the DB name of the source system.

View 10 Replies View Related

Backup & Recovery :: RMAN Duplicate Set Until Time Using Wrong Backup Piece Name To Restore?

Feb 26, 2012

We are doing RMAN Duplicate set until time to refresh daily our test database for our developers and it taking long time to finish. We noticed on the restore log that RMAN was using a day old old backup pieces to refresh the test database and don't immediately use the latest backup pieces instead.

For additional details here's the rman duplicate command we are using which we run daily(mon-sat) at 4am once daily full backup on production completed.

RMAN Duplicate commands:
run
{
set until time "to_date(to_char(sysdate,'Mon DD YYYY') || ' 04:00:00', 'Mon DD YYYY HH24:MI:SS')";
allocate auxiliary channel ch1 type disk;
duplicate target database to testdb;
}
exit

Is there a way on how to let RMAN use the latest backup pieces instead?

View 1 Replies View Related

Backup & Recovery :: ORA-01655 On CREATE USER (splitted From RMAN Backup Error)

Dec 22, 2012

I created a tablespace named 'data'.During create a new user with default tablespace 'data',I got following error message:

SQL> create user rman identified by rman default tablespace data
temporary tablespace temp

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01655: unable to extend cluster SYS.C_USER# by 2 in tablespace

OS:Windows XP
Oracle 10g

View 2 Replies View Related

Backup & Recovery :: RMAN Full Backup Failing When Backing Up Temp File?

Jan 28, 2011

I am tryign to run a split onlike full backup from the os useign the sap command which is linked to rman..Command that i am useing is ...

brbackup -u / -c force -t online_split -m full -p initBR1_onlinefull.sap

The backup goes thru but i get this erro on the end...

BR0522I 57 of 57 files/save sets processed by RMAN
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.26
BR0505I Full database backup (level 0) using RMAN successful
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.28

[code]...

Copyright (c) 1982, 2007, Oracle. All rights reserved.

RMAN>
connected to target database: BR1 (DBID=2250873886)
using target database control file instead of recovery catalog
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28>
29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42

[code]...

Recovery Manager complete.
ERR_RC: 1
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.32
BR0279E Return code from 'brtools -f printcmd -U /oracle/BR1/sapbackup/..befcdgxn..cmd -C
/oracle/BR1/sapbackup/.befcdgxn.cmd | rsh scrbdefrmr207 /bin/sh -c "'LANG=C SHELL=/bin/sh/oracle/BR1/102_64/bin/rman

[code]...

I have check on the system .. There is not file like that but thwre on on the db i,e

eshtsm20:orabr1 88> pwd
/oracle/BR1/sapdata1/perfman_1
eshtsm20:orabr1 89> ls -ltr
total 102408
-rw-r----- 1 orabr1 dba 104865792 Aug 30 09:05 perfman.data1

View 13 Replies View Related

Backup & Recovery :: Restore Dropped Or Wrongly Updated Table Using RMAN Backup?

Feb 9, 2011

Is it possible to restore dropped table OR wrongly updated table using RMAN backup.

View 18 Replies View Related

Backup & Recovery :: RMAN Script Delete The Backup Pieces Older Than 2 Days

Jan 8, 2013

Is this script is enough to delete the backup pieces older than 2 days.

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS;
configure device type disk parallelism 1 backup type to compressed backupset;

run
{
allocate channel d1 type disk ;
backup filesperset 5 format '/u06/backup/EBSDEV/EBSDEV_data_t%t_s%s_p%p' database ;
sql 'alter system archive log current' ;
backup filesperset 20 format '/u06/backup/EBSDV3/EBSDV3_arch_t%t_s%s_p%p' archivelog all delete input ;

[Code]....

View 1 Replies View Related







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