1,asm支援file的型別

[@more@]

file type default templates

-------------------------------------------------------------------------------------

control files controlfile

data files datafile

redo log files onlinelog

archive log files archivelog

temporary files tempfile

data file backup piece backupset

data file incremental backup piece backupset

archive log backup piece backupset

datafile copy datafile

persisent initialization parameter file(spfile) paramemetr

flashback logs flashback

change tracking file changetracking

data pump dumpset dumpset

automatically generated control file backup autobackup

cross-platform transportable data files xtransport

flash file flashfile

oracle asm persistent initialization parameter file(spfile) asmparameterfile

oracle asm persistent initalization parameter file(spfile) backup asmparameterfilebackup

oracle cluster registry file ocrfile

oracle asm dynamic volume manager volumnes n/a

2,asm不支援file的型別

trace files,audit files,alert logs,export files,tar files and core files

3,管理alias

SQL> alter diskgroup data drop alias '+data/asm/datafile/users03.dbf';

Diskgroup altered.

SQL> alter diskgroup data add alias '+data/asm/users03.dbf' for '+data/asm/datafile/USERS.275.806250997';

Diskgroup altered.

SQL> alter diskgroup data rename alias '+data/asm/users03.dbf' to '+data/asm/user03.dbf_alias';

Diskgroup altered.

SQL> alter diskgroup data drop file '+data/asm/user03.dbf_alias';

Diskgroup altered.

4,管理directory

SQL> alter diskgroup data add directory '+data/alias';

Diskgroup altered.

SQL> alter diskgroup data rename directory '+data/alias' to '+data/alias_backup';

Diskgroup altered.

SQL> alter diskgroup data drop directory '+data/alias_backup';

Diskgroup altered.

5,管理templates

When adding a template to a disk group, the attributes are optional. If no redundancy

attribute is specified, then the value defaults to MIRROR for a normal redundancy disk

group, HIGH for a high redundancy disk group, and UNPROTECTED for an external

redundancy disk group. If you do not specify a striping attribute, then the value

defaults to COARSE. If you do not specify a value for the primary or mirror region

attributes, then the value defaults to COLD and MIRRORCOLD respectively

SQL> alter diskgroup data add template reliable attribute(unprotected);

Diskgroup altered.

SQL> alter diskgroup data modify template reliable attribute (coarse);

Diskgroup altered.

SQL> alter diskgroup data drop template reliable;

Diskgroup altered.

asm files,asm directories,asm templates

相關文章