oracle11gasm,oracle11gASM管理

ARCHIVELOG UNPROT COARSE NOV 29 19:00:00 Y thread_1_seq_212.490.768511059

ARCHIVELOG UNPROT COARSE NOV 29 19:00:00 Y thread_1_seq_213.493.768512249

ARCHIVELOG UNPROT COARSE NOV 29 19:00:00 Y thread_1_seq_214.494.768512253

ARCHIVELOG UNPROT COARSE NOV 29 22:00:00 Y thread_1_seq_215.499.768522885

ARCHIVELOG UNPROT COARSE NOV 29 00:00:00 Y thread_2_seq_100.488.768443301

ARCHIVELOG UNPROT COARSE NOV 29 19:00:00 Y thread_2_seq_101.491.768511059

ARCHIVELOG UNPROT COARSE NOV 29 19:00:00 Y thread_2_seq_102.492.768511065

ARCHIVELOG UNPROT COARSE NOV 29 22:00:00 Y thread_2_seq_103.495.768522877

ARCHIVELOG UNPROT COARSE NOV 29 22:00:00 Y thread_2_seq_104.496.768522879

ARCHIVELOG UNPROT COARSE NOV 29 22:00:00 Y thread_2_seq_105.497.768522883

ARCHIVELOG UNPROT COARSE NOV 29 22:00:00 Y thread_2_seq_106.498.768522883

ARCHIVELOG UNPROT COARSE NOV 29 00:00:00 Y thread_2_seq_99.484.768443235

ASMCMD>

--控制文件路径CONTROLFILE :

ASMCMD> cd racdb

ASMCMD> ls -l

Type Redund Striped Time Sys Name

N control01.ctl => +ORADATA/RACDB/CONTROLFILE/Current.256.739387263

N control02.ctl => +ORADATA/RACDB/CONTROLFILE/Current.257.739387265

查看初始化参数文件位置, 实际文件也是类似软链接方式:

SQL> show parameter control

NAME TYPE V ALUE

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

control_files string +ORADATA/racdb/control01.ctl,

+ORADA TA/racdb/control02.ctl

如何增加控制文件呢？例子如下：

SQL> alter database mount database;

SQL> alter database backup controlfile to '+ORADATA/racdb/control02.ctl';

SQL> alter database backup controlfile to '+ORADATA/racdb/control03.ctl';

SQL> alter system set control_files='+ORADA TA/racdb/control01.ctl','+DATA/racdb/control02.ctl','+DATA/racdb/control03.ctl'

scope=spfile;

SQL> startup mount

--数据文件路径DA TAFILE :