�� Oracle10g non-ASM database � ASM database (oracle database) (�� )

Sat, 20 Nov 2004 09:18:36 GMT

�� JWH:-

Perform backup of database to be able remove old redo logs

�� ASM �� "Autoarchiving". � �� :-
SQL> alter system switch logfile;
��
Redolog ��.

�� SPFILE �� ASM �� (�� )

Sat, 20 Nov 2004 09:09:34 GMT

��:-

$cp /u01/app/oracle/admin/convdata/pfile/init.ora.929200412032 \
> $ORACLE_HOME/dbs/initconvdata.ora
$cd $ORACLE_HOME/dbs
Add following entries to initconvdata.ora :-
CONTROL_FILES='+DATA1/controlf01'
DB_CREATE_FILE_DEST='+DATA1'
DB_CREATE_ONLINE_LOG_DEST_1='+DATA1'
$ mv spfileconvdata.ora spfileconvdata.ora.orig

��:-

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.

OpenForum RSS: ������������ �������: �������� ������ SPFILE ��� ASM �����������

����������� Oracle10g non-ASM database � ASM database (oracle database) (�������� �����)

�������� ������ SPFILE ��� ASM ����������� (�������� �����)

OpenForum RSS: �� : �� SPFILE �� ASM ��

�� Oracle10g non-ASM database � ASM database (oracle database) (�� )

�� SPFILE �� ASM �� (�� )