About DATABASE

버추얼박스 사용

vboxmanage createmedium --filename IMSI1.vdi --size 1024 --format VDI --variant Fixed
vboxmanage createmedium --filename IMSI2.vdi --size 1024 --format VDI --variant Fixed
vboxmanage createmedium --filename IMSI3.vdi --size 1024 --format VDI --variant Fixed

공유 및  서버에 할당
vboxmanage modifymedium IMSI1.vdi --type shareable
vboxmanage modifymedium IMSI2.vdi --type shareable
vboxmanage modifymedium IMSI3.vdi --type shareable

[root@rac2 ~]# fdisk -l

Disk /dev/sdj: 1073 MB, 1073741824 bytes, 2097152 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk /dev/sdi: 1073 MB, 1073741824 bytes, 2097152 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk /dev/sdh: 1073 MB, 1073741824 bytes, 2097152 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes

fdisk /dev/sdh

[root@rac2 ~]# fdisk /dev/sdh
Welcome to fdisk (util-linux 2.23.2).

Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.

Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0x853b6083.

Command (m for help): n
Partition type:
   p   primary (0 primary, 0 extended, 4 free)
   e   extended
Select (default p): p
Partition number (1-4, default 1): 
First sector (2048-2097151, default 2048): 
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-2097151, default 2097151): 
Using default value 2097151
Partition 1 of type Linux and of size 1023 MiB is set

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.
.

.

.

fdisk /dev/sdi
fdisk /dev/sdj

ASM 디스크 생성

[root@rac2 ~]# oracleasm createdisk  IMSI1 /dev/sdh1

Writing disk header: done
Instantiating disk: done
[root@rac2 ~]# oracleasm createdisk  IMSI2 /dev/sdi1
Writing disk header: done
Instantiating disk: done
[root@rac2 ~]# oracleasm createdisk  IMSI3 /dev/sdj1
Writing disk header: done
Instantiating disk: done

-- RAC 모든 노드에서 실행1,2
[root@rac1 ~]# oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
Instantiating disk "IMSI3"
Instantiating disk "IMSI2"
Instantiating disk "IMSI1"
[root@rac2 ~]# oracleasm listdisks
CRS1
CRS2
CRS3
DATA
DATA2
FRA
IMSI1
IMSI2
IMSI3

[root@rac2 ~]# kfod ds=true disks=all group=diskgroup
--------------------------------------------------------------------------------
 Disk          Size Path                                    Disk Group    User     Group   
================================================================================
   1:       1023 MB /dev/oracleasm/disks/CRS1                CRS          oracle   asmadmin
   2:       1023 MB /dev/oracleasm/disks/CRS2                CRS          oracle   asmadmin
   3:       1023 MB /dev/oracleasm/disks/CRS3                CRS          oracle   asmadmin
   4:      30719 MB /dev/oracleasm/disks/DATA                DATA         oracle   asmadmin
   5:      50999 MB /dev/oracleasm/disks/DATA2               DATA         oracle   asmadmin
   6:      20479 MB /dev/oracleasm/disks/FRA                 FRA          oracle   asmadmin
   7:       1023 MB /dev/oracleasm/disks/IMSI1               #            oracle   asmadmin
   8:       1023 MB /dev/oracleasm/disks/IMSI2               #            oracle   asmadmin
   9:       1023 MB /dev/oracleasm/disks/IMSI3               #            oracle   asmadmin
KFOD returned no data
 
디스크그룹 생성

/dev/oracleasm/disks/IMSI1 , /dev/oracleasm/disks/IMSI2 2개 추가
SQL> create diskgroup IMSI external redundancy disk '/dev/oracleasm/disks/IMSI1','/dev/oracleasm/disks/IMSI2';
Diskgroup created.

SQL> set linesize 200
SQL> set pages 100   
SQL> col disk_group_name for a15
SQL> col disk_path for a40
SQL> col disk_name for a20
SQL> col disk_fail_group for a20
SQL> 
SQL> SELECT
  2          NVL(a.name, '[CANDIDATE]') disk_group_name ,
  3          b.path                     disk_path       ,
  4          b.name                     disk_name       ,
  5          b.failgroup                disk_fail_group ,
  6          b.os_mb
  7  FROM
  8          v$asm_diskgroup a,
  9          v$asm_disk      b
 10  WHERE
 11          a.group_number(+) = b.group_number
 12  ORDER BY
 13          a.name,
 14          b.name,
 15          b.path;

DISK_GROUP_NAME DISK_PATH                                DISK_NAME            DISK_FAIL_GROUP           OS_MB
--------------- ---------------------------------------- -------------------- -------------------- ----------
CRS             /dev/oracleasm/disks/CRS1                CRS_0000             CRS_0000                   1023
CRS             /dev/oracleasm/disks/CRS3                CRS_0001             CRS_0001                   1023
CRS             /dev/oracleasm/disks/CRS2                CRS_0002             CRS_0002                   1023
DATA            /dev/oracleasm/disks/DATA2               DATA2                DATA2                     50999
DATA            /dev/oracleasm/disks/DATA                DATA_0000            DATA_0000                 30719
FRA             /dev/oracleasm/disks/FRA                 FRA_0000             FRA_0000                  20479
IMSI            /dev/oracleasm/disks/IMSI1               IMSI_0000            IMSI_0000                  1023
IMSI            /dev/oracleasm/disks/IMSI2               IMSI_0001            IMSI_0001                  1023
[CANDIDATE]     /dev/oracleasm/disks/IMSI3                                                               1023

9 rows selected.

디스크그룹에 추가

SQL> alter diskgroup IMSI add disk '/dev/oracleasm/disks/IMSI3' rebalance power 1024;
SQL> set linesize 200
SQL> set pages 100   
SQL> col disk_group_name for a15
SQL> col disk_path for a40
SQL> col disk_name for a20
SQL> col disk_fail_group for a20
SQL> 
SQL> SELECT
  2          NVL(a.name, '[CANDIDATE]') disk_group_name ,
  3          b.path                     disk_path       ,
  4          b.name                     disk_name       ,
  5          b.failgroup                disk_fail_group ,
  6          b.os_mb
  7  FROM
  8          v$asm_diskgroup a,
  9          v$asm_disk      b
 10  WHERE
 11          a.group_number(+) = b.group_number
 12  ORDER BY
 13          a.name,
 14          b.name,
 15          b.path;

DISK_GROUP_NAME DISK_PATH                    DISK_NAME    DISK_FAIL_GROUP        OS_MB
--------------- ---------------------------- ------------ ----------------- ----------
CRS             /dev/oracleasm/disks/CRS1    CRS_0000     CRS_0000                1023
CRS             /dev/oracleasm/disks/CRS3    CRS_0001     CRS_0001                1023
CRS             /dev/oracleasm/disks/CRS2    CRS_0002     CRS_0002                1023
DATA            /dev/oracleasm/disks/DATA2   DATA2        DATA2                  50999
DATA            /dev/oracleasm/disks/DATA    DATA_0000    DATA_0000              30719
FRA             /dev/oracleasm/disks/FRA     FRA_0000     FRA_0000               20479
IMSI            /dev/oracleasm/disks/IMSI1   IMSI_0000    IMSI_0000               1023
IMSI            /dev/oracleasm/disks/IMSI2   IMSI_0001    IMSI_0001               1023
IMSI            /dev/oracleasm/disks/IMSI3   IMSI_0002    IMSI_0002               1023

9 rows selected.

[root@rac2 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.chad
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.net1.network
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.ons
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       rac1                     STABLE
      2        ONLINE  ONLINE       rac2                     STABLE
      3        ONLINE  OFFLINE                               STABLE
ora.CRS.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac1                     STABLE
      2        ONLINE  ONLINE       rac2                     STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.DATA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac1                     STABLE
      2        ONLINE  ONLINE       rac2                     STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.FRA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac1                     STABLE
      2        ONLINE  ONLINE       rac2                     STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.IMSI.dg(ora.asmgroup)
      1        OFFLINE OFFLINE                               STABLE
      2        OFFLINE OFFLINE                               STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac1                     STABLE
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       rac2                     STABLE
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       rac2                     STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       rac1                     Started,STABLE
      2        ONLINE  ONLINE       rac2                     Started,STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       rac1                     STABLE
      2        ONLINE  ONLINE       rac2                     STABLE
      3        OFFLINE OFFLINE                               STABLE
.............................................
--------------------------------------------------------------------------------
[root@rac2 ~]# crsctl stat res -t

--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       rac1                     STABLE
      2        ONLINE  ONLINE       rac2                     STABLE
      3        ONLINE  OFFLINE                               STABLE
ora.CRS.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac1                     STABLE
      2        ONLINE  ONLINE       rac2                     STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.DATA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac1                     STABLE
      2        ONLINE  ONLINE       rac2                     STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.FRA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac1                     STABLE
      2        ONLINE  ONLINE       rac2                     STABLE
      3        OFFLINE OFFLINE                               STABLE
.............................................
--------------------------------------------------------------------------------
[root@rac1 ~]# srvctl start diskgroup -g IMSI -n rac1

완료

[root@rac2 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.chad
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.net1.network
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.ons
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       rac1                     STABLE
      2        ONLINE  ONLINE       rac2                     STABLE
      3        ONLINE  OFFLINE                               STABLE
ora.CRS.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac1                     STABLE
      2        ONLINE  ONLINE       rac2                     STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.DATA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac1                     STABLE
      2        ONLINE  ONLINE       rac2                     STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.FRA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac1                     STABLE
      2        ONLINE  ONLINE       rac2                     STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.IMSI.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac1                     STABLE
      2        ONLINE  ONLINE       rac2                     STABLE

1. 사용자 삭제
select 'drop user '||username||' cascade;'
from dba_users
where default_tablespace in ('TBS_NAME');

ex) drop user test cascade;

2. 대상 테이블스페이스 삭제 
select 'drop tablespace '||tablespace_name||' including contents and datafiles;'
from (select tablespace_name from dba_data_files 
where file_name like '%FILE_NAME%');

3. 삭제 대상 디스크 그룹 UNMOUNT;

rac 의 경우 양 서버에서 모두 dismount

리스타트의 경우 한 번만 dismount
$sqlplus / as sysasm
SQL> alter diskgroup ARTEST dismount;

4. 대상 디스크 그룹 삭제
$sqlplus / as sysasm
SQL> drop diskgroup  ARTEST force including contents;

SQL> drop diskgroup  data3 force including contents; 
drop diskgroup  data3 force including contents
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15073: diskgroup DATA3 is mounted by another ASM instance

-- RAC 이면 모든 노드에서 디스 마운트 해줘야 된다.

5. CRS 리소스 제거( crsctl stat res -t 에서 삭제 안되면 아래 명령어 실행)
$ srvctl remove diskgroup -g ARTEST -f

상태 확인

[root@arac1 dev]# crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARTEST.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.ASMNET1LSNR_ASM.lsnr
               ONLINE  ONLINE       arac1                    STABLE
ora.CRS.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.DATA.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.FRA.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       arac1                    STABLE
ora.MGMT.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.chad
               ONLINE  ONLINE       arac1                    STABLE
ora.net1.network
               ONLINE  ONLINE       arac1                    STABLE
ora.ons
               ONLINE  ONLINE       arac1                    STABLE
ora.proxy_advm
               OFFLINE OFFLINE      arac1                    STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
중 략
--------------------------------------------------------------------------------

디스크 그룹 파괴
[root@arac1 dev]# dd if=/dev/zero of=/dev/ARTEST/ARTESTLV count=1000
1000+0 records in
1000+0 records out
512000 bytes (512 kB) copied, 0.00114053 s, 449 MB/s

확인 - 오프라인 상태로 변경 됨
[+ASM1:/home/grid]> asmcmd
ASMCMD> ls
ARTEST/
CRS/
DATA/
FRA/
MGMT/
ASMCMD> cd artest
ASMCMD> ls

[root@arac1 ARTEST]# crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARTEST.dg
               OFFLINE OFFLINE      arac1                    STABLE
ora.ASMNET1LSNR_ASM.lsnr
               ONLINE  ONLINE       arac1                    STABLE
ora.CRS.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.DATA.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.FRA.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       arac1                    STABLE
ora.MGMT.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.chad
               ONLINE  ONLINE       arac1                    STABLE
ora.net1.network
               ONLINE  ONLINE       arac1                    STABLE
ora.ons
               ONLINE  ONLINE       arac1                    STABLE
ora.proxy_advm
               OFFLINE OFFLINE      arac1                    STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       arac1                    STABLE
ora.MGMTLSNR
      1        ONLINE  ONLINE       arac1                    169.254.51.97 192.16
                                                             8.0.111,STABLE
ora.arac1.vip
      1        ONLINE  ONLINE       arac1                    STABLE
ora.arac2.vip
      1        ONLINE  INTERMEDIATE arac1                    FAILED OVER,STABLE
ora.aracdb.db
      1        ONLINE  ONLINE       arac1                    Open,HOME=/u01/app/o
                                                             racle/product/12c/db
                                                             _1,STABLE
      2        OFFLINE OFFLINE                               STABLE
  

로 그
  
2024-02-22T11:16:08.730714+09:00
GMON dismounting group 1 at 27 for pid 44, osid 21554
2024-02-22T11:16:08.905072+09:00
System State dumped to trace file /u01/app/oracle/diag/asm/+asm/+ASM1/incident/incdir_214849/+ASM1_ora_21498_i214849.trc
2024-02-22T11:16:08.950506+09:00
ami_comp:dbgrip.c@16254:SQL> alter diskgroup ARTEST check
2024-02-22T11:16:09.156303+09:00
NOTE: cache deleting context for group ARTEST 1/0x47c6226f
2024-02-22T11:16:09.796926+09:00
NOTE: Disk ARTEST_0000 in mode 0x7f marked for de-assignment
2024-02-22T11:16:09.801824+09:00
SUCCESS: diskgroup ARTEST was dismounted
2024-02-22T11:16:09.802800+09:00
SUCCESS: alter diskgroup ARTEST dismount force /* ASM SERVER:1204167279 */
2024-02-22T11:16:09.805146+09:00
ami_comp:dbgrip.c@16254:ORA-15032: not all alterations performed
ami_comp:dbgrip.c@16254:ORA-15001: diskgroup "ARTEST" does not exist or is not mounted
ami_comp:dbgrip.c@16254:ORA-15001: diskgroup "1" does not exist or is not mounted
ami_comp:dbgrip.c@16254:
2024-02-22T11:16:09.805723+09:00
ami_comp:dbgrip.c@16254:ERROR: alter diskgroup ARTEST check
ami_comp:dbgrip.c@16254:Some DDE async actions failed or were cancelled
2024-02-22T11:16:09.813709+09:00
SUCCESS: ASM-initiated MANDATORY DISMOUNT of group ARTEST
2024-02-22T11:16:09.918350+09:00
NOTE: diskgroup resource ora.ARTEST.dg is offline



select group_number, name, state from v$asm_diskgroup;
GROUP_NUMBER NAME                     STATE
------------ ------------------------ ---------------------------------
           2 CRS                      MOUNTED
           3 DATA                     MOUNTED
           4 FRA                      MOUNTED
           5 MGMT                     MOUNTED


삭제 실패
SQL> drop diskgroup ARTEST force including contents
  2  ;
drop diskgroup ARTEST force including contents
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "ARTEST"

그냥 crs에서 삭제 한다. 오라클 문서 1478128.1
crsctl delete resource ora.ARTEST.dg

12.2.0.1 기준 아래 방법으로 해야 된다
srvctl remove diskgroup -g ARTEST -f

삭제 완료
[+ASM1:/home/grid]> srvctl remove diskgroup -g ARTEST -f
[+ASM1:/home/grid]> crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
               ONLINE  ONLINE       arac1                    STABLE
ora.CRS.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.DATA.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.FRA.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       arac1                    STABLE
ora.MGMT.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.chad
               ONLINE  ONLINE       arac1                    STABLE
ora.net1.network
               ONLINE  ONLINE       arac1                    STABLE
ora.ons
               ONLINE  ONLINE       arac1                    STABLE
ora.proxy_advm
               OFFLINE OFFLINE      arac1                    STABLE

참조 : ORA-015039, ORA-15063: ASM Discovered An Insufficient Number Of Disks For Diskgroup (문서 ID 1478128.1)

 1.Red Hat Enterprise Linux 9

주로 사용자의 실수로 datafile 삭제

-- 전제 조건 아카이브 모드 상태.
SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /arch
Oldest online log sequence     83
Next log sequence to archive   85
Current log sequence           85
SQL> 

-- 상태 확인 
SQL> select file#,name,status,CREATION_TIME from v$datafile;

     FILE# NAME                                               STATUS  CREATION_TIM
---------- -------------------------------------------------- ------- ------------
         1 /oradata/ORA19C/system01.dbf                       SYSTEM  17-APR-19
         3 /oradata/ORA19C/sysaux01.dbf                       ONLINE  17-APR-19
         4 /oradata/ORA19C/undotbs01.dbf                      ONLINE  17-APR-19
         5 /oradata/ORA19C/users02.dbf                        ONLINE  14-FEB-24
         7 /oradata/ORA19C/users01.dbf                        ONLINE  17-APR-19
         8 /oradata/ORA19C/soe01.dbf                          ONLINE  22-JAN-24

-- 장애 상황 발생 
[oracle@ora19c ORA19C]$ rm users02.dbf 
[oracle@ora19c ORA19C]$ exit

-- 로그 스위칭 도중 db down 발생
SQL> alter system switch logfile;
alter system switch logfile
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 5028
Session ID: 154 Serial number: 38319

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.21.0.0.0
-- DB 마운트 모드 기동
[ora19c:/home/oracle]> ss

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 14 14:52:56 2024
Version 19.21.0.0.0

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

Connected to an idle instance.

SQL> startup mount
ORACLE instance started.

Total System Global Area 3137336112 bytes
Fixed Size                  8930096 bytes
Variable Size             671088640 bytes
Database Buffers         2449473536 bytes
Redo Buffers                7843840 bytes
Database mounted.
SQL> select * from v$recover_file;

     FILE# ONLINE  ONLINE_ ERROR                   CHANGE# TIME             CON_ID
---------- ------- ------- -------------------- ---------- ------------ ----------
         5 ONLINE  ONLINE  FILE NOT FOUND                0                       0
 
SQL>  select file#,name,status,CREATION_TIME from v$datafile;
     FILE# NAME                                          STATUS  CREATION_TIM
---------- --------------------------------------------- ------- ------------
         1 /oradata/ORA19C/system01.dbf                  SYSTEM  17-APR-19
         3 /oradata/ORA19C/sysaux01.dbf                  ONLINE  17-APR-19
         4 /oradata/ORA19C/undotbs01.dbf                 ONLINE  17-APR-19
         5 /oradata/ORA19C/users02.dbf                   ONLINE  14-FEB-24
         7 /oradata/ORA19C/users01.dbf                   ONLINE  17-APR-19
         8 /oradata/ORA19C/soe01.dbf                     ONLINE  22-JAN-24

6 rows selected.
-- 삭제 파일  껍데기 만들어 줌
SQL> alter database create datafile '/oradata/ORA19C/users02.dbf';

Database altered.
-- 복구 
SQL> recover datafile 5;
Media recovery complete.
SQL> alter database datafile 5 online;

Database altered.
-- db open 완료
SQL> alter database open;

Database altered. 

-- 복구 완료 확인

SQL> select * from v$recover_file;

no rows selected

SQL> col file_name for a45
SQL> set lines 200
SQL>  select tablespace_name,file_name,bytes/1024/1024 from dba_data_files;

TABLESPACE_NAME                FILE_NAME                                     BYTES/1024/1024
------------------------------ --------------------------------------------- ---------------
USERS                          /oradata/ORA19C/users01.dbf                             93.75
UNDOTBS1                       /oradata/ORA19C/undotbs01.dbf                             605
SYSTEM                         /oradata/ORA19C/system01.dbf                             1150
SYSAUX                         /oradata/ORA19C/sysaux01.dbf                              910
USERS                          /oradata/ORA19C/users02.dbf                           36.5625
SOE                            /oradata/ORA19C/soe01.dbf                                2419

6 rows selected.

SQL>  select file#,name,status,CREATION_TIME from v$datafile;

     FILE# NAME                                          STATUS  CREATION_TIM
---------- --------------------------------------------- ------- ------------
         1 /oradata/ORA19C/system01.dbf                  SYSTEM  17-APR-19
         3 /oradata/ORA19C/sysaux01.dbf                  ONLINE  17-APR-19
         4 /oradata/ORA19C/undotbs01.dbf                 ONLINE  17-APR-19
         5 /oradata/ORA19C/users02.dbf                   ONLINE  14-FEB-24
         7 /oradata/ORA19C/users01.dbf                   ONLINE  17-APR-19
         8 /oradata/ORA19C/soe01.dbf                     ONLINE  22-JAN-24

6 rows selected.

SQL> select instance_name,status from v$instance;

INSTANCE_NAME    STATUS
---------------- ------------
ora19c           OPEN

※ DB가  다운 되지 않았다면 삭제한 datafile offline 후 alter database create datafile  생성 부터 

진행 하면 된다.

SYMPTOMS

Pump process abends with below error:
2020-08-05 23:19:16 ERROR OGG-00041 Data source not specified.
2020-08-05 23:19:16 ERROR OGG-01668 PROCESS ABENDING.

CHANGES

CAUSE

Goldengate is not able to correctly interpret the parameter file.
It could be due to an unsupported parameter used or a spelling error in one of the keywords specifies in parameter file

Goldengate가 매개변수 파일을 올바르게 해석할 수 없습니다. 지원되지 않는 매개변수가 사용되었거나 매개변수 파일에 지정된 키워드 중 하나의 철자 오류가 원인일 수 있습니다
 

SOLUTION

Scan and ensure that all the parameters set in Pump parameter file are valid for extract pump and that there are no typing errors with the keywords used.

펌프 매개변수 파일에 설정된 모든 매개변수가 추출 펌프에 대해 유효한지, 사용된 키워드에 입력 오류가 없는지 스캔하고 확인하십시오.

참조 : ERROR OGG-00041 Data Source Not Specified (문서 ID 2698427.1)

Process and Runtime Limits

Process and Runtime Limits

논리적 데이터베이스 제한

참조 

https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/logical-database-limits.html#GUID-685230CF-63F5-4C5A-B8B0-037C566BDA76

물리적 데이터베이스 제한

참조

https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/physical-database-limits.html#GUID-939CB455-783E-458A-A2E8-81172B990FE9

A.1 데이터 유형 제한

참조 : https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/datatype-limits.html#GUID-963C79C9-9303-49FE-8F2D-C8AAF04D3095