Saturday, April 2, 2016

Move spfile form disk to ASM


SQL> create spfile='+DATA/RACDB/spfileracdb.ora' from pfile='/u01/app/oracle/pfile.ora';

File created.

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

Total System Global Area 1653518336 bytes
Fixed Size                  2253784 bytes
Variable Size            1073744936 bytes
Database Buffers          570425344 bytes
Redo Buffers                7094272 bytes
Database mounted.
Database opened.
SQL>

No comments:

Post a Comment