Exadata :: Move Partition From HP Disks To HC Disks

Jun 27, 2012

We have Exadata -V2 quarter rack with High Performance Disks. We applied EHCC's various compression methods on some of the table's partitions.

Now we are setting up Exadata Expansion Rack - High Capacity Disks. Post implementation, we would be moving older partitions to new Expansion Rack wherein compressed partitions are also included.

In this case, would there be any impact on the compression ratio as the expansion rack is having high capacity disks.

And, moving partition method would be same as it is for non-exadata database i.e. "alter table <table_name> move partition

<partition_name> tablespace <tablespace_name>"

View 2 Replies


ADVERTISEMENT

Exadata :: How To Find Disks Are HC Or HP

Oct 21, 2013

Is there any command to identify the disks are HC OR HP ? Indirectly i could find with the following exercise -

 $ grep -i MACHINETYPES /opt/oracle.SupportTools/onecommand/databasemachine.xml  <MACHINETYPES>X2-2 Half rack</MACHINETYPES> ASMCMD> lsdgState    Type    Rebal  Sector  Block       AU  Total_MB   Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  NameMOUNTED  NORMAL  N         512   4096  4194304  18235392  10597264          2605056         3996104              0             N  DATA/MOUNTED  NORMAL  N         512   4096  4194304   2087680   2085808           298240          893784              0             Y  DBFS_DG/MOUNTED  NORMAL  N         512   4096  4194304  27240192  18871860          3891456         7490202              0             N  RECO/ = 45TB  >>

[URL] .......  >> Page 5 >> HP SAS disks

View 2 Replies View Related

New DB - How To Partition Raw Disks

Jan 10, 2012

I am a new Oracle DBA that has been tasked with creating some single node databases for our programmers to connect to. I have never built a database, only upgraded. I will be using a Dell 610 with 10.2.0.4 software. I have been reading the install guides but cannot find a definitive answer for how to create the raw partitions. I have a SAN that I can utilize and my current db is set up with RAID 6 like so:

Disk 2 300 GB 1 Extended 300 GB and 5 logical, 100MB, 30 MB, 100 GB, 100 GB, 100 GB
Disk 3 100GB 1 Extended 100 GB and 3 logical 100 MB, 30 MB, 100 GB

why the old DBA partitioned this way? I am not good with storage and know that I need to understand before I build new databases so I do not duplicate something that is wrong. I was reading articles that recommend SAME but would not know how to do that on the SAN.

I will be using data pump to export the database and import to the new server. I was looking at using transportable tablespaces to do this. Would you recommend that from the cluster to the standalone?

View 4 Replies View Related

Exadata :: Uncompress Sub-partition Table After Restoring Exadata To Non-exadata Storage?

Dec 24, 2012

One of my databases which is running on exadata x2-2 , has been restored to non-exadata machine in order to test few things. I had a sub-partition table in the exadata , compressed for query high. test machine (NOT EXADATA) , after uncompressing this subpartiton tables i am getting the following err message :

ORA-64307: hybrid columnar compression is not supported for tablespaces on this storage type I have executed the following commands :
alter table crm.cm_ncd modify partition P01_CM_NCD nocompress;
alter table crm.cm_ncd modify partition P02_CM_NCD nocompress;
alter table crm.cm_ncd modify partition P03_CM_NCD nocompress;

[code]...

ERROR at line 1:
ORA-12801: error signaled in parallel query server P005
ORA-64307: hybrid columnar compression is not supported for tablespaces on this storage type If all the partitions are uncompressed why i am getting this error message ?

View 1 Replies View Related

Creating ASM Disks From NFS Mounted Files

Jul 25, 2010

Regarding 11gR2 RAC, ASM, and NFS. Installing 11gR2 Grid Infrastructure and 11gR2 RAC on OEL 5.5 servers with storage supplied by NetApp NFS shares over TCP/Ethernet.

How do I mount NFS file systems as block devices so ASM will use them?

It is my understanding that Linux mounts NFS file systems as anonymous file systems rather than block devices. ASM requires block devices. The only way I know to have Linux treat an anonymous file system mounted over NFS as a block device is to subsequently mount it as a loop device.The Oracle 11gR2 documentation states, "ASM does not support loop devices". Without defining NFS mounts as loop devices, oracleasm createdisk complains the given file on the NFS mounted file system is not a block device when i run

/usr/sbin/oracleasm createdisk DATA /oradata/prod/data/disk01

where /oradata is an NFS mount from a NetApp volume defined in /etc/fstab and disk01 was created with the dd command.I followed the steps in section 3.3.1.2 'Creating Files on a NAS Device for Use with Oracle ASM' of the Oracle guide..

When I use asmca, it does not find any candidate disks with the search path set accordingly.If successfully implemented ASM using NFS shares for database disk groups from a NAS, Steps I followed are below.

In /etc/fstab:
server-ip-address:/vol/data /oradata nfs rw,bg,hard,nointr,tcp,nfsvers=3,timeo=600,rsize=32768,wsize=32768,actimeo=0 0 0
-- mount and verify. /oradata is mounted with specified options.
# mount -a
# mount
[code]...

Command fails with error message "File /oradata/prod/data/disk01 is not a block device." None of the OUIs (grid installer, asmca, or dbca) identify any disks as ASM candidate disks with the search string '/oradata/prod/data/*'. I also tried using '/*', '/oradata/*', '/oradata/prod/data/*' to no avail.

View 4 Replies View Related

Configuring Udev Rule For Raw Disks?

Jan 1, 2013

I am using oel 5.8, oracle 11.2.0.3. The raw disk permissions are getting changed when the node gets rebooted.I am trying to use udev rule to change the permission permanently but its not working.

CODE[root@VM-PAGRAC3 rules.d]# more 99-asm.rules
KERNEL=="sd", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p",*
RESULT=="SATA_VBOX_HARDDISK_VB7a29b7ae-de673b56_",
NAME+="oracleasm/disks/DSK1#" OWNER="grid"
GROUP="asmadmin" MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p",
RESULT=="SATA_VBOX_HARDDISK_VB36f5d134-4e0e4c43_",

[code].....

View 8 Replies View Related

Server Administration :: Switch Between Disks In A Diskgroup?

Aug 31, 2011

I have an Oracle database 11.1.0.6 with ASM storage.

SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for Solaris: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production

There is a disk group named +FRA which has only 1 disk (call it disk 0 for later references).

+FRA disk group is in type of EXTERNAL redundancy

I'd like to add another disk to +FRA disk group and copy all files stored in disk 0 to the new disk (call it disk 1 for ex.), then take off disk 0 (not use for +FRA disk group any more).

Expected result: there is only one disk 1 left in the +FRA disk group, with all the data from disk 0 and keep their original file names

View 5 Replies View Related

RAC & Failsafe :: ASM Candidate Disks Not Found On Grid Reinstall

Aug 27, 2011

I am trying to install 2-node 11gR2 RAC on CentOS 5.6 using VMWare Fusion. I'm in the middle of Grid Infrastructure installation and while choosing the ASM diskgroups I don't see any candidate disks but when I click on all disks i can see them but can't select them.

I tried installing the grid before and ended up with and issue running the root.sh on all the nodes so had to deconfigure the grid binaries using the rootcrs.pl and then deinstalled the grid software using the ./desintall utility.

when tried installing again ...I ran the cluvfy utility ..it doesn't show any errors.

View 2 Replies View Related

Real Application Clusters :: Number Of Local Disks

Jan 20, 2013

We are in preparation for the purchase of equipment for two- node Oracle10g RAC (on Windows Server 2008) and I need to configure the disks on servers. We have an existing EMC VNX5500 storage and SAN 8Gb switches.

My question is with how many disks to configure servers?Originally we planned four SSD discs (two in RAID 1 for OS and two in RAID 1 for locally Oracle home) for each node/server, and everything else on storage disks (Shared Disks Storage).

Whether it is necessary to have more local disks and for what? Where should be redologs files, archivelogs files, backup files…

Whether it is better server to be configured with six SSD disks:
-     two in RAID 1 for OS,
-     four in RAID 10 (or RAID 1) for locally Oracle home, archivelogs files, or something else…?

View 6 Replies View Related

ASMNMP Privileges - Running Dbca And Have Specified Which ASM Disks To Use For Data?

Nov 12, 2010

ASM instance SID = +ASM and the database installation was under SID =rdbms112

Im just in the process of running dbca and have specified which ASM disks to use for data, but then on the next screen of the dbca, im asked for the ASMNMP password,

the password for 'oracle' user is 'oracle' but im getting this message:

"Could not validate ASMNP password due to the following error: "ORA-01031-insufficient privilages" Do you want to continue? If you contiue ASM will not be configured to be moitored by database controll "

when I was asked for privilaged operating system groups when setting up ASM

OSDBA, OSOPER and OSASM ... were all set to group 'dba'

the oracle user is in the 'dba' group

View 2 Replies View Related

Server Administration :: How To Assign Size For Disks In Diskgroup

Mar 3, 2012

you have given 500gb of harddisk. how will u implement the size or how to assing the size for disks in the diskgroup.give me the best practice that is used in production

View 1 Replies View Related

Automatic Storage Management :: Prepare ASM Disks Using ASMlib And Oracleasm

Jun 28, 2012

Normally ASMlib/oracleasm is used to prepare the disks for ASM. I just wonder, besides this tool, is there any other GUI based tool to use for preparing the ASM disks?

View 2 Replies View Related

Automatic Storage Management :: Adding Disks To Existing Data Disk Group

Jun 19, 2012

I have 11.1.0.7 instance running and got more 300G of storage available for the database. I would like to know what are the steps to add these disks/storage to the existing DATA asm disk group?

View 5 Replies View Related

RAC/ASM Clusterware Installation :: Candidate Disks Disabled During Installation?

Nov 17, 2013

We're trying to utilize Oracle RAC 11.2. We want to have two servers in our grid. These two server are installed on a VM using Hyper-V software.

common storage for asm is also developed on a VM using FreeNAS software.Now, when we try to install Grid Infrastructure the disk that is recognized as a extra drive in both servers are disabled and we can't select it as ASM storage. The OS we're using is Windows Server 2008 R2.I have to say the IP requirements are considered and the servers have two IPs.

View 0 Replies View Related

Exadata :: Compress Sub Partition With Pctfree

Nov 12, 2012

How to compress sub partition on exadata, using 'for query high' and pctfree 10 options? I used this statement, but I get only ORA-14160:this physical attribute may not be specified for a table subpartition.

alter table table_name move subpartition subpartition_name PCTFREE 10 compress for query high;

View 9 Replies View Related

Exadata :: Compression And Partition Row Movement?

Mar 6, 2013

If I have a Partitioned Table set as COMPRESS FOR QUERY/ARCHIVE HIGH what would be the impact when a row in Partition X has to move to Partition Y?

View 3 Replies View Related

SQL & PL/SQL :: ORA-14257 - Cannot Move Partition

May 18, 2012

I want to move partitions and subpartitions to different tablespace but I am getting error when I am trying to move PARTITION tablespace after on move of subpartition tablespace.

CREATE TABLE IN_TEST
(
LINE_SKU_SEQ NUMBER NOT NULL,
REGION_CODE VARCHAR2(10 CHAR) NOT NULL
)
TABLESPACE USER02
PARTITION BY RANGE (REGION_CODE)
SUBPARTITION BY HASH (LINE_SKU_SEQ)
(
PARTITION REGION_AMERICAS VALUES LESS THAN ('AMER_')
STORAGE (
BUFFER_POOL DEFAULT
[code]....

ORA-14257: cannot move partition other than a Range, List, System, or Hash partition

View 1 Replies View Related

SQL & PL/SQL :: Move Partition Of One Fact Table To Another?

Aug 30, 2011

I have two fact table and both are partitioned on same key and have same columns. Is it possible to move the partition of one fact table to another.

View 2 Replies View Related

SQL & PL/SQL :: Move Data From One Partition To Other In A Table

Jul 22, 2010

I want to move data from one partition to another partition in a same table.

Ex: Table A has Partitions P1 and P2. I want to move data from P1 to P2.

Is this is possible?

View 3 Replies View Related

PL/SQL :: Move Partition From One Tablespace To Other Along With Lob Data?

Jan 4, 2013

I have a range partitioned table with one lob column. Each partion is on a separate tablespace except two partitions which are on same tablespace. Now I want to move a partition from one tablespace to another tablespace along with lob data. By using a simple alter table move partition will also move the lob data or there is some special procedure to adopt.

View 9 Replies View Related

Server Administration :: Move Partition To Cache

Feb 28, 2012

How to move a partition of a table to db_keep_cache ?

View 8 Replies View Related

How To Move Offline Table Partition In Oracle 11gR2

Sep 17, 2012

OS=Windows 2003
DB = 11gR2

We got a request to take offline for few unused partitions and move it to a another drive (lease used).Please set the following partitions offline in PreProd:

MONTH_20110901
MONTH_20111001
MONTH_20111101
MONTH_20111201
MONTH_20120101
MONTH_20120201

Please move the offline partitions to the E disk.How can we do this ?

View 9 Replies View Related

Exadata :: How To Find Exadata RACK Mode

Oct 17, 2013

This is the below method which I have used to figure out exadata model. 

ex:  grep -i MACHINETYPES /opt/oracle.SupportTools/onecommand/databasemachine.xml <MACHINETYPES>X3-2 Half Rack HP</MACHINETYPES> 

But for one environment, though it is a full rack but still I am getting result as half rack.

View 3 Replies View Related

Exadata :: Import Data To Exadata

May 6, 2013

I am having an Oracle 11g R2 RAC setup. My database size is 22TB in normal servers. I have checked my database in Exadata X2-2 and found out that the HCC was good and as per my assumption the 22TB can come down to 10TB .

My challenge is i need to transfer the 22TB data to the exadata quater rack which is having space constraint. Is there any way other than export & Import as data export and import will use entire 22TB. Is there any way to transfer the data to Exadata with compressed form from the source server.

View 6 Replies View Related

Exadata :: NO_INDEX Hint In Exadata

Jul 19, 2013

I am having doubt on the no_index concept in oracle. I am using oracle exadata server.It is basically data warehouse project.I am in the situation to join some tables and get the result set for reporting purpose.

Among the tables, 2 tables having huge count.1st table has more than  - 1,000,000,000 rows2nd table has more than  - 200,000,000 rows when i join these 2 tables with some small set of tables, it is taking long time (around 20 MIN) to retrieve the result set. The final result set is around 100 rows only.

But, when i force NO_INDEX hint in the same query, is giving the same result in very fast manner(around 5 MIN). Because it is working based on cell smart scan. So, can i force the NO_INDEX hint to all tables? I forced the NO_INDEX hint only the table which is contain 200,000,000 rows not for others.

Query Plan : Normal Query using the the range scan based on the key. No_INDEX Query going full table scan.

View 5 Replies View Related

Exadata :: Exadata With Multi User

Jun 14, 2013

I would like to know if I can create one OS user by ORACLE_HOME database ?

View 3 Replies View Related

Exadata :: Task On Exadata

May 12, 2013

Tasks need to performs are

1) Post Installation check list ie: How can I see every things are installed correctly.
2) upgrade the exadata OS version .
3) Upgrade the Database.
4) Test Migration from Oracle database to Exadata.
5) Right now there RAC servers are installed without domain, I need to add domain name to existing RAC.

View 7 Replies View Related

SQL & PL/SQL :: Dropping Sub-partition / Range-partition And List Sub-partition

May 28, 2010

i have table with range partition and list sub-partition..can i add one more list sub-partition if it is not possible , i have to drop first sub-partition.

View 6 Replies View Related

SQL & PL/SQL :: Create Normal Partition Range On Date And Sub Partition List On Batch ID

Mar 17, 2011

I Know we can create dynamic partitions on table in oracle 11g. Is it possible to create normal partition and sub partition both dynamically.I have to create Normal partition range on date and sub partition list on Batch ID (varchar).

View 3 Replies View Related

Performance Tuning :: Select Partition Table With Non-partition Key Condition?

Jun 26, 2010

I have a table that partitioned into six partitions. each partitions placed in different table space and every two table space placed it on a different hardisk

when I will do query select with the non-partition keys condition, how the search process ? whether the sequence (scan sequentially from partition 1 to partition 6) or partition in a hardisk is accessed at the same time with other partition in other hardisk. ( in the image, partition 1,4 accessed at the same time with partition 2,5 and 3,6)

View 3 Replies View Related







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