Перемещение SPFILE в ASM

[oragrid]$
[oragrid]$ export ORACLE_SID=+ASM
[oragrid]$ asmcmd
ASMCMD> cd +
ASMCMD> ls -l
State Type Rebal Name
MOUNTED EXTERN N DATA/
MOUNTED EXTERN N FRA/
MOUNTED EXTERN N REDOA/
MOUNTED EXTERN N REDOB/
ASMCMD> find --type parameterfile . *
ASMCMD>

[oradb]$
[oradb]$ ls -l /tmp/inittestasm.ora
-rw-r--r-- 1 oradb oinstall 2788 Oct 26 12:31 /tmp/inittestasm.ora
[oradb]$

[oradb]$ export ORACLE_SID=testasm
[oradb]$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Oct 26 14:11:56 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL>
SQL> startup pfile='/tmp/inittestasm.ora';
ORACLE instance started.

Total System Global Area 595591168 bytes
Fixed Size 2085744 bytes
Variable Size 176163984 bytes
Database Buffers 411041792 bytes
Redo Buffers 6299648 bytes
Database mounted.
Database opened.
SQL>


SQL> create spfile='+DATA' from pfile='/tmp/inittestasm.ora';

File created.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oradb@x4450-p2 tmp]$

ASMCMD>
ASMCMD> find --type parameterfile . *
+DATA/TESTASM_P/PARAMETERFILE/spfile.276.733413321
ASMCMD>

ASMCMD>
ASMCMD> cd +DATA/TESTASM/
ASMCMD> ls -l
Type Redund Striped Time Sys Name
Y CONTROLFILE/
Y DATAFILE/
Y TEMPFILE/
ASMCMD> mkalias +DATA/TESTASM_P/PARAMETERFILE/spfile.276.733413321 spfiletestasm.ora
ASMCMD> ls -l
Type Redund Striped Time Sys Name
Y CONTROLFILE/
Y DATAFILE/
Y TEMPFILE/
N spfiletestasm.ora => +DATA/TESTASM_P/PARAMETERFILE/spfile.276.733413321
ASMCMD>


[oradb]$
[oradb]$ more /u01/app/oradb/product/10.2.0/db_1/dbs/inittestasm.ora
SPFILE='+DATA/testasm/spfiletestasm.ora'
[oradb]$

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

Total System Global Area 595591168 bytes
Fixed Size 2085744 bytes
Variable Size 176163984 bytes
Database Buffers 411041792 bytes
Redo Buffers 6299648 bytes
Database mounted.
Database opened.
SQL>
SQL>