asm管理系列之——增加一个控制文件

最近在折腾asm，所以有些小小的心得，记录下来做个印象，与大家分享。

 

由于使用asm之后，不像以前，对于asm中文件不能以直接拷贝的方式来进行，所以中间有些小小的区别。

 

以下就是示范过程：

 

SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
+TEST_ASM/test_asm/controlfile/backup.261.652739057

SQL> select * from v$version;  

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1218292 bytes
Variable Size              79694092 bytes
Database Buffers           79691776 bytes
Redo Buffers                7168000 bytes
SQL> exit  
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@jusdoi dbs]$ rman

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Apr 22 21:03:27 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

 

RMAN> connect target

connected to target database: test_asm (not mounted)

RMAN> restore controlfile to '+TEST_ASM/test_asm/controlfile/control01.ctl' from '+TEST_ASM/test_asm/controlfile/backup.261.652739057';

Starting restore at 22-APR-08
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK

channel ORA_DISK_1: copied control file copy
Finished restore at 22-APR-08

 

RMAN> exit

Recovery Manager complete.

 

[oracle@jusdoi dbs]$ sqlplus /"As sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 22 21:05:31 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> alter system set control_files='+TEST_ASM/test_asm/controlfile/control01.ctl','+TEST_ASM/test_asm/controlfile/backup.261.652739057' scope=spfile;

System altered.

SQL> shutdown immediate;
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1218292 bytes
Variable Size              79694092 bytes
Database Buffers           79691776 bytes
Redo Buffers                7168000 bytes
Database mounted.
Database opened.
SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
+TEST_ASM/test_asm/controlfile/control01.ctl
+TEST_ASM/test_asm/controlfile/backup.261.652739057

 

其实也就是充分使用rman的功能。