'운바의 IT이야기'에 해당되는 글 54건

SQL> startup nomount;

ORACLE instance started.

Total System Global Area 3674501120 bytes

Fixed Size 2233760 bytes

Variable Size 1157630560 bytes

Database Buffers 2499805184 bytes

Redo Buffers 14831616 bytes

SQL>

SQL>

SQL>

SQL> show parameter control_file

NAME TYPE

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

VALUE

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

control_file_record_keep_time integer

7

control_files string

+ORADATA/video/controlfile/cur

rent.260.786470645

SQL>

ASMCMD> ls

Current.260.789319007

ASMCMD>

ASMCMD> pwd

+ORADATA/video/controlfile

ASMCMD>

SQL> alter system set control_files='+ORADATA/video/controlfile/current.260.786470645', '+ORADATA/video/controlfile/current.mirror1', '+ORADATA/video/controlfile/current.mirror2' scope=spfile;

System altered.

SQL>

SQL> startup nomount

ORACLE instance started.

Total System Global Area 3674501120 bytes

Fixed Size 2233760 bytes

Variable Size 1157630560 bytes

Database Buffers 2499805184 bytes

Redo Buffers 14831616 bytes

SQL>

SQL>

SQL> show parameter control_files

NAME TYPE

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

VALUE

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

control_files string

+ORADATA/video/controlfile/cur

rent.260.786470645, +ORADATA/v

ideo/controlfile/current.mirro

r1, +ORADATA/video/controlfile

/current.mirror2

SQL>

SQL> alter database mount;

Database altered.

SQL>

SQL>

SQL> select name, is_recovery_dest_file from v$controlfile;

NAME

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

IS_RECOVE

---------

+ORADATA/video/controlfile/current.260.786470645

NO

+ORADATA/video/controlfile/current.mirror1

NO

+ORADATA/video/controlfile/current.mirror2

NO

SQL>

SQL>

SQL> desc v$controlfile;

Name Null? Type

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

STATUS VARCHAR2(7)

NAME VARCHAR2(513)

IS_RECOVERY_DEST_FILE VARCHAR2(3)

BLOCK_SIZE NUMBER

FILE_SIZE_BLKS NUMBER

SQL>

SQL>

SQL> alter database open;

Database altered.

SQL>

SQL>

SQL> ALTER DATABASE ADD LOGFILE THREAD 1

2 GROUP 10 '+ORADATA',

3 GROUP 20 '+ORADATA',

4 GROUP 30 '+ORADATA';

Database altered.

SQL>

SQL> ALTER DATABASE ADD LOGFILE THREAD 2

2 GROUP 40 '+ORADATA',

3 GROUP 50 '+ORADATA',

4 GROUP 60 '+ORADATA';

Database altered.

SQL>

SQL> alter system switch logfile;

SQL> alter system checkpoint;

SQL> alter database drop logfile group 1;

Database altered.

SQL>

SQL> alter database drop logfile group 2;

Database altered.

SQL> alter database drop logfile group 3;

Database altered.

SQL> alter database drop logfile group 4;

Database altered.

==========================================

SQL> alter database drop logfile group 5;

alter database drop logfile group 5

*

ERROR at line 1:

ORA-01623: log 5 is current log for instance UNNAMED_INSTANCE_3 (thread 3) - cannot drop

ORA-00312: online log 5 thread 3: '+ORADATA/video/onlinelog/group_5.265.786470753'

SQL> alter database drop logfile group 6;

alter database drop logfile group 6

*

ERROR at line 1:

ORA-01567: dropping log 6 would leave less than 2 log files for instance UNNAMED_INSTANCE_3 (thread 3)

ORA-00312: online log 6 thread 3: '+ORADATA/video/onlinelog/group_6.266.786470753'

SQL> ALTER DATABASE DISABLE THREAD 3;

Database altered.

SQL>

SQL>

SQL> alter database drop logfile group 5;

Database altered.

SQL> alter database drop logfile group 6;

Database altered.

SQL>

SQL> ALTER DATABASE ADD LOGFILE THREAD 1

2 GROUP 1 ('+ORADATA','+ORADATA') SIZE 1024m,

3 GROUP 2 ('+ORADATA','+ORADATA') SIZE 1024m,

4 GROUP 3 ('+ORADATA','+ORADATA') SIZE 1024m;

Database altered.

SQL> ALTER DATABASE ADD LOGFILE THREAD 2

2 GROUP 4 ('+ORADATA','+ORADATA') SIZE 1024m,

3 GROUP 5 ('+ORADATA','+ORADATA') SIZE 1024m,

4 GROUP 6 ('+ORADATA','+ORADATA') SIZE 1024m;

Database altered.

SQL>

SQL> alter system switch logfile;

SQL> alter system checkpoint;

SQL>

SQL> alter database drop logfile group 20;

Database altered.

SQL> alter database drop logfile group 30;

Database altered.

SQL> alter database drop logfile group 40;

Database altered.

SQL> alter database drop logfile group 50;

Database altered.

SQL> alter database drop logfile group 60;

Database altered.

SQL> Show parameter name

SQL> Select * from v$version

SQL> Select * from dba_registry;

$ cat /etc/oratab

ORCL:/u01/app/oracle/product/11.2.0.1/server:N

./runInstaller -silent -ignoreSysPrereqs -ignorePrereq -debug -force \ ORACLE_BASE=/u01/app/oracle \ ORACLE_HOME=/u01/app/oracle/product/11.2.0.4 \ ORACLE_HOME_NAME=OraDbHome2\ UNIX_GROUP_NAME=oinstall\ oracle.install.option=INSTALL_DB_SWONLY \ oracle.install.db.InstallEdition=EE \ oracle.install.db.DBA_GROUP=dba \ oracle.install.db.OPER_GROUP=dba \ DECLINE_SECURITY_UPDATES=true

★ Enter로 띄우지 말고 한 줄로 명령어를 주어야 합니다.

명령어 에러

$ Stop the listeners.(lsnrctl stop)

SQL> shutdown immediate.

$export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4

$export PATH=$ORACLE_HOME/bin:$PATH

$cd /u01/app/oracle/product/11.2.0.4/bin

./dbua -silent -sid DEVORA

oakcli show asr

Displays the Oracle Auto Service Request configuration

oakcli show cooling

Displays the status of the cooling units

oakcli show controller

Displays information about the disk controllers

oakcli show core_config_key

Displays information a bout the core deploy ment

oakcli show cpupool

Displays information about mappings between cores and virtual machines

oakcli show databases

Displays information about the databases

oakcli show dbhomes

Displays information about the database homes

oakcli show db_config_params

Displays configuration file names and parameters

oakcli show disk

Displays information about shared or local disks

oakcli show diskgroup

Displays information about Oracle ASM disk groups.

oakcli show env_hw

Displays the current server's environment type and hardware version

oakcli show expander

Displays information about the expanders

oakcli show enclosure

Displays information about the storage enclosure

oakcli show memory

Displays information about the memory subsystem

oakcli show network on

Displays information about the network subsystem

oakcli show power on p

Displays the status of the power supply subsystem

oakcli show processor

Displays processor (CPU) information

oakcli show repo on pa

Displays information about virtual machine repositories

oakcli show server on

Displays information about the server subsystem

oakcli show storage

Displays in formation about the storage

oakcli show validation storage

Displays status (enabled or disabled) of validation storage error reporting

oakcli show validation storag

eerrors Displays hard storage errors

oakcli show validation storage

failures Displays soft storage errors

oakcli show version

Displays version information for the software and firmware

oakcli show vlan

Displays version information about virtual local area networks

oakcli show vm

Displays version information about virtual machines

oakcli show vmtemplate

Displays information about virtual machine templates