Asmcmd

▣ 접속 방법

[oracle@edrsr4p1 ~]$ ORACLE_SID=+ASM;asmcmd

   

▣ EM에서 Migration 후 아래와 같이 이동된 것 확인

SQL> show parameter unique

   

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_unique_name string orcl

SQL>

SQL> select name from v$datafile;

   

NAME

-----------------------------------------------------------------------------------------------------------

+DISK1/orcl/datafile/system.258.646254143

+DISK1/orcl/datafile/undotbs1.261.646254145

+DISK1/orcl/datafile/sysaux.259.646254143

+DISK1/orcl/datafile/users.262.646254159

+DISK1/orcl/datafile/example.260.646254145

   

▣ ASMCMD

[oracle@edrsr4p1 ~]$ ORACLE_SID=+ASM;asmcmd

ASMCMD> ls

DISK1/

ASMCMD> pwd

+

ASMCMD> cd DISK1

ASMCMD> ls

ORCL/

ASMCMD> cd ORCL

ASMCMD> ls

BACKUPSET/

CONTROLFILE/

DATAFILE/

ONLINELOG/

TEMPFILE/

ASMCMD> cd datafile

ASMCMD> ls

EXAMPLE.260.646254145

SYSAUX.259.646254143

SYSTEM.258.646254143

UNDOTBS1.261.646254145

USERS.262.646254159

   

ASMCMD> help

asmcmd [-p] [command]

   

The environment variables ORACLE_HOME and ORACLE_SID determine the

instance to which the program connects, and ASMCMD establishes a

bequeath connection to it, in the same manner as a SQLPLUS / AS

SYSDBA. The user must be a member of the SYSDBA group.

   

Specifying the -p option allows the current directory to be displayed

in the command prompt, like so:

   

ASMCMD [+DATAFILE/ORCL/CONTROLFILE] >

   

[command] specifies one of the following commands, along with its

parameters.

   

Type "help [command]" to get help on a specific ASMCMD command.

   

commands:

--------

cd

du

find

help

ls

lsct

lsdg

mkalias

mkdir

pwd

rm

rmalias

   

ASMCMD> help du

du [-H] [dir]

   

Display total space used for files located recursively under [dir],

similar to "du -s" under UNIX; default is the current directory. Two

values are returned, both in units of megabytes. The first value does

not take into account mirroring of the diskgroup while the second does.

For instance, if a file occupies 100 MB of space, then it actually

takes up 200 MB of space on a normal redundancy diskgroup and 300 MB

of space on a high redundancy diskgroup.

   

[dir] can also contain wildcards.

   

The -H flag suppresses the column headers from the output.

   

ASMCMD> du -sh

Unknown option: s

Unknown option: h

usage: du [-H] [dir]

ASMCMD> du

Used_MB Mirror_used_MB

883 883

   

SQL> show parameter control

   

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

control_file_record_keep_time integer 7

control_files string +DISK1/orcl/controlfile/backup

                  .256.646254117, +DISK1/orcl/co

                   ntrolfile/backup.257.646254119

   

ASMCMD> cd controlfile

ASMCMD> ls

Backup.263.646254163

backup.256.646254117

backup.257.646254119