Utilizing new SPFILE for migration

Story: Migration Oracle10g non-ASM database to ASM on Linux86Total Replies: 0
Author Content
dba477

Nov 08, 2004
1:34 AM EDT 		SQL> create pfile='$ORACLE_HOME/dbs/inittest.ora' from 2 spfile='$ORACLE_HOME/dbs/spfiletest.ora' 3 / File created. $cd $ORACLE_HOME/dbs $vi inittest.ora

Add entries:-

*.CONTROL_FILES='+DATA1/controlf01' *.DB_CREATE_FILE_DEST='+DATA1' *.DB_CREATE_ONLINE_LOG_DEST_1='+DATA1'

Save file



$mv spfiletest.ora spfiletest.ora.orig

SQL> shutdown immediate; SQL> startup nomount SQL> create spfile='$ORACLE_HOME/dbs/spfiletest.ora' from 2 pfile='$ORACLE_HOME/dbs/inittest.ora' 3 / File created. SQL> quit

Posting in this forum is limited to members of the group: [ForumMods, SITEADMINS, MEMBERS.]

Becoming a member of LXer is easy and free. Join Us!