Which Command Use To Set File Storage In Oracle
Oct 26, 2006I am new to oracle which command do I use to set the file storage in oracle? I learnt the we have the option of specifying the storage pattern as per our queries.
View 2 Replies
ADVERTISEMENT
Possible To Move Data At Storage Level Without Using Convert Command?
Apr 12, 2011We are migrating database from HP to AIX. Data is all on SAN.I can do it through RMAN convert. What I want to know is if it is possible to move data at storage level without using Convert command?
View 2 Replies View RelatedAutomatic Storage Management :: Execute Multipath -ll Command Not Display All 5 Path
Aug 3, 2012When I execute multipath -ll command that time display only 3 path (orafra2,oradata2 and oradata1), not display other 2 path (orafra1 and data1). I have configure 5 path in /etc/multipath.conf file. What is the reason behind it.
[root@reuxeuls003 ~]# multipath -ll
orafra2 (360060160a71e2100de29aae7f4f9de11) dm-10 DGC,RAID 10
size=200G features='1 queue_if_no_path' hwhandler='1 emc' wp=rw
|-+- policy='round-robin 0' prio=1 status=active
| |- 1:0:1:3 sds 65:32 active ready running
[code]....
Automatic Storage Management :: Oracle ASM With Nimble Storage?
Mar 1, 2013My organisation is currently discussing different storage options for the database storage. Our production database is nearly 2TB and we do not want to continue with the existing NetApp storage (we use a 2 node RAC running 11.2.02 with nfs filesystem from NetApp filer).
We were looking at different options and came across Nimble Storage, they are very fast growing company aiming mid-range storage customers. The initial talks and demonstration looked very promising in terms of IO performance (they claim 40,000 - 60,000 IOPs for their CS400 series Nimble Storage array) and other options they are providing but we understand that majority of their customers are using it for VDI and other infrastructures.
They have demonstrated us using if for Oracle database with ASM storage over iSCSI LUNs. We are yet to do the POCs and benchmarking.
Has anyone come across Nimble Storage for running Oracle databases?
Brtools Command Versus Oracle Command For Shutdown And Startup (statistics)
Sep 13, 2013we are running SAP application against oracle database. say, if I use brspace or brtools (from SAP side) to shutdown or startup database or collect stats, does this mean it not recommend to use oracle command to shutdown/start & collect stats?
View 3 Replies View RelatedData Guard :: Migrate From File Based To ASM Storage
May 15, 2012I have an 11gR2 data base with Local Extent Management and Manual Segment Management. Can Data Guard be used to replicate this instance into ASM storage? [I have multiple long fields (BLOBs and CLOBs) in various tables.]
View 3 Replies View RelatedRAC/ASM Clusterware Installation :: File System Storage Option On 10g?
Sep 30, 2013We have two database servers(10g with OEL 5) to be clustered and two visible disk groups to each of those nodes. So question is can we choose only one disk group as a shared storage leaving the rest one as the redundant copy during database a creation window while installing the database. Because some of us argue that oracle database has a built-in capability to decide on what level of RAID we store our data.
View 7 Replies View RelatedAutomatic Storage Management :: Data File Recovery Error?
Oct 8, 2012I have Oracle 10.2.0.4.0 on RAC environment. I had 19 Data files on ASM. However one of my colleague has created new data file on a Node using Physical Drive which like this.
G:ORACLEPRODUCT10.2.0DB_1DATABASEDATA_001.DBF instead of +DATA/ref/datafile/data.400.70812332
Now this file is in Recover State and when i try to make it online it says Block # 12 of this file is corrupted.
select * from v$datafile
20 20 6463317847 06/10/2012 10:11:18 6 20 RECOVER READ WRITE 6467876664 07/10/2012 08:39:09 0 6468047778 07/10/2012 09:30:53 0 0 104857600 12800 104857600 8192 G:ORACLEPRODUCT10.2.0DB_1DATABASEIFSAPP_DATA_001.DBF 0 8192 NONE 0
Forms :: Command To Run SQL File?
Mar 8, 2011i want to run sql file by forms...is there command do that
View 3 Replies View RelatedSQL & PL/SQL :: Generate Command To Rename Log File From ASM To Non-ASM
Apr 9, 2013I am in the process of recovering a database from an ASM environment to a non-ASM environment using RMAN. I've got a query to generate the command to RENAME the file:
SELECT 'ALTER DATABASE RENAME FILE '''||MEMBER||''' TO '''||'/u01/data/dev'||
SUBSTR(MEMBER,
INSTR(MEMBER, '/', -1, 1),
INSTR(MEMBER, '.', 1, 1) - INSTR(MEMBER, '/', -1, 1)) ||
DECODE(SUBSTR (MEMBER, 1, INSTR(MEMBER, '/', 1, 1) -1), '+DATA', 'a', '+FRA', 'b', 'c') ||'.log'';'
FROM V$LOGFILE;
When I run the query, this is an example of the result I get:
ALTER DATABASE RENAME FILE '+FRA/db1/onlinelog/group_3.259.766075171' TO '/u01/data/dev/group_3b.log';
ALTER DATABASE RENAME FILE '+DATA/db1/onlinelog/group_1.262.766075829' TO '/u01/data/dev/group_1a.log';
But I want to replace the "group" with "redo" and get the below result:
ALTER DATABASE RENAME FILE '+FRA/db1/onlinelog/group_3.259.766075171' TO '/u01/data/dev/redo_3b.log';
ALTER DATABASE RENAME FILE '+DATA/db1/onlinelog/group_1.262.766075829' TO '/u01/data/dev/redo_1a.log';
SQL & PL/SQL :: BFILENAME / Unable To Get The File Using The Command?
Oct 16, 2012i am using a SQL statement as below but unable to get the file using the command :
SELECT bfilename('$APPLCSF/out','XXMSPOSTD_3798178_1.pdf') FROM dual;
Format Output File By Command Spool
Jan 20, 2011I use sqplus in oracle to output the command output to text file .
I use below set environment variable.
SQL> set echo off;
SQL> set linesize 3999;
SQL> set feedback off;
SQL> set feedback off;
SQL> set termout off;
SQL> set pagesize 0;
SQL> spool mapping.txt
select C_SIM_MSISDN,C_SIM_IMSI from RCA_SMART_CARD order by C_SIM_MSISDN;
In ouput file , it look like
SQL> select C_SIM_MSISDN,C_SIM_IMSI from RCA_SMART_CARD order by C_SIM_MSISDN;
060010007 10007
:
:
:
SQL> spool off;
any setting or command that allow me to remove the first sql command line" SQL>select XXXX" and the last command "SQL>spool off" after start up the "spool mapping.txt"
Import Data From Dmp File Using Command IMPDP?
May 2, 2011I am trying to import data from a dmp file using the command IMPDP Here is the command :
impdp
USERID= core_edb_20112_ct/local
DIRECTORY=dir_core20112
DUMPFILE=CORE_EDB_20112_CT_20110426.DMP
LOGFILE=log_core02112_1.log
SCHEMAS=core_edb_20112_ct
REMAP_SCHEMA=core_edb_20112_ct:core_edb_20112_ct
PARALLEL=4
METRICS=Y TRANSFORM=OID:N
TRANSFORM=SEGMENT_ATTRIBUTES:N
REMAP_TABLESPACE=C64_EDB_TS:C64_EDB_TS
I am trying to import data in the following user : core_edb_20112_ct/local
This user is already created , using the tablespace named C64_EDB_TS
The dmp file resides in the location dir_core20112 ( e:\oracle)
I am getting the following error while i try to import
Import: Release 11.2.0.1.0 - Production on Mon May 2 12:47:54 2011
Copyright © 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-31694: master table "CORE_EDB_20112_CT"."SYS_IMPORT_FULL_01" failed to load/
unload
ORA-02354: error in exporting/importing data
ORA-02368: the following file is not valid for this load operation
ORA-02369: internal number in header in file e:\oracle\core_edb_20112_ct_20110426.dmp is not valid.
The DMP is copied from a different network location into the local drive where the command is running.
SQL & PL/SQL :: Redirect Output Of A Command To Variable Or File?
Jun 18, 2010I have a command which get the versions of the schema's for which I dont have access to. It is a utility.
the command goes:
SQL>EXEC ite_dta_tool.dta_open_utl.get_db_version('HH2_SGH21_SS')
DATABASE_VERSION_ID
-----------------------
hh2_ax_db_0.8.1.2.0
Elapsed: 00:00:00.25
SQL>
'HH2_SGH21_SS' is a schema I dont have access to. I have a whole bunch of schemas like this and would like to get versions of all those schemas putting it in a loop in pl/sql.
1: whats the best way get this output to a variable.
2: whats the best way to get the output to a file.
PL/SQL :: Data To Existing File Using Spool Command?
Jul 19, 2012I am calling a stored procedure from a shell script. This stored procedure is having a CLOB object as an OUT parameter. How to write the data in CLOB object a existing file which is there in my client system. Below is the shell and sql scripts.
Shell script
( echo "hello" ) > /root/file.txt
sqlplus -s $user/$pass@$tns @/root/proc.sql /root/file.txt << EOF
EOFSQL script
set pages 0
set trimspool off
[Code]...
spool offThis code writes contents of the OUT variable to file.txt, but my existing data ('hello') is lost.
I figured the it...Use append in the spool command...
Server Utilities :: Load / Unload Csv File Using Sql Command?
Apr 5, 2010load/unload csv file using sql command
View 1 Replies View RelatedClient Tools :: Format Output File By Command Spool?
Jan 20, 2011I use sqplus in oracle to output the command output to text file .
I use below set environment varialble.
SQL> set echo off;
SQL> set linesize 3999;
SQL> set feedback off;
SQL> set feedback off;
SQL> set termout off;
SQL> set pagesize 0;
SQL> spool mapping.txt
select C_SIM_MSISDN,C_SIM_IMSI from RCA_SMART_CARD order by C_SIM_MSISDN;
In ouput file , it look like
SQL> select C_SIM_MSISDN,C_SIM_IMSI from RCA_SMART_CARD order by C_SIM_MSISDN;
060010007 10007
:
:
:
SQL> spool off;
any setting or command that allow me to remove the first sql command line" SQL>select XXXX" and the last command "SQL>spool off" after start up the "spool mapping.txt"
Windows :: How Search Specific String In PDF File From Command Prompt
Nov 21, 2012I have a requirement in which i have list pdf files(from thousands of pdf files) having particular string from a command prompt.I have tried find command but that has some limitation. its working upto 3 digit string only.how can i acheive this.remember i have to do this through command prompt only.
View 1 Replies View RelatedBackup & Recovery :: 11g R2 - How To Update Control File With Switch Command
Oct 3, 2011I have restored all datafile to new location (that is ASM) earlier it was on file system using set new name command (RMAN). Now when i'm trying to update control file with swicth command it is prompting error. Version is 11g R2.
RMAN> SWITCH DATAFILE ALL;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "all": expecting one of: "double-quoted-string, integer, single-quoted-string"
RMAN-01007: at line 1 column 17 file: standard input
Performance Tuning :: Command To Transfer File From Local To Remote Server
Apr 21, 2011I ran a scp command to transfer a file from local server to a remote server. when I am trying to kill the process, its giving an error.
ksh: kill: 19258: No such process
If I do a ps -ef | grep scp its showing the process running, but if i try to kill it, its showing me error.
Oracle RAC Shared Storage Dilemma
Jul 26, 2013Some shops run Oracle RAC using "conventional" storage, like emc, netapp, etc. Some shops run Oracle RAC using JBOD, just bunch of disks, all redundancy is managed by ASM.
How would you distinct these two approaches? JBOD approach sounds cheaper, so why serious enterprises are still using traditional conventional storage, like netapp and emc?
ASM VS Veritas Storage Foundation For Oracle RAC
Nov 16, 2012I am doing a Trade Study on Automatic Storage Management vs Veritas Storage Foundation for Oracle RAC on Solaris. I am trying to get feedback from individuals on which file system is best for a high OLTP 11gR2 system. I am really concerned about how the to file systems stack-up when compared on their overall performance. Our system admin doesn't trust ASM and is a firm believer in Veritas. I am trying to be objective and find the best solution for our projected upgrade system. We are upgrading from Solaris 890s to T4-2s, 11gR2, Solaris 10 or 11, and EMC storage. I was also concerned that Oracle doesn't have the ASMLIB package for Solaris. We have other system on Linux that use ASMLIB.
View 2 Replies View RelatedRAC & Failsafe :: Oracle Rac Raw Device As Shared Storage
Jul 24, 2012I 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?
Automatic Storage Management :: Build ASM In Linux Box Oracle 11g?
Dec 28, 2012I have a Linux box with the below configurations:-
Linux blrulvremoradb02 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux
Last time my UNIX administrator have done a partition in this box. I have 100GB lun allocated to this box which is spilitted in two mount points.
/u01 is having 30GB and /u02 is having 70GB. I want to build a ASM in this box and install Oracle 11.2.0.1 and for that I need raw disk.
Is there any useful links or can you guide me to achieve this... My UNIX admin is on leave for new year and I want to do this by my own..
SQL & PL/SQL :: Oracle Not Taking Next Extent Value Mentioned In Storage Clause?
Feb 16, 2012I am creating the below table.but why oracle is not taking next extent value that I mentioned in the storage clause?
create table acs (
timestamp varchar2(19),
source varchar2(19),
message varchar2(35),
sev varchar2(10),
[Code]....
Oracle 9i Install In Windows Storage Server 2003
Sep 24, 2006Oracle 9i instalation problems in Windows Storage Server 2003.
I got the error "ORA-12546- TNS:Permission denied" when trying to install ORacle 9i in Windows Storage Server 2003. This error occurs at the time of Creating database.
Automatic Storage Management :: Cannot Start ASM On Oracle Database Appliance
Apr 11, 2013I cannot start ASM on my Oracle Database Appliance.
crsctl status resource -t says:
ora.asm
ONLINE ONLINE node1 Started
ONLINE ONLINE node2 Started
however, if I try to access the ASMCMD it says:
[grid@node1 ~]$ asmcmd
Connected to an idle instance.
ASMCMD> startup
ORA-00304: requested INSTANCE_NUMBER is busy
Connected to an idle instance.
Automatic Storage Management :: Oracle ASM Create-disk Failed?
Oct 25, 2012I am using 11.2.0.1.0 on RHEL 5.4ASM is properly working on my machine. database is running from ASM. I want to configure additional oracleasm devices.command fails saying:
$ oracleasm createdisk ASMDISK08 /dev/xvd8
Writing disk header: done
Instantiating disk: failed
Clearing disk header: done
I am creating asm diskgroup on loopback devicesHere are the configured loopback devices.
[root@host1 ~]# ls -l /dev/loop[1-9]
brw-rw-rw- 1 oracle oinstall 7, 1 Oct 25 14:42 /dev/loop1
brw-rw-rw- 1 oracle oinstall 7, 2 Oct 25 14:42 /dev/loop2
brw-rw-rw- 1 oracle oinstall 7, 3 Oct 25 14:42 /dev/loop3
brw-rw-rw- 1 oracle oinstall 7, 4 Oct 25 14:42 /dev/loop4
[code]...
I am unable to understand where is the problem.
Storage Systems Used For Saving Archive And Backup Files Especially For Oracle Databases
Mar 5, 2013what type of storage systems used for saving archive files and backup files "especially for oracle databases"
View 5 Replies View RelatedAutomatic Storage Management :: Oracle ASM Normal / High And External Redundancy?
Jun 27, 2013, I have a few doubts in Normal,High and External redundancy levels in ASM concept. External - No failure group. No mirroring. Normal - Two Way Mirroring. One failure group. High - Three Way Mirroring. Two failure group. 1.
above mentioned 3 types in correct.2. My main question is what is the minimum number of disks needed in Disk group creation in Normal and External redundancy??