Shulou(Shulou.com)05/31 Report--

This article introduces the knowledge of "how to migrate spfile from ASM to the file system". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

[oracle@node1 /] $su-oracle

[oracle@node1 /] $sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0-Production on Fri Sep 16 14:28:57 2011

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 > show parameter spfile; / / View the current parameter file storage path

NAME TYPE VALUE

-

Spfile string + DATA/oradb/parameterfile/spfi

Le.268.762004477

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@node1 /] $cd / u01/oracle/product/10g/dbs / / enter the system parameter file storage path

[oracle@node1 /] $cat initoradb.ora / / View the contents of the parameter file

Spfile=+DATA/oradb/parameterfile/spfile.268.762004477

[oracle@node1 /] $rm-rf initoradb.ora / / Delete the parameter file

[oracle@node1 /] $export ORACLE_SID=+ASM / / set the ASM instance environment variable

[oracle@node1 /] $asmcmd

ASMCMD > cd data/oradb/parameterfile / / enter the path where ASM parameter files are stored

ASMCMD > ls-lt / / View parameter file name

Type Redund Striped Time Sys Name

PARAMETERFILE MIRROR COARSE SEP 16 13:00:00 Y spfile.268.762004477

ASMCMD > exit

[oracle@node1 /] $export ORACLE_SID=oradb / / set the environment variable

[oracle@node1 ~] $sqlplus / as sysdba / / enter the database

SQL*Plus: Release 10.2.0.1.0-Production on Fri Sep 16 14:34:00 2011

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 > create pfile='/u01/oracle/product/10g/dbs/initoradb.ora' from spfile; / / create a pfile parameter file and specify the parameter file path and file name

File created.

SQL >! ls-lrt / u01/oracle/product/10g/dbs/initoradb.ora / / View the creation result

-rw-r--r-- 1 oracle oinstall 989 Sep 16 14:34 / u01/oracle/product/10g/dbs/initoradb.ora

SQL > shutdown immediate / / shut down the database

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL > exit

[oracle@node1 /] $export ORACLE_SID=+ASM / / set the ASM instance environment variable

[oracle@node1 /] $asmcmd

ASMCMD > cd data/oradb/parameterfile / / enter the parameter file

ASMCMD > ls-lt

Type Redund Striped Time Sys Name

PARAMETERFILE MIRROR COARSE SEP 16 13:00:00 Y spfile.268.762004477

ASMCMD > rm spfile.268.762004477 / / Delete the parameter file on the ASM instance

ASMCMD > exit

[oracle@node1 /] $export ORACLE_SID=oradb

[oracle@node1 ~] $sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0-Production on Fri Sep 16 14:34:00 2011

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

SQL >

SQL > create spfile='/u01/oracle/product/10g/dbs/spfileoradb.ora' from pfile='/u01/oracle/product/10g/dbs/initoradb.ora'; / / create SPFILE parameter file

File created.

SQL > startup / / Open the database

ORACLE instance started.

Total System Global Area 230686720 bytes

Fixed Size 1218676 bytes

Variable Size 71305100 bytes

Database Buffers 155189248 bytes

Redo Buffers 2973696 bytes

Database mounted.

Database opened.

SQL > show parameter spfile; / / View the migrated parameter file

NAME TYPE VALUE

-

Spfile string / u01/oracle/product/10g/dbs/sp

Fileoradb.ora

SQL > exit

[oracle@node1 dbs] $cd / u01/oracle/product/10g/dbs

[oracle@node1 dbs] $cat spfileoradb.ora / / View the contents of the migrated parameter file

? 2kk-oradb.__db_cache_size=155189248

Oradb.__java_pool_size=4194304

Oradb.__large_pool_size=4194304

Oradb.__shared_pool_size=62914560

Oradb.__streams_pool_size=0

* .audit_file_dest='/u01/oracle/product/admin/oradb/adump'

* .background_dump_dest='/u01/oracle/product/admin/oradb/bdump'

* .compatible='10.2.0.1.0'

* .control_files='+DATA/oradb/controlfile/backup.259.762002877'#Restore Controlfile

* .core_dump_dest='/u01/oracle/product/admin/oradb/cdump'

* .db_block_size=8192

* .db_create_file_dest='+DATA'

* .db_create_online_log_dest_1='+DATA'

* .db_domain=''

* .db_file_multiblock_read_count=16

* .db_name='oradb'

* .db_recovery_file_dest_size=2147483648

* .db_recovery_file_dest='+DATA'

* .dispatchers=' (PROTOCOL=TCP) (SERVICE=oradbXDB)'

* .job_queue_processes=10

* .open_cursors=300

* .pga_aggregate_target=75497472

* .processes=150

* .remote_login_passwordfile='EXCLUSIVE'

* .sga_target=228589568

* .undo_management='AUTO'

* .undo_tablespace='UNDOTBS1'

* .user_dump_dest='/u01/oracle/product/admin/oradb/udump'

So much for the introduction of "how to migrate spfile from ASM to the file system". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.