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..... |
Don't ask technical questions here, that's what the forum is for!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!
