Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

Automatic Storage Management (ASM) in Oracle Database 10g - Automatic Storage Management (ASM) is a new feature introduced in Oracle 10g to simplify the storage and administration of Oracle files.



Flavio Casetta said...

I think that for the sake of clarity, you should point out that block change tracking is not available in standard editions, but only in the enterprise edition.

Cheers,
Flavio Casetta

Tim... said...

I've now added a note about this.

Cheers

Tim...

Paul said...

Thanks for the article. Maybe you can also point out, what is the difference between DB instance and ASM instance; and how to log in the ASM instance. I don't see how to query the V$ASM views in the ASM instance.

Tim... said...

Hi.

You log into the ASM instance the same way you would a database instance. Set the ORACLE_SID and connect. It's in the article, where it explains how to create the ASM instance:

export ORACLE_SID=+ASM
sqlplus / as sysdba

Cheers

Tim...

Monash said...

Thanks Tim.. this article is like, all abt ASM under one roof

monash.unny@gmail.com

Monash said...

Tim .. "can we use ASM like a file system."

ie; For eg: cold backup the database, make changes to the database and if we want to revert back.. just shutdown the dasebase,delete the files and copy the backup.

Can we do this kind of operation using ASM ?
monash.unny@gmail.com

Tim... said...

No. It's not a regular filesystem, so you can't treat it like one.

Please ask questions in the forum, not in the comments.

Cheers

Tim...

LJ said...

Tim, great article.

Can you add in a section on how to initialize the disks to get them to the point where they can be added to a diskgroup? For example, before doing
CREATE DISKGROUP disk_group_1 NORMAL REDUNDANCY
FAILGROUP failure_group_1 DISK
'/devices/diska1' NAME diska1,
'/devices/diska2' NAME diska2,
FAILGROUP failure_group_2 DISK
'/devices/diskb1' NAME diskb1,
'/devices/diskb2' NAME diskb2;

Can you add a brief note about whether the disk needs to be unformatted or part of a LUN or ??? before being able to add it like you describe above.

Or perhaps it's more appropriate for another article?

JEO said...

Great article.
please can you throw more light on the
CREATE DISKGROUP statement for more clarity.Thank you.

oldbarrel said...

tim,

alias is removed using the 'drop alias' clause not delete alias as mentioned....

oldbarrel said...

mate, you can add a lot of key details regarding alias as it's one that confuses starters a lot...

a starting point, say, alias create after file creation would not reflect in v$asm_alias, v$datafile etc in db instance.....

good work.....

Amar Karnati said...

Tim,
Glad to see this concise and almost complete article.

dhjackal said...

Thanks Tim, great article.

There's a syntax error in your CREATE DISKGROUP command.

CREATE DISKGROUP disk_group_1 NORMAL REDUNDANCY
FAILGROUP failure_group_1 DISK
'/devices/diska1' NAME diska1,
'/devices/diska2' NAME diska2, -- remove comma
FAILGROUP failure_group_2 DISK
'/devices/diskb1' NAME diskb1,
'/devices/diskb2' NAME diskb2;

The comma after diska2 needs to be removed

Regards

dhjackal

Tim... said...

Hi.

Thanks for spotting the typo. It's corrected now.

Cheers

Tim...

gjilevski said...

Hello Tim,

Seems while migrating the database to ASM the redo log need to be either add/drop or renamed to ASM storage location from the original file system location. You took care of the controlfiles and datafiles only.

Regards,

gjilevski

Lenny said...

A great article. Anyone who needs assistance with ASM can drop me a line...

meta said...

Nice artice. There is something i was looking for and still dont understand.

What kind of preparation needs to be done with the disks before you can specify it for an ASM disk. I mean:
1. Can a partition of a disk be specified as an asm disk?
2. Does it need to be formatted with a filesystem and does it matter which filesystem is used? ext2/3/4/tempfs/ntfs/dos ?
3. Must it be mounted in OS ?

Tim... said...

Hi.

1) Yes.
2) No.
3) The device must be visible my the OS, but not mounted.

Any more questions, please ask in the forum.

Cheers

Tim...
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired