Oracle Back up is showing library Dell PS 6100E as unsupported device and can not retrieve any information from it, can not ping and can not verify both from obtool and web tool. Using Linux. I can ping from outside and see the device config using lsscsi. But obtool and webtool fails. Is it really unsupported ? In the
$ORACLE_Backup_Home/device/device_robots I see some PV122T, PV124T
We having OSB 10.4 on Solaris 10 with SL 24 TL Auto loader ( Tapes doesn't having Bar-code ), while firing file system backup (Sol 10 is the client OS) , it is hanging . and i have logged in to TL console then it shows loading and unloading. while OSB catalog backup is getting fired on the associated media family.
View 2 Replies View RelatedIs it possible to un-delete the deleted backup pieces, then catalog them to RMAN?
ob> lsvol contents vid GENERIC-000138
VOID OOID Seq Volume ID Barcode Family Created Attributes
533 533 28 GENERIC-000138 PCC204L2 GENERIC 2010/11/12 never closes; content manages reuse
BSOID File Sect Level Host Size Created Attributes
4254 277 2 0 oraserv 14.8 GB 2012/03/31 deleted
4255 278 1 0 oraserv 57.7 GB 2012/03/31 deleted
4256 279 1 0 oraserv 54.2 GB 2012/03/31 deleted
4257 280 1 0 oraserv 62.3 GB 2012/03/31 deleted
We are exploring Oracle Secure Backup in our environment as legato networker alternative. But RMAN backup in OSB is very slow due to sbt wait event (sbtwrite2). it can backup 5GB/hour. We think this not normal behavior. we have checked network throughput between media server and client server. It can send 50 GB data by 30 min.
View 2 Replies View RelatedI have a lot of uncompressed backup. How can I compress it?
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
304 B 0 A DISK 01-OCT-12 1 1 NO BACKUP_DPCTRDB_000_100112093432
305 B 0 A DISK 01-OCT-12 1 1 NO BACKUP_DPCTRDB_000_100112093432
306 B 0 A DISK 01-OCT-12 1 1 NO BACKUP_DPCTRDB_000_100112093432
308 B 0 A DISK 01-OCT-12 1 1 NO BACKUP_DPCTRDB_000_100112093432
309 B 0 A DISK 01-OCT-12 1 1 NO BACKUP_DPCTRDB_000_100112093432
[Code]....
Two questions.
1. Both Oracle Secure Backup and Oracle Secure Backup Express for x86 Solaris download the same file.
Is there no difference on Solaris?
2. Have installed and configured sgen driver and tapes can be labelled OK and the first backup works
BUT appending the next backup to the tape I get the following.
Space to EOD.
BSR
Device says it is offline
Transcript below
8231: 2012/12/21.10:16:28 (pvfw) previous state is invalid
8232: 2012/12/21.10:16:28 (alv) backup image label is valid, file 1, section 1
8233: 2012/12/21.10:16:28 (pvfw) invalidating tape position in mount db
8234: 2012/12/21.10:16:28 (ial) invalidate backup image label (was valid)
8235: 2012/12/21.10:16:28 ***0 wst__exec: op=16 (eod), buf=0x0, count=1 (0x1), parm=0x0
[code]........
My scenario:
We have OSB 10.44 installed on 64 Bit Red Hat OS. Is working pretty fine with a Virtual Library that is configured in an Storage Box. Now we have acquired a Physical Storage and we want to duplicate the backups already taken by the Virtual Library into the new Physical Library.
We have 20 drives for the VTL and for the physical we are planning to have the same to duplicate all backups from VTL. That is being done in case Emergency Failures, so we can restore from Physical Library in case the VTL fails.
The question is: Is there any documentation on how to do duplicate backups.?
The duplicate backups copy wont be done in real time. They will be done after the backup is finished in the VTL and then will start the copy in the physical library.
I have on PC running Windows Server 2003 named "Host A" and another Windows Server 2003 named "Host B".I made a Backup from Host A and want to restore this on Host B with following procedure.
Prepare & Backup:
SQLPLUS SYS AS SYSDBA
SQL>SHUTDOWN IMMEDIATE
SQL>STARTUP MOUNT
SQL>ALTER DATABASE ARCHIVELOG;
SQL>ALTER DATABASE OPEN;
SQL>ARCHIVE LOG LIST;
SQL>ALTER SYSTEM ARCHIVE LOG START;
SQL>QUIT
[code]...
But when i now try to access the Database Control i got following Error:„503 Service Unavailable: Servlet error an exception occurred the current application deployment descriptor do not allow for including it in this response" and the restored Datas are not included.
what is the difference b/w rman and oracle secure backup.
View 1 Replies View RelatedWe are trying to use the SFTp transport in OSB 11g. Did the setup as mentioned in the documentation.The SFTP server is hosted on linux machine and using the user password mechanism.
We are reading a file using the ftp adapter and routing to the business service that is based on sftp.The file is picked up properly by proxy but while sending the file through SFTP, we are facing the following error.At the source and destination ends, the directories have the full permissions as required.
BEA-381801
Caused By: com.bea.wli.sb.transports.TransportException: No such file
at com.bea.wli.sb.transports.sftp.connector.SFTPTransportProvider.sendMessage(SFTPTransportProvider.java:198)
at com.bea.wli.sb.transports.sftp.connector.SFTPTransportProvider.sendMessageAsync(SFTPTransportProvider.java:110)
at sun.reflect.GeneratedMethodAccessor1005.invoke(Unknown Source)
[code]...
resolve this error.
Is oracle providing secure backup only for Tape drive not for disk(means Hard-disk),configure oracle secure backup.
View 1 Replies View RelatedCan HP DDS-4 Data Cartridge C5718A be used for "Oracle Secure Backup"??
View 2 Replies View RelatedWe would like to used Oracle secure backup using SAS interface on an IBM Autoloader Model TS-2900. Would it be possible to configure oracle secure backup using SAS?
View 7 Replies View RelatedDifference between cold backup and cold cloning?
View 2 Replies View RelatedWe have the following scenario that we need to replicate:
Our current systems are on oracle RAC+ASM with 2 nodes, they are on physical hardware.We would like to replicate from physical to VM, storage is DELL compellent.
Can this be done online without RMAN at SAN level replication? how to replicate the systems.
with ele(sno,name,state) as(select sno,name,state from sankar)delete from ele where sno=1 select sno,name,state from sankar
View 2 Replies View RelatedWe are using 10G Forms and Reports against a 8I database (DB1) which has a link into another 8i Database (DB2).
DB2 has been upgraded to 10G. The application works fine but when I try to compile the forms in form builder I get an "ORA-03115, unsupported network datatype or representation." error.
The error occurs where the code in the form references the link directly. Other code where we created views to hide the link name works fine. BTW Same code works fine in SQL Plus 10G & Toad.
I have tried changing the type of variables & different columns but that did not work.
I am getting ORA-39726 error when a dropping a column on a non-compressed table.
SQL> select distinct TABLE_OWNER,COMPRESSION,COMPRESS_FOR from dba_tab_partitions where TABLE_NAME='STM_AE_STMT_HISTORY_DETAIL';
TABLE_OWNER COMPRESSION COMPRESS_FOR
------------------- ---------------------- -------------------
APP_SU DISABLED
SQL> ALTER TABLE APP_SU.STM_AE_STMT_HISTORY_DETAIL DROP COLUMN RATE_DESCR;
ALTER TABLE APP_SU.STM_AE_STMT_HISTORY_DETAIL DROP COLUMN RATE_DESCR
*
ERROR at line 1: ORA-39726: unsupported add/drop column operation on compressed tables
when i am trying to connect to the database using sqldeveloper i am not able to connect to database. its giving me an error "Unsupported Oracle database version" but with plsql developer I am able to connecting.
View 8 Replies View Relatedmy user is trying to drop columns, but she gets below error:
SQL Error: ORA-39726: unsupported add/drop column operation on compressed tables
39726. 00000 - "unsupported add/drop column operation on compressed tables"
i just checked whether table is compressed or not, it is not compressed it seems:
select owner, table_name,COMPRESSION,COMPRESS_FOR from dba_tables
2 where owner = 'EQUIPMENT' AND TABLE_NAME = 'ETHRNT_VRTL_CNXN_HRLY_AGG_SWP';
OWNER TABLE_NAME COMPRESS COMPRESS_FOR
------------------------------ ------------------------------ -------- ------------
EQUIPMENT ETHRNT_VRTL_CNXN_HRLY_AGG_SWP DISABLED
1 row selected. i am able to set one column as UNUSED. and then i am able to see the count accordingly from below view:
select * from DBA_UNUSED_COL_TABS
where owner ='EQUIPMENT' and table_name = 'ETHRNT_VRTL_CNXN_HRLY_AGG_SWP';
but not able to drop the unused columns. if i tried to drop a column directly from the table, that also giving above error.
My Boss give me a mission:
How oracle send a s.m.s.(Short Message Service) to mobile device? Is there any examples or implement documents for reference?
I have a SAN Storage device of 8TB size . I am new to rac setup ,i dont know how to configure the SAN device for RAC SETUP on ASM..how to configure the SAN device for RAC setup on ASM
How many disks we need to have? which and sholud be on ASM ? how to impliment raid10 for database file disk and raid5 for arhcive log files
I am working on 10g. I have to capture and retrive thumb impression through biometric device on forms. And then store it in database.
Already working in VB . I have its jar files also.
I have one PDA device. I need to run a Oracle form developed in Oracle forms 6i on this PDA by connecting it to the Oracle 10G database running on Linux Server.
I need to know is there any Oracle client for windows 6.0 OS. if yes then how can i install it on PDA and access the Oracle database through forms.
I want to send sms to the mobile using Oracle form 6i.
View 8 Replies View RelatedIs it possible to communicate with a serial device (via COM1) with oracle forms / webutil? I am able to communicate in java using RXTXcomm, but I am having problems making a bean that uses it (getting security errors and yes, I have signed the jars).
Basically, I have a scale hooked up to my COM1 port and want to be able to send commands (zero and tare) to it and read the weight from it through a form or java bean.
I wish to install 11g r1 RAC on my laptop having linux 4 as platform (on vmware) , for that i prepare 4 partition for that (on node1)
/dev/sdb1 - for ocr
/dev/sdb2 - for voting disk
/dev/sdb3 - for asmdisk group
/dev/sda5 - fro asmdisk group
by assuming external redundancy for ocr and voting disk i kept only one disk
and i configured following in /etc/sysconfig/rawdevices
/dev/raw/raw1 /dev/sdb1 -- ocr
/dev/raw/raw2 /dev/sdb2 -- voting disk
/dev/raw/raw3 /dev/sdb3 -- asmdisk group
/dev/raw/raw4 /dev/sdb5 -- asmdisk group
and my question is how node2 can understat these raw device as shared storage?
i finished from design and programming the program how can Connect this program on more than one device
View 7 Replies View RelatedHow to secure oracle database, I am having the oracle database which will be packed as package in a machine and will be delivered to client place , need to ensure that the client will not access the database by any means.
Even he breaks the password (he should not break but despite client has broken the password) and went inside the database, he should not be able to see the databases Procedures ,views,functions and triggers. Can we Encrypt this, if so can client will be able to decrypt the same? Is there a way to secure the database from the client not to access the database.
how can i secure my database from hacking by any one of these:
1-sql injections
2- DON(Danial Of service)
3- buffer overflow
4- listner hack