KEMBAR78
Steps To Convert Your Oracle Database From FS To ASM | PDF
Scribd
Upload
34 views2 pages

Steps To Convert Your Oracle Database From FS To ASM

The document outlines the steps to convert a file system to Automatic Storage Management (ASM) in an Oracle database. It includes commands for setting control files, creating backups, switching to ASM, and managing log files. The process involves using RMAN for restoration and configuration adjustments to ensure the database operates within the ASM environment.

Uploaded by

emirvallejo
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
34 views2 pages

Steps To Convert Your Oracle Database From FS To ASM

The document outlines the steps to convert a file system to Automatic Storage Management (ASM) in an Oracle database. It includes commands for setting control files, creating backups, switching to ASM, and managing log files. The process involves using RMAN for restoration and configuration adjustments to ensure the database operates within the ASM environment.

Uploaded by

emirvallejo
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

File System to ASM

SQL> ALTER SYSTEM SET control_files=’+DATA’ scope=spfile;


System altered.

SQL> ALTER SYSTEM SET db_create_file_dest=’+DATA’ scope=spfile;


System altered.

SQL> ALTER SYSTEM SET db_recovery_file_dest=’+DATA’ scope=spfile;


System altered.

SQL> shut immediate

SQL> startup nomount

rman target /

RMAN> RESTORE CONTROLFILE FROM ‘/u01/axis/control01.ctl’;

SQL> alter database mount;


Database altered.

SQL> select name from v$controlfile;


NAME
———————————————–
+DATA/axis/controlfile/current.280.978517795

RMAN> BACKUP AS COPY DATABASE FORMAT ‘+DATA’;

RMAN> SWITCH DATABASE TO COPY;

SQL> select name from v$datafile;

SQL> select name from v$tempfile;

NAME
—————————————–
/u01/app/oracle/oradata/axis/temp01.dbf

RMAN> run
{
set newname for tempfile ‘/u01/app/oracle/oradata/axis/temp01.dbf’ to ‘+DATA’;
switch tempfile all;
}

alter database open;

SQL> select name from v$tempfile;

NAME
—————————————-
+DATA/axis/tempfile/temp.288.978519169

SQL> select group#, status from v$log;


GROUP# STATUS
———- —————-
1 INACTIVE
2 CURRENT
3 INACTIVE (Note:-inactive and unused group only we need to drop)

SQL> alter database add logfile group 1 size 50m;


Database altered.

SQL> alter system switch logfile;


System altered.

SQL> alter database add logfile group 3 size 50m;


Database altered.

SQL> alter system switch logfile;


System altered.

SQL> alter database add logfile group 2 size 50m;


Database altered.

SQL> alter system switch logfile;


System altered.

SQL>alter database drop logfile group (previous)

SQL> select member from V$logfile;


MEMBER
————————————————————————

alter system set log_archive_dest_1='location=+FRA';

You might also like