:: 작업장

 SQL> @log

GROUP# MEMBER       MB SEQ# STATUS       ARC

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

     1 /u01/app/oracle/oradata/PROD/redo01a.log       100   17 INACTIVE       NO

     2 /u01/app/oracle/oradata/PROD/redo02a.log       100   18 INACTIVE       NO

     3 /u01/app/oracle/oradata/PROD/redo03a.log       100   20 CURRENT       NO

     4 /u01/app/oracle/oradata/PROD/redo04_a.log 5   19 INACTIVE       NO

SQL> alter database drop logfile member

  2  '/u01/app/oracle/oradata/PROD/redo04_a.log';

alter database drop logfile member

*

ERROR at line 1:

ORA-00361: cannot remove last log member /u01/app/oracle/oradata/PROD/redo04_a.log for group 4

 SQL> alter database drop logfile group 4;

SQL> @log 

GROUP# MEMBER       MB SEQ# STATUS       ARC

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

     1 /u01/app/oracle/oradata/PROD/redo01a.log       100   17 INACTIVE       NO

     2 /u01/app/oracle/oradata/PROD/redo02a.log       100   18 INACTIVE       NO

     3 /u01/app/oracle/oradata/PROD/redo03a.log       100   20 CURRENT       NO

[oracle@edydr1p0-PROD ~]$ sqlplus /nolog @create_db

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jun 15 11:14:50 2015

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

Connected to an idle instance.

File created.

ORA-00845: MEMORY_TARGET not supported on this system

CREATE DATABASE PROD

*

ERROR at line 1:

ORA-01034: ORACLE not available

Process ID: 0

Session ID: 0 Serial number: 0

DOC>######################################################################

DOC>######################################################################

DOC> The following statement will cause an "ORA-01722: invalid number"

DOC> error and terminate the SQLPLUS session if the user is not SYS.

DOC> Disconnect and reconnect with AS SYSDBA.

DOC>######################################################################

DOC>######################################################################

DOC>#

SELECT TO_NUMBER('MUST_BE_AS_SYSDBA') FROM DUAL

*

ERROR at line 1:

ORA-01034: ORACLE not available

Process ID: 0

Session ID: 0 Serial number: 0

Disconnected

* 마운트된  /dev/shm 용량 확인

[root@edydr1p0 ~]# df -h

Filesystem            Size  Used Avail Use% Mounted on

/dev/sda3              92G   48G   40G  55% /

/dev/sda1              99M   26M   69M  27% /boot

tmpfs                 500M  156M  345M  32% /dev/shm

.host:/               465G   78G  387G  17% /mnt/hgfs

* 용량증설을 위해 /dev/shm umount

[root@edydr1p0 ~]# umount /dev/shm

umount: /dev/shm: device is busy

umount: /dev/shm: device is busy

** device busy 상태로, umount가 되지않는다.

  -l 옵션으로 umount, umount 확인. 

[root@edydr1p0 ~]# umount -l tmpfs

[root@edydr1p0 ~]# df -h

Filesystem            Size  Used Avail Use% Mounted on

/dev/sda3              92G   48G   40G  55% /

/dev/sda1              99M   26M   69M  27% /boot

.host:/               465G   78G  387G  17% /mnt/hgfs

* 용량 1기가로 증설 후 mount.

[root@edydr1p0 ~]# mount -t tmpfs shmfs -o size=1g /dev/shm

[root@edydr1p0 ~]# df -h

Filesystem            Size  Used Avail Use% Mounted on

/dev/sda3              92G   48G   40G  55% /

/dev/sda1              99M   26M   69M  27% /boot

.host:/               465G   78G  387G  17% /mnt/hgfs

shmfs                 1.0G     0  1.0G   0% /dev/shm

*PROD DB 접속확인.

SQL> startup force

ORACLE instance started.

Total System Global Area  417546240 bytes

Fixed Size     2213936 bytes

Variable Size   314574800 bytes

Database Buffers   96468992 bytes

Redo Buffers     4288512 bytes

Database mounted.

Database opened.

SQL> select instance_name from v$instance;

INSTANCE_NAME

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

PROD