Create ASM Disk Using OracleASM

Jun 2, 2012

I'm trying to create a ASM disk using oracleasm.I created list the disk (using oracleasm), but the view V$ASM_DISK and ASMCMD (lsdsk command) can't see it..Look:

CODE$ oracleasm createdisk DISK3 /dev/sdc1
Writing disk header: done
Instantiating disk: done
CODE$ oracleasm listdisks
DISK1
DISK2
DISK3

Looks fine, but the ASMCMD doesn't listing it...

CODEASMCMD> lsdsk
Path
/dev/oracleasm/disks/DISK1
/dev/oracleasm/disks/DISK2

And the V$ASM_DISK can not...

CODESQL> select name from v$asm_disk;

NAME
------------------------------
DATA_0001
DATA_0000

View 4 Replies


ADVERTISEMENT

How To Create Ocr Disk Or Voting Disk On Windows Server 2008

Feb 17, 2011

I have 2 servers both having windows server 2008 64 bit as operating system installed on both I need to install oracle clusterware 11g r1 on both servers with clustering on external storage. I have configured the network(private,public and virtual) for both servers and have started the installation.

In the installation of oracle I add both servers but then I reach to a point where they ask me for voting disk or ocr disk in the cluster configuration storage but no disk is present how can i create ocr disk or voting disk on windows server 2008? And the external storage should I buy a special type of storage that supports clustering to continue my work?

View 2 Replies View Related

Server Administration :: How To Use LV To Create ASM Disk

Jul 27, 2012

How can use the LV to create a ASM disk in Red Hat Linux As 5

#lvcreate -n lv01 -L 200g myvg

View 3 Replies View Related

Windows :: Create ASM Disk Did Not Recognize Unallocated Partition

Jan 21, 2012

This is the first time I've got a job in Windows platform, I've worked as DBA with Unix/Linux still now.

I received one command: Install Oracle 11gR2 on Windows 7 Enterprise, so that, I plan to create one Partition (really, not mounted, this is Unallocated partition by Partition Magic 3rd software) which will contain datafile in it.

And, when I install 11gR2 Grid, the step ASM creation did not recognize the Unallocated Partition I created.

View 3 Replies View Related

Data Guard :: How To Create Another Standby With Max Disk Space

Nov 1, 2012

In my environment Oracle database 11gR1 is running & dg is configured i.e >> 1 primary & 1 standby. In near future space issues will arise for standby. I want to create 1 more standby with max disk space, but how? Active dataguard is configured where report are generated from where & what changes should be made in Primary pfile & new standby pfile.

View 2 Replies View Related

Install OracleASM In CentOS 6?

Apr 19, 2012

Can I install the oracleASM in centOS 6?

My kernel version is 2.6.32.

And the last version for oracleasm release is 2.6.18-308.1.1.el5. [URL] And they aren't compatible...

Are there any way to install these lib with this kernel version? (2.32...)?

View 1 Replies View Related

Performance Tuning :: Create Statements On A Highly Fragmented Disk

Nov 24, 2010

On Oracle 10g, I create, delete and drop a lot of tables. Therefore, the disk is highly fragmented.The execution of a very simple create statement takes more than a minute. If I execute the same statement but first truncate the table and insert the data, it takes less than a second!

I think this has to do with the high fragmentation of the disk. Obviously, I can defragment the disk, but I will always have a high fragmentation since I use a lot of create, delete and drops.

how I can improve the performance of create statements on highly fragmented disks?

View 7 Replies View Related

Automatic Storage Management :: Oracle ASM Create-disk Failed?

Oct 25, 2012

I 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.

View 11 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

Adding ASM Disk With Header Status MEMBER To Existing Disk Group

Aug 26, 2010

We have a Production Oracle 10g R2 RAC on HP-UX v2 IA64 servers.We have Two Disk Groups one for Archive (ARC_DISK - 100 GB) and other for Database(DATA_DISK - 1 TB]. We wanted to add more space to the DATA_DISK disk group.Unix admin configured 200 GB from SAN and changed the ownership of the Disk to oracle and permissions to 775 on 1st Node.I opended DBCA from 1st Node and was able to see the disk in 'Show Candidate'.

I added this disk to the DATA_DISK disk group and clicked OK but got ORA- error with some message like some operations could not be performed. I exited DBCA.We realized that we had forgotten to change the ownerhip and permission from the 2nd Node.Unix admin changed the ownership of the Disk to oracle and permissions to 775 on the 2nd Node.

I opened DBCA again from 1st Node and selected the DATA_DISK disk group but could not find the Disk in 'Show Candiate' open. I clicked on 'Show All' and this disk was shown with Header_Status - MEMBER but not allocated to DATA_DISKGROUP. When I clicked the 'Show Member' option, this disk is not shown for DATA_DISK disk group. I exited DBCA at this point.As this is a critcal Production database I didnt proceed any further and exited DBCA.

Now I need to add this Disk to the DATA_DISK disk group but not sure which option to select. I got one reply from another forum to run DBCA select the DATA_DISK Disk Group and then click 'Show All' and select this Disk (which already has MEMBER as Header Status) and select Force Option and click OK to continue.

View 4 Replies View Related

Server Administration :: Disk Group With Two Disk For Normal Redundancy

Jan 16, 2013

I Configured an ASM instance and a disk group with two disk for normal redundancy.

> Here .. each disk is 2gb

The disk group has two disks...

SQL> select group_number, name, type, total_mb, free_mb
2 from v$asm_diskgroup;

GROUP_NUMBER NAME TYPE TOTAL_MB FREE_MB
------------ ------------------------------ ------ ---------- ----------
1 DATA NORMAL 4000 3898

as the group has two way mirroring (Normal redundancy) How much data (2 GB or 4 GB) can i keep in the disk group? My conception is I can keep 2 GB data in the disk group... (as the disk group keeps every extent in another disk as mirror)

View 3 Replies View Related

To Add One Disk Group Space To Another Disk Group

May 9, 2011

Is there any way to add one disk group space to another disk group. Because One of my disk group is full i want to add space in to that group.

View 1 Replies View Related

Migrate To Another Disk

Nov 15, 2006

Lets say I have an oracle setup on C: and I decided to delete the oracle in c: and setup a whole new oracle at E: but I want all the data migrate to the new oracle installation in E: How can I perform that?

View 1 Replies View Related

Difference Between ADD DISK And ADD VOLUME

May 27, 2013

I have a question about the ADD VOLUME command, I can't understand the difference between ADD DISK and ADD VOLUME.What are the difference between them?When should I use each one?How can I control the stripping and mirroring (NORMAL and HIGH) adding VOLUMES in a DISKGROUP?Can I add a volume to a fail group?

View 1 Replies View Related

ASM Disk-groups / RAID?

Feb 25, 2011

We have a new implementation which will be using ASM with RAID. The data area needs to be 3TB, and the recovery area, to be used for archive logs and RMAN backups, needs to be 1TB.

The configuration i'm thinking about now is:

+DATA diskgroup: 5*600G disks, using RAID 1+0 (this will include control files)
+FRA diskgroup: 2*500G disks, using RAID 1
+LOG diskgroup: 2*1G disks, using RAID 1 (this is only for redo logs)

So here are my questions:
1. Am I right in supposing that we would get the best performance on the +FRA and +LOG diskgroups by not using RAID 1+0?
2. It has already been agreed to use RAID 1+0 for the +DATA diskgroup, but I can't see the added benefit of this. ASM will already stripe the data, so surely RAID 0 will just stripe it again (i.e double striping the data). Would it not be the better just to mirror the data at a hardware level?

View 4 Replies View Related

RMAN Disk / Tape?

Apr 25, 2011

I just made the swich to have my RMAN backup directly to tape and here are the parameters I have set.

CODECONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F';
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default

[code]...

When I do an active clone I need to set my parameters back to the following in order to makeit work.

CODECONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

[code]....

Instead of un-doing my RMAN TAPE settings, is there something I can do in my active clone script to tell it read/write from/to disk instead of tape. I tried allocatiing disk channels but was unable to get my script to work. The only way it worked was to back out all the tape settings and put everything back to disk.

CODErman catalog=rman/rman@prod target=sys/sys@prod << EOT
connect auxiliary sys/sys@dev
duplicate target database to dev from active database nofilenamecheck
pfile=/u01/app/oracle/product/11g/dbs/initdev.ora;
 exit

View 4 Replies View Related

RAC & Failsafe :: Adding New ASM Disk

Dec 23, 2012

I have DB on cluster and it set to active/active. ASM disk currently using raw device and connect to SAN storage. So i want to add new ASM disk on current environment.

Does oracle have this doc? What i can see from their said just show adding new ASM to new installation. Does it same as adding new ASM disk to current system? Does it success on implementation?

View 1 Replies View Related

RMAN :: Backup To NFS Disk

Sep 11, 2012

We are running oracle 10g on a solaris system. We were taking the backup to the tape system previously. But the tape system is broken due to some reasons and cannot be used now. Now I am trying to take a rman full backup with archivelog to a NFS disk. The server in which the NFS disk lies is in Ubuntu. I have also considered that there is some problem with the NFS rman backup but can be solved by using hard and noac while mounting. Now I wanted to know is, what parameters should be changed to direct the backup sets to the new location in NFS instead of the old disk ? Do I need another media manager as in tape?

View 4 Replies View Related

Configure RMAN Backup To Disk?

May 27, 2011

Am trying to configure rman to backup to a directory to a linux server on the network. Database is on windows server. Here is the parameter changes

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '\\204.47.240.126\bexdisk\backup\%U'
;
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/oraback/rman/sde_backups/%U';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

Here is my rman script

ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
run
{
crosscheck archivelog all;

[Code]....

instead its backups but to my ORACLE_HOME\database directory..

how to configure rman to backup to this location

View 1 Replies View Related

RAC & Failsafe :: Changing Disk Paths In ASM

Jul 13, 2012

We are about to undertake a storage migration of our RAC environment from EMC to XIV storage.

The migration method we are using means that we will be presented with identical disks post the migration, however the UNIX paths to the disk devices will be changing. Using our migration method it is not possible to present the old and new devices at the same time.

Therefore once the migration is complete i need to update the device configuration to reflect the new paths. I believe this is done using the following techniques but I am unsure as some of the documentation is ambiguous and I have not done this before

Changing path to Voting Disks

crsctl add css votedisk <new_path_to_disk> -force
crsctl delete css votedisk <old_path_to_disk> -force

Changing path to OCR Disks

ocrconfig repair ocr <new_path_to_ocr>
ocrconfig repair ocrmirror <new_path_to_ocrmirror>

Changing paths to ASM disks

alter system set asm_diskstring='<new_device_path>' scope=both;

View 3 Replies View Related

Server Administration :: Adding Disk In ASM

Oct 16, 2012

I checked and found we have disk that is assigned with 0 disk GROUP_NUMBER. What does that mean ? how to check if disk T1_ASM05 is been part of any disk group or not.?

SQL> select GROUP_NUMBER,NAME from v$asm_diskgroup;

GROUP_NUMBER NAME
------------ ------------------------------
1 DATA
2 FRA
SQL>
SQL> select GROUP_NUMBER,name,PATH from v$asm_disk;

GROUP_NUMBER NAME PATH
------------ ------------------------------ -------------------------
1 T1_ASM01 ORCL:T1_ASM01
2 T1_ASM02 ORCL:T1_ASM02
0 ORCL:T2_BACKUP01
0 ORCL:T1_ASM04
0 ORCL:T1_ASM03
0 ORCL:T1_ASM05

6 rows selected.

SQL> !
/home/oracle > /etc/init.d/oracleasm listdisks
T1_ASM01
T1_ASM02
T1_ASM03
T1_ASM04
T1_ASM05
T2_BACKUP01
/home/oracle >

View 1 Replies View Related

Server Administration :: How To Add Disk To ASM Diskgroup

Jun 7, 2011

Resize or add disk in ASM.

- The storage has partitions like:
- And now, the size of ASM disk was full

Because I've not ever done for adding disk to diskgroup.

Step 1- Format the storage, add partitions (I will create 4 partitions of 120gb, 1 partitions 60gb, 1 partitions 27gb).

Step 2- Add the rawdevice in /etc/sysconfig/rawdevices.In the picture here, I'll not just add rawdevice in /etc/sysconfig/rawdevices. So I'll do:

add lines in /etc/sysconfig/rawdevices

/dev/raw/raw7 /dev/cciss/c0d1p9
/dev/raw/raw8 /dev/cciss/c0d1p10
/dev/raw/raw9 /dev/cciss/c0d1p11
/dev/raw/raw10 /dev/cciss/c0d1p12
[code]....

how to do continue after step 5.

View 5 Replies View Related

Oracle Solid State Disk

Feb 1, 2013

I understand the architecture of solid state drives favor different types of I/O. Oracle 11g introduced the database flash cache which allows flash storage to be used as a secondary cache. With database flash cache serving as a secondary cache to my Oracle buffer cache.

My understanding is I need to config two database parameters DB_FLASH_CACHE_FILE and DB_FLASH_CACHE_SIZE. If i want to have certain tables/indexes to take advantage of this extra cache I would set the value KEEP within the parameter.

Is there anything that needs to be done to the tablespaces / datafiles.

View 1 Replies View Related

Recliam The Space In Hard Disk

Nov 26, 2010

I have droped the tablespace like 60gb size. using following command

DROP TABLESPACE TS_MKT_CM_SERVICE_TB
INCLUDING CONTENTS AND DATAFILES;

but the space is not recliamed in disk. still i have same size in hard disk. how to reclim the space to hard disk..?

View 4 Replies View Related

Deleting Archive Logs From Disk

Feb 13, 2013

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
PL/SQL Release 11.2.0.3.0 - Production
"CORE     11.2.0.3.0     Production"
TNS for 32-bit Windows: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

We are in the process of setting up our backup policy. After the Archived Logs have been backed up, we need to delete them after 7 days. Also the actual files on disk.

RMAN does not delete the Archived Logs from disk.

View 6 Replies View Related

Total Disk Space Used By A Database

Sep 27, 2012

11.1.0.7

Is this the command to check the total size of disk space a database have used.

select sum(bytes) from dba_data_files;

Is the temp size included?

View 11 Replies View Related

Reclaiming Actual Physical Disk Space

Sep 2, 2011

I look after a team of DBAs and I have a request to free up space on our very expensive storage system. However the answers on how to do this differ and i'd like to ask for external input...So not being a techincal person I see the world as quite black and white. Meaning that you delete data and you free space but after doing much reading I understand this is not the case, as you essentially create data fragmentation within the datafile resulting in the db having lots more space to write into but not actually freeing space, even if you shrink the file it doesnt free space or do a reorg?

We have as an example a DB with 2 billion rows of data in 1 table, no partioning just one large table. We have worked out that we can probably delete 1 billion rows or even better only keep a rolling 3 month window of data. What would be the suggestion on deleting this data and reclaiming the disk space to actually see additional disk space made available at the os level.

How about deleting the data and reclaiming the space. Through reading it looks like it might be something like, delete, creating new table space partitions from this data. This in theory would create new a tablespace in newly created data files which would result in the data being reorganised and taking up less physical space and when completed you point to the newly created partitions and drop the old tables.

how they have done this as it must be a common problem that people have created some different solutions. What commands, procedures have been used?

View 2 Replies View Related

Secure Backup Only For Tape Drive Not For Disk

Oct 27, 2010

Is oracle providing secure backup only for Tape drive not for disk(means Hard-disk),configure oracle secure backup.

View 1 Replies View Related

Forms :: Run Form Saved On Network Disk?

Dec 2, 2010

we are testing the oracle developer tools 11g and we have the followed issue.

If we run a form saved on the local disk, it's running properly but if we save the form on a local disk we get FRM-40010 Cannot read form XXXX.

Example:

TEST.fmx on C:Temp (Local disk) is running
TEST.fmx on T: (Network disk) FRM-40010

View 4 Replies View Related

SQL & PL/SQL :: Drop Schema And Reclaim Disk Space?

Jun 29, 2011

I need to drop one of the schema with 700 tables. There are other schemas in same database and tablespaces are shared across.

How can I reclaim the disk space after dropping the particular schema?

View 4 Replies View Related







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