Does anybody have an uncountered error during replay in enterprise linux x64 wrc client, rac database version 11.1.0.7?If yes, what are you doing to resolve this problem?Windows client crashed when starting replay (under windows xp sp3, windows server 2003/2008).Only in incident folder exist informa ...
Please let me asking you this question; I an new in Legato EMC NetWorker, I have read the EMC document, and still new and I need an advice here. I am an Oracle DBA and in the company I an working for, we have a Tape Engineer who will care about installing the NMO modules, the servers, teh clients, e ...
Please help me with this case:I can perform a tar to this device and also a "save " with Legato.If I run my RMAN script pointing to a disk device, it works fine ;but if I run my RMAN script pointing to a tape device using 'SBT_TAPE', itdoesn't works.... that's the problem.I am using:NetWorker Module ...
Im a newbie on Oracle. Need your help to create an RMAN level 1 script to one of the development db.Below is current persistent config settings. Thanks in advance.RMAN> show all;RMAN configuration parameters are:CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 45 DAYS;CONFIGURE BACKUP OPTIMIZATIO ...
I am trying to do a restore test, but it always fail with the following message :RMAN-06054 media recovery requesting unknown log: thread 1 scn 234057I am currently using 8.1.7 and Legato's Networker Module for Oracle to perform this backup. My backup script are as follow:connect target original/123 ...
Hi,I want to backup my DB to tape using rman, my tape drive is POWERVAULT 110T SDLT320 TAPE DRIVE, I've set the following line:configure default device type to sbt;I know I need to configure another line:configure channel device type sbt parms='env=(nsr_server=tape_svr,nsr_client=oracleclnt,nsr_grou ...
Hi,I want to backup my DB to tape using rman, my tape drive is POWERVAULT 110T SDLT320 TAPE DRIVE, I've set the following line:configure default device type to sbt;I know I need to configure another line:configure channel device type sbt parms='env=(nsr_server=tape_svr,nsr_client=oracleclnt,nsr_grou ...
I made a simple script: Failes with ksh,bash.ORACLE_SID=baan5ORAENV_ASK=NO. oraenvORAENV_ASK=YESNLS_LANG='AMERICAN'NLS_DATE_FORMAT='YYYY-MM-DD:HH24:MI:SS'export NLS_DATE_FORMATexport NLS_LANG rman <<!connect targetshutdown immediatestartup mountset dbid=2267994717;run {allocate channel tape1 t ...
I am using RMAn to backup my Oracle database..I have a databse of around 400GB..When i start my backup using RMAn scripts the backup happens but when it cums to backup the archive logs..I get the following error ..RMAN-00571: ===========================================================RMAN-00569: === ...
I'm using Networker version 7.2 and am having problems with trying to restore a test database from 'host A' to 'host B'. I get an error of ORA-27191: sbtinfo2 returned errorAdditional information: 2ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 2360RMAN-10031: RPC Error: ORA-27191 occurred during c ...
I have an RMAN script and i want to use this script to backup my database on my local filesystem.How can i do it ? What changes i need to make in the script?How can i sepcify the path where i want to backup it ?Actually this script was taken for doing it on tape drive .Please help me.connect target ...
I need to explain my scenario/position:We backup our database every night to disk this command:configure channel device type disk format "/backup/%d_%T_%s.%U";backup filesperset 4 database;After backup job is done create a lot of backupset files in /backup directory. And after we backup this backups ...
I'm facing the following error while running my RMAN script. Server : Sun Solaris 5.10DB : Oracle 10gR2RMAN> connect *********2> connect *********3> run4> {5> CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE'6> PARMS 'ENV=(NSR_SERVER=namibia,NSR_DATA_VOLUME_POOL=KBAPS,NSR_CLIENT=kenya)' ;7 ...
We are using RMAN with catalog on Legato. Oracle 10gR2.Our archive log backup is taking every 2 hours with scriipt: run { allocate channel t1 type 'SBT_TAPE';allocate channel t2 type 'SBT_TAPE';send 'NSR_ENV=(NSR_SERVER=hitbackup.hit.hypohr,NSR_CLIENT=a22ff020.hit.hypobck)';# 0.0840278 = 121 minutes ...
We are using RMAN with catalog on Legato. Oracle 10gR2.Our archive log backup is taking every 2 hours with scriipt: run { allocate channel t1 type 'SBT_TAPE';allocate channel t2 type 'SBT_TAPE';send 'NSR_ENV=(NSR_SERVER=hitbackup.hit.hypohr,NSR_CLIENT=a22ff020.hit.hypobck)';# 0.0840278 = 121 minutes ...
We have very often need to restore production database, backuped with RMAN online full backup with catalog, to some other host in other location...for simplification in one folder (represented with Linux defined "$DB_TOP" environment variable). For tape media we use EMC Legato drive tape library.Our ...
Could anyone tell us what is the cause of the error: ....allocated channel: t1channel t1: sid=968 devtype=SBT_TAPEchannel t1: NMO v4.5.0.0allocated channel: t2channel t2: sid=1320 devtype=SBT_TAPEchannel t2: NMO v4.5.0.0sent command to channel: t1sent command to channel: t2allocated channel: aux1cha ...
as I am still new to RMAN I would be greatfull to You for some help and guidance here.I am cloning database with RMAN duplicate database command and at the and of the script I got RMAN-06055: could not find log sequence 86362 thread 1 .The script is :RMAN> RUN { 2> allocate channel t1 type 'SB ...
please give me advice on this.I am trying to backup ONLY archive logs that were generated in one specific day in the past.Those achived logs are currently on the database disks.Im trying to make this happen with the following rman code :connect target rmanadmin/pwd@dbname connect catalog rman/pwd@db ...
Im performing a restore from one backup client to other host.When i execute the followings rman commands.I got this:RMAN> RUN2> {3> allocate channel ch01 type SBT_TAPE parms 'ENV=(NSR_SERVER=nt_biobd, NSR_DATA_VOLUME_POOL=oracle)';4> allocate channel ch02 type SBT_TAPE parms 'ENV=(NSR_SE ...
we have used for a long time DUPLICATE for daily backup/restore checking our PROD instance on other instance (different sid - different box). Our RMAN backup is on daily basis and full (no increment). Backup starts every day at 02:00 and finishes about 04:10. Naturally we use catalog database (CATDB ...
Hi, I have a db that is backed up by Networker, so the backup goes straight to tape. I would like to now restore using this backup, but to a different location. I understand that I could restore to the db server and then copy backup pieces to this different location and then go from there. However, ...
Please, really need help I took hotbackup using RMAN catalog which went to tape. Here is the script for that: *connect target sys/*****@PROD;**connect rcvcat rman/****@catalog;*run {allocate channel t1 type 'SBT_TAPE';*send 'NSR_ENV=(NSR_SERVER="***",NSR_DATA_VOLUME_POOL=Oracle)';*backup database pl ...
I am trying to restore archive log files from rman backup, but the rman fails with below error, any help would be much appreciated.RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: =============== ...
Please HELP. Need to create RMAN 10g Fast Incremental Backup script (level1) in DB D02. Level 0 on Monday, Level 1 the rest of the week, Tue to Sunday.I already ENABLE BLOCK CHANGE TRACKING so I can implement Fast encremental backup. Below details are scripts for level 0 and level 1.RMAN> print s ...
HiI am trying to perform full automated point in time reconvery on our 11g databasethe backups are on tape.this is the log file :Recovery Manager: Release 11.1.0.6.0 - Production on Mon Jul 13 14:55:13 2009 Copyright (c) 1982, 2007, Oracle. All rights reserved.connected to target database: KGCSP (DB ...
My backup admin is calling rman from EMC networker passes the parameters RMAN prodrman.batprodrman.bat containsconnect target myuser/mypass@MYDBrun {allocate channel t1 type 'SBT_TAPE'parms 'ENV=(NSR_SERVER=FQN_HERE,NSR_CLIENT=OURCLIENT,NSR_DATA_VOLUME_POOL=MYDAILY)';backup current controlfile;backu ...
Actually I'm trying save some space in FRA? Any Ideas will be really welcome.One option I can think of is Compressed backup setsI don't see anyhting like 'Compress' in my scripts below....Also in 'Backup Settings' under 'Availability' Tab in GridI see 'Backup Set' selected and not 'Compressed Backup ...
I need to restore my DB from rman backupSo first what I wanted to do was a restore of the controlfile. Below the list of commands I typed:export ORACLE_SID=AArman target /set DBID=12345676890startup force nomount;run{allocate channel CH1 TYPE 'SBT_TAPE';SEND DEVICE TYPE 'SBT_TAPE' 'NSR_ENV=(NSR_SERV ...
Guys,Need to some rough inputs on my database sizing requirement:Need to build Oracle 11g dB with year 1 size of approx 470 TB ( with backup maintained for 4 years on seperate server - 4 * 470 TB)Initially write intensive system...year 2 onwards will be read/write...Plan to use RAC, Exadata Storage ...
Is it possible to connect an oracle 8i client to a 10g server running rac? We have some clients running some 8i clients that cant be upgraded. ...
My questions is does instant client support rac ?example : tnsnames.oraRAC =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = DB1-VIP)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = DB2-VIP)(PORT = 1521))(LOAD_BALANCE = yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = RAC)(FAILOVER_MODE =(TYPE ...
can any one give the links for doc for configuraing oracle OCI client for RAC ...
We are planning to deploy Oracle 10g RAC on itanium Cluster. What is the Client and its version requirement to take full advantage of 10g RAC load balancing/fail over ?ShanmuIndia. ...
We will migrate our server to Oracle 10g with RAC and ASM.On the other hand, our client machines are using Oracle 8i.Does 8i support load balance connection on 10g RAC server? ...
i have 3 nodes of 9204 RAC under rhel 2.1SQL> host lsnrctl statusLSNRCTL for Linux: Version 9.2.0.4.0 - Production on 19-FEB-2007 10:53:44Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1pub)(PORT=1521)))STATUS of the LI ...
An oracle engineer working with me created a RAC database 10gR2 by runninga database creation script, not DBCA that is recommended from oracle in creating a RAC database. The following is from oracle."http://download-west.oracle.com/docs/cd/B19306_01/rac.102/b28759/configwlm.htm#CHDJIAJH#CHDJIAJH"Th ...
Our devs want to use java's thin client. If they copy in the string for the database in question from the tnsnames.ora, pretty much as is, will failover work? Has anyone confirmed failover in rac works with java's thin client. I'm not an expert in either...just enough knowledge to do what I need to ...
question about client connect to RAC, O connect to one sevice name or load balance to all node? ...
I'm confused how client connect to RAC,1) According to this:http://www.datadirect.com/developer/odbc/odbc_oracle_rac/connecting/index.ssp"a ServiceName exists for the entire Oracle RAC system. When an application uses the Oracle RAC system's ServiceName, the Oracle RAC system appears to be a single ...
I have a 4 nodes oracle RAC in radhat 5.0both oracle database and client as 10.2.0.4.I created a TNS that works in our office but it does not work in our remote brance office.Based on experts instruction, I set up sqlnet trace at client side. but not any file that be gererated.In linux RAC database, ...
- Few questions on eXaData V2 - 1. Smart Scanning As we know, this feature does filters, predicate evaluations, and join filters at storage cell level.a. How do we confirm that query uses smart scan feature ?b. Do we have any specific views that we can query to find out this feature related informat ...
I understand that the exadata is primarily aimed at performance and RAC is for high availability. From performance point of view, what should be the criteria to select between RAC or Exa Data for OLTP? ...
I recently joined a compnay where exadata is in impementation phase. Here RAC is also implemented. I am new on both this technology but I have to start learning both the technology with a good pace. We are getting some problem with loading the data also. But I do not hv so experience to find out the ...
It is possible in a Half Rack of Exadata, configure two nodes on Cold Failover, ie have an active and a passive node without using Oracle RAC? Or this is not supported by Oracle? ...
All,Is any body install RAC on ORACLE EXADATA?I just want to know the differentiate between RAC installed on ORACLE EXADATA and RAC installed on one high end machine like 24 cores Xeon,128G, VT-x supported. ...
I've installed Oacle RAC (11.2.0.1.0) w/2 nodes in Linux: RH 2.6.18-238.9.1.el5.[oracle@srv267 bin]$ crsctl check hasCRS-4638: Oracle High Availability Services is online[oracle@srv267 bin]$ lsnrctl statusServices Summary...Service "+ASM" has 1 instance(s).Instance "+ASM1", status READY, has 1 handl ...
We have rac one node implemented on windows 2008. We are testing the failover from client side . When we tried to relocate the instance from one node to other node, oracle client delays the connectivity for the relocation duration and takes up the connection immediately and automatically , but in th ...
I'm trying to connect to multiple Oracle 10g databases (failover) over the JDBC thin client, and when I run the following, I get: java.sql.SQLException: Io exception: NL Exception was generated connection = DriverManager.getConnection("jdbc:oracle:thin:@DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROT ...
Using the Oracle thin drivers to talk to a 9i RAC database, which drivers would work best with connect time failover? Are there any major reasons to not stay with the 8i drivers? ...