1.ASMCA 실행
2. 삭제 할 DISKGROUP DATA1 선택 후 마운트 해제
3.DATA1 dismounted 확인
4. 레이블 삭제 및 지우기 선택
5.확인
6. 삭제 완료
7. crs 상태 확인 - 더이상 DATA1 볼륨 그룹은 보이지 않는다.
| ORACLE ASM DISK 삭제(DROP) 정리 (0) | 2023.06.08 |
|---|---|
| oracle restart 기동 절차 (0) | 2023.06.02 |
| 오라클 asm disk 그룹 추가 시 설정 ASM AFD (0) | 2023.05.25 |
| ORACLE SEHA 인스턴스 이동 (0) | 2022.09.15 |
| ORACLE SEHA LISTENER설정 및 상태 체크 (0) | 2022.09.15 |
root유저로 실행
### 경로 설정
export ORACLE_HOME=/u01/app/oracle/19c/grid
export ORACLE_BASE=/tmp
$ORACLE_HOME/bin/asmcmd afd_label RDATA1 /dev/sdf --migrate
$ORACLE_HOME/bin/asmcmd afd_label RDATA2 /dev/sdg --migrate
$ORACLE_HOME/bin/asmcmd afd_label RDATA3 /dev/sdh --migrate
$ORACLE_HOME/bin/asmcmd afd_label RFRA1 /dev/sdi --migrate
$ORACLE_HOME/bin/asmcmd afd_lslbl /dev/sdf
$ORACLE_HOME/bin/asmcmd afd_lslbl /dev/sdg
$ORACLE_HOME/bin/asmcmd afd_lslbl /dev/sdh
$ORACLE_HOME/bin/asmcmd afd_lslbl /dev/sdi
grid 유저로 asmca 실행 후 그룹 추가
[grid@+ASM ~]$
| oracle restart 기동 절차 (0) | 2023.06.02 |
|---|---|
| ORACLE ASM DISKGROUP 삭제 (0) | 2023.05.25 |
| ORACLE SEHA 인스턴스 이동 (0) | 2022.09.15 |
| ORACLE SEHA LISTENER설정 및 상태 체크 (0) | 2022.09.15 |
| RAC DB삭제 (0) | 2022.05.22 |
오라클 그리드 인프라스트럭쳐 설치하고 DBT-05801 에러 발생
DBT-05801 오라클 리스타트 설치시에 asm 볼륨이 안보일 때
나의 원인
원인
chmod 775 /u01 -R
그리드 와 오라클 의 oracle 파일의 퍼미션인 775로 변경 되서 발생
chmod 6751 oracle
반드시 $ORACLE_HOME/bin/oracle 파일과 $GRID_HOME/bin/oracle 파일 모두 6751 퍼미션을 줘야 된다.
| ORA-65096: invalid common user or role name (0) | 2023.06.08 |
|---|---|
| oracle ora-15032 ora-15260 (0) | 2023.06.08 |
| linux 7버전에 oracle 11g 설치시 'agent nmhs' 관련 에러 발생 (0) | 2022.04.11 |
| 오라클 ora-48913 (0) | 2018.12.31 |
| ORA-39125 expdp 중 오류 (0) | 2018.10.16 |
RAC TO SINGLE 복제 목적지 에서 실행
[oracle@aracdb aracdb]$ cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.219.201 ora12c
### Public
192.168.219.111 arac1
192.168.219.113 arac2
### Private
192.168.0.111 arac1-priv
192.168.0.112 arac2-priv
### Virtual
192.168.219.112 arac1-vip
192.168.219.114 arac2-vip
### DNS
192.168.219.115 arac-scan
source 서버에서 pwd파일 목적지 서버로 카피
scp $ORACLE_HOME/dbs/orapwaracdb1 ora12c:$ORACLE_HOME/dbs/orapwaracdb
-- 패스워드 파일이 없을 시에 실행 후 목적지 서버로 옮긴다
orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=oracle force=y format=12
파라미터 설정
*.audit_file_dest='/u01/app/oracle/admin/aracdb/adump'
*.audit_trail='db'
#*.cluster_database=true
*.compatible='12.2.0'
*.control_files='/oradata/aracdb/controlfile/control01.ctl','/oradata/aracdb/controlfile/control02.ctl'
*.db_block_size=8192
*.db_create_file_dest='/oradata/aracdb'
*.db_name='aracdb'
*.db_recovery_file_dest='/oradata/aracdb'
*.db_recovery_file_dest_size=10g
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=aracdbXDB)'
#family:dw_helper.instance_mode='read-only'
*.log_archive_format='%t_%s_%r.dbf'
*.nls_language='KOREAN'
*.nls_territory='KOREA'
*.open_cursors=300
*.pga_aggregate_target=1000m
*.processes=320
*.remote_login_passwordfile='exclusive'
*.sga_target=2998m
*.log_file_name_convert='+DATA','/oradata','+FRA','/oradata'
*.db_file_name_convert='+DATA','/oradata','+FRA','/oradata'
오라클 유저로 디렉토리 생성
/oradata/aracdb
/oradata/aracdb/onlinelog <<== 리두 로그 경로 안만들었더니 에러 발생
/u01/app/oracle/admin/aracdb/adump
/u01/app/oracle/diag/rdbms/aracdb/aracdb/trace
/u01/app/oracle/diag/rdbms/aracdb/aracdb/cdump
-- 목적지 복제용 리스너 구성
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = ora12c)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = aracdb)
(ORACLE_HOME = /u01/app/oracle/product/12C/db_1)
)
)
목적지 NO MOUNT 모드 기동
SQL*Plus: Release 12.2.0.1.0 Production on Tue May 23 17:18:57 2023
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 3154116608 bytes
Fixed Size 8625656 bytes
Variable Size 788529672 bytes
Database Buffers 2348810240 bytes
Redo Buffers 8151040 bytes
SQL>
목적지
## tnsnames.ora
ARACDB1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.219.112)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = aracdb)
)
)
aracdb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ora12c)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = aracdb)
)
)
-- 리스너 기동
[oracle@aracdb admin]$ lsnrctl start
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 25-JAN-2024 16:31:24
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Starting /u01/app/oracle/product/12C/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 12.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/12C/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/ora12c/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora12c)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 25-JAN-2024 16:31:24
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12C/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/ora12c/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora12c)(PORT=1521)))
Services Summary...
Service "aracdb" has 1 instance(s).
Instance "aracdb", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
-- 목적지에서 rman 접속 후 복제 명령어 실행
[oracle@aracdb admin]$ rman target sys/oracle@aracdb1 auxiliary sys/oracle@aracdb
Recovery Manager: Release 12.2.0.1.0 - Production on Thu Jan 25 16:31:34 2024
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
connected to target database: ARACDB (DBID=2943394426)
connected to auxiliary database: ARACDB (not mounted)
RMAN> DUPLICATE DATABASE TO aracdb
2> FROM ACTIVE DATABASE
3> NOFILENAMECHECK;
Starting Duplicate Db at 24/01/25
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=261 device type=DISK
current log archived
contents of Memory Script:
{
sql clone "create spfile from memory";
}
executing Memory Script
sql statement: create spfile from memory
contents of Memory Script:
{
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 3154116608 bytes
Fixed Size 8625656 bytes
Variable Size 788529672 bytes
Database Buffers 2348810240 bytes
Redo Buffers 8151040 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''ARACDB'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''aracdb'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
restore clone from service 'aracdb1' primary controlfile;
alter clone database mount;
}
executing Memory Script
sql statement: alter system set db_name = ''ARACDB'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''aracdb'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 3154116608 bytes
Fixed Size 8625656 bytes
Variable Size 788529672 bytes
Database Buffers 2348810240 bytes
Redo Buffers 8151040 bytes
Starting restore at 24/01/25
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=135 device type=DISK
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service aracdb1
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
output file name=/oradata/aracdb/controlfile/control01.ctl
output file name=/oradata/aracdb/controlfile/control02.ctl
Finished restore at 24/01/25
database mounted
contents of Memory Script:
{
set newname for datafile 1 to
"/oradata/aracdb/datafile/system.265.1136924533";
set newname for datafile 3 to
"/oradata/aracdb/datafile/sysaux.266.1136924577";
set newname for datafile 4 to
"/oradata/aracdb/datafile/undotbs1.267.1136924603";
set newname for datafile 5 to
"/oradata/aracdb/datafile/undotbs2.273.1136924729";
set newname for datafile 7 to
"/oradata/aracdb/datafile/users.268.1136924605";
restore
from nonsparse from service
'aracdb1' clone database
;
sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 24/01/25
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service aracdb1
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to /oradata/aracdb/datafile/system.265.1136924533
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:35
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service aracdb1
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00003 to /oradata/aracdb/datafile/sysaux.266.1136924577
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:25
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service aracdb1
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00004 to /oradata/aracdb/datafile/undotbs1.267.1136924603
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service aracdb1
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00005 to /oradata/aracdb/datafile/undotbs2.273.1136924729
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service aracdb1
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00007 to /oradata/aracdb/datafile/users.268.1136924605
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
Finished restore at 24/01/25
sql statement: alter system archive log current
current log archived
contents of Memory Script:
{
restore clone force from service 'aracdb1'
archivelog from scn 1728198;
switch clone datafile all;
}
executing Memory Script
Starting restore at 24/01/25
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service aracdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=23
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service aracdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=24
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
Finished restore at 24/01/25
datafile 1 switched to datafile copy
input datafile copy RECID=10 STAMP=1159202130 file name=/oradata/aracdb/datafile/system.265.1136924533
datafile 3 switched to datafile copy
input datafile copy RECID=11 STAMP=1159202130 file name=/oradata/aracdb/datafile/sysaux.266.1136924577
datafile 4 switched to datafile copy
input datafile copy RECID=12 STAMP=1159202130 file name=/oradata/aracdb/datafile/undotbs1.267.1136924603
datafile 5 switched to datafile copy
input datafile copy RECID=13 STAMP=1159202130 file name=/oradata/aracdb/datafile/undotbs2.273.1136924729
datafile 7 switched to datafile copy
input datafile copy RECID=14 STAMP=1159202130 file name=/oradata/aracdb/datafile/users.268.1136924605
contents of Memory Script:
{
set until scn 1728333;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 24/01/25
using channel ORA_AUX_DISK_1
starting media recovery
archived log for thread 1 with sequence 23 is already on disk as file /oradata/aracdb/ARACDB/archivelog/2024_01_25/o1_mf_1_23_lv43szth_.arc
archived log for thread 1 with sequence 24 is already on disk as file /oradata/aracdb/ARACDB/archivelog/2024_01_25/o1_mf_1_24_lv43t18x_.arc
archived log file name=/oradata/aracdb/ARACDB/archivelog/2024_01_25/o1_mf_1_23_lv43szth_.arc thread=1 sequence=23
archived log file name=/oradata/aracdb/ARACDB/archivelog/2024_01_25/o1_mf_1_24_lv43t18x_.arc thread=1 sequence=24
media recovery complete, elapsed time: 00:00:01
Finished recover at 24/01/25
Oracle instance started
Total System Global Area 3154116608 bytes
Fixed Size 8625656 bytes
Variable Size 788529672 bytes
Database Buffers 2348810240 bytes
Redo Buffers 8151040 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''ARACDB'' comment=
''Reset to original value by RMAN'' scope=spfile";
sql clone "alter system reset db_unique_name scope=spfile";
}
executing Memory Script
sql statement: alter system set db_name = ''ARACDB'' comment= ''Reset to original value by RMAN'' scope=spfile
sql statement: alter system reset db_unique_name scope=spfile
Oracle instance started
Total System Global Area 3154116608 bytes
Fixed Size 8625656 bytes
Variable Size 788529672 bytes
Database Buffers 2348810240 bytes
Redo Buffers 8151040 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "ARACDB" RESETLOGS ARCHIVELOG
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
MAXINSTANCES 32
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( '/oradata/aracdb/onlinelog/group_1.260.1136924673', '/oradata/aracdb/onlinelog/group_1.270.1136924671' ) SIZE 200 M REUSE,
GROUP 2 ( '/oradata/aracdb/onlinelog/group_2.261.1136924673', '/oradata/aracdb/onlinelog/group_2.271.1136924671' ) SIZE 200 M REUSE
DATAFILE
'/oradata/aracdb/datafile/system.265.1136924533'
CHARACTER SET AL32UTF8
sql statement: ALTER DATABASE ADD LOGFILE
INSTANCE 'i2'
GROUP 3 ( '/oradata/aracdb/onlinelog/group_3.274.1136924835', '/oradata/aracdb/onlinelog/group_3.262.1136924835' ) SIZE 200 M REUSE,
GROUP 4 ( '/oradata/aracdb/onlinelog/group_4.275.1136924837', '/oradata/aracdb/onlinelog/group_4.263.1136924837' ) SIZE 200 M REUSE
contents of Memory Script:
{
set newname for tempfile 1 to
"/oradata/aracdb/tempfile/temp.272.1136924683";
switch clone tempfile all;
catalog clone datafilecopy "/oradata/aracdb/datafile/sysaux.266.1136924577",
"/oradata/aracdb/datafile/undotbs1.267.1136924603",
"/oradata/aracdb/datafile/undotbs2.273.1136924729",
"/oradata/aracdb/datafile/users.268.1136924605";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /oradata/aracdb/tempfile/temp.272.1136924683 in control file
cataloged datafile copy
datafile copy file name=/oradata/aracdb/datafile/sysaux.266.1136924577 RECID=1 STAMP=1159202165
cataloged datafile copy
datafile copy file name=/oradata/aracdb/datafile/undotbs1.267.1136924603 RECID=2 STAMP=1159202165
cataloged datafile copy
datafile copy file name=/oradata/aracdb/datafile/undotbs2.273.1136924729 RECID=3 STAMP=1159202165
cataloged datafile copy
datafile copy file name=/oradata/aracdb/datafile/users.268.1136924605 RECID=4 STAMP=1159202165
datafile 3 switched to datafile copy
input datafile copy RECID=1 STAMP=1159202165 file name=/oradata/aracdb/datafile/sysaux.266.1136924577
datafile 4 switched to datafile copy
input datafile copy RECID=2 STAMP=1159202165 file name=/oradata/aracdb/datafile/undotbs1.267.1136924603
datafile 5 switched to datafile copy
input datafile copy RECID=3 STAMP=1159202165 file name=/oradata/aracdb/datafile/undotbs2.273.1136924729
datafile 7 switched to datafile copy
input datafile copy RECID=4 STAMP=1159202165 file name=/oradata/aracdb/datafile/users.268.1136924605
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Cannot remove created server parameter file
Finished Duplicate Db at 24/01/25
RMAN>
접속 후 상태 확인
SQL*Plus: Release 12.2.0.1.0 Production on Thu Jan 25 16:37:44 2024
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
aracdb OPEN
##################################################################################
채널 여러개 할당
복제 시에 채널 개수 만큼 패러럴 하게 복제
ex) 채널 2개 할당
rman target sys/oracle@aracdb1 auxiliary sys/oracle@aracdb
run {
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate auxiliary channel stby1 type disk;
allocate auxiliary channel stby2 type disk;
duplicate database to aracdb from active database nofilenamecheck;
}
| 백업 되지 않는 datafile 삭제 (0) | 2024.02.14 |
|---|---|
| 오라클 duplicate (복제) 시에 에러 (0) | 2023.05.23 |
| RAC to clonedb(single) 복구 (2) | 2014.08.15 |
| clone DB를 이용한 incomplete recovery (0) | 2012.08.08 |
| 복구에 필요한 정보 보기 (0) | 2011.11.23 |
[oracle@aracdb admin]$ rman target sys/oracle@aracdb1 auxiliary sys/oracle@aracdb
Recovery Manager: Release 12.2.0.1.0 - Production on Tue May 23 17:14:22 2023
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
connected to target database: ARACDB (DBID=2943394426)
connected to auxiliary database: ARACDB (not mounted)
RMAN> DUPLICATE DATABASE TO aracdb
2> FROM ACTIVE DATABASE
3> NOFILENAMECHECK;
Starting Duplicate Db at 23/05/23
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=261 device type=DISK
current log archived
contents of Memory Script:
{
sql clone "alter system set db_name =
''ARACDB'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''ARACDB'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
restore clone from service 'aracdb1' primary controlfile;
alter clone database mount;
}
executing Memory Script
sql statement: alter system set db_name = ''ARACDB'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''ARACDB'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 3154116608 bytes
Fixed Size 8625656 bytes
Variable Size 788529672 bytes
Database Buffers 2348810240 bytes
Redo Buffers 8151040 bytes
Starting restore at 23/05/23
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=136 device type=DISK
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service aracdb1
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
output file name=/oradata/aracdb/controlfile/control01.ctl
output file name=/oradata/aracdb/controlfile/control02.ctl
Finished restore at 23/05/23
database mounted
contents of Memory Script:
{
set newname for datafile 1 to
"/oradata/aracdb/datafile/system.265.1136924533";
set newname for datafile 3 to
"/oradata/aracdb/datafile/sysaux.266.1136924577";
set newname for datafile 4 to
"/oradata/aracdb/datafile/undotbs1.267.1136924603";
set newname for datafile 5 to
"/oradata/aracdb/datafile/undotbs2.273.1136924729";
set newname for datafile 7 to
"/oradata/aracdb/datafile/users.268.1136924605";
restore
from nonsparse from service
'aracdb1' clone database
;
sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 23/05/23
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service aracdb1
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to /oradata/aracdb/datafile/system.265.1136924533
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:35
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service aracdb1
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00003 to /oradata/aracdb/datafile/sysaux.266.1136924577
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:26
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service aracdb1
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00004 to /oradata/aracdb/datafile/undotbs1.267.1136924603
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service aracdb1
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00005 to /oradata/aracdb/datafile/undotbs2.273.1136924729
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service aracdb1
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00007 to /oradata/aracdb/datafile/users.268.1136924605
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 23/05/23
sql statement: alter system archive log current
current log archived
contents of Memory Script:
{
restore clone force from service 'aracdb1'
archivelog from scn 1457925;
switch clone datafile all;
}
executing Memory Script
Starting restore at 23/05/23
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service aracdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=12
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service aracdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=13
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
Finished restore at 23/05/23
datafile 1 switched to datafile copy
input datafile copy RECID=6 STAMP=1137604617 file name=/oradata/aracdb/datafile/system.265.1136924533
datafile 3 switched to datafile copy
input datafile copy RECID=7 STAMP=1137604617 file name=/oradata/aracdb/datafile/sysaux.266.1136924577
datafile 4 switched to datafile copy
input datafile copy RECID=8 STAMP=1137604617 file name=/oradata/aracdb/datafile/undotbs1.267.1136924603
datafile 5 switched to datafile copy
input datafile copy RECID=9 STAMP=1137604617 file name=/oradata/aracdb/datafile/undotbs2.273.1136924729
datafile 7 switched to datafile copy
input datafile copy RECID=10 STAMP=1137604617 file name=/oradata/aracdb/datafile/users.268.1136924605
contents of Memory Script:
{
set until scn 1458042;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 23/05/23
using channel ORA_AUX_DISK_1
starting media recovery
archived log for thread 1 with sequence 12 is already on disk as file /oradata/aracdb/ARACDB/archivelog/2023_05_23/o1_mf_1_12_l6rxmq27_.arc
archived log for thread 1 with sequence 13 is already on disk as file /oradata/aracdb/ARACDB/archivelog/2023_05_23/o1_mf_1_13_l6rxmrgm_.arc
archived log file name=/oradata/aracdb/ARACDB/archivelog/2023_05_23/o1_mf_1_12_l6rxmq27_.arc thread=1 sequence=12
archived log file name=/oradata/aracdb/ARACDB/archivelog/2023_05_23/o1_mf_1_13_l6rxmrgm_.arc thread=1 sequence=13
media recovery complete, elapsed time: 00:00:01
Finished recover at 23/05/23
Oracle instance started
Total System Global Area 3154116608 bytes
Fixed Size 8625656 bytes
Variable Size 788529672 bytes
Database Buffers 2348810240 bytes
Redo Buffers 8151040 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''ARACDB'' comment=
''Reset to original value by RMAN'' scope=spfile";
sql clone "alter system reset db_unique_name scope=spfile";
}
executing Memory Script
sql statement: alter system set db_name = ''ARACDB'' comment= ''Reset to original value by RMAN'' scope=spfile
sql statement: alter system reset db_unique_name scope=spfile
Oracle instance started
Total System Global Area 3154116608 bytes
Fixed Size 8625656 bytes
Variable Size 788529672 bytes
Database Buffers 2348810240 bytes
Redo Buffers 8151040 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "ARACDB" RESETLOGS ARCHIVELOG
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
MAXINSTANCES 32
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( '/oradata/aracdb/onlinelog/group_1.260.1136924673', '/oradata/aracdb/onlinelog/group_1.270.1136924671' ) SIZE 200 M REUSE,
GROUP 2 ( '/oradata/aracdb/onlinelog/group_2.261.1136924673', '/oradata/aracdb/onlinelog/group_2.271.1136924671' ) SIZE 200 M REUSE
DATAFILE
'/oradata/aracdb/datafile/system.265.1136924533'
CHARACTER SET AL32UTF8
sql statement: ALTER DATABASE ADD LOGFILE
INSTANCE 'i2'
GROUP 3 ( '/oradata/aracdb/onlinelog/group_3.274.1136924835', '/oradata/aracdb/onlinelog/group_3.262.1136924835' ) SIZE 200 M REUSE,
GROUP 4 ( '/oradata/aracdb/onlinelog/group_4.275.1136924837', '/oradata/aracdb/onlinelog/group_4.263.1136924837' ) SIZE 200 M REUSE
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 05/23/2023 17:17:25
RMAN-05501: aborting duplication of target database
RMAN-06136: ORACLE error from auxiliary database: ORA-00301: error in adding log file '/oradata/aracdb/onlinelog/group_3.274.1136924835' - file cannot be created
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
RMAN> exit'
오라클 rac to single 복제 시에
리두 로그 경로를 미리 만들지 않으면 에러가 난다.
ASM TO ASM이면 에러 안 날꺼 같은데...
| 백업 되지 않는 datafile 삭제 (0) | 2024.02.14 |
|---|---|
| 오라클 12c RAC TO SINGLE ACTIVE DUPLICATE(복제) (0) | 2023.05.23 |
| RAC to clonedb(single) 복구 (2) | 2014.08.15 |
| clone DB를 이용한 incomplete recovery (0) | 2012.08.08 |
| 복구에 필요한 정보 보기 (0) | 2011.11.23 |
사용하다 보면 dsm에서 리소스모니터 메모리를 보면 예약됨으로 4.7기가나 할 당 되어
사용을 못하게 되어 있음을 확인 할 수 있다.
예약됨으로 나오는 메모리 용량을 사용 할 수 있게 하는 설정 방법이다.
먼저 ssh로 접속 설정 한다.
ssh 접속 후 grub.cfg 파일에 disable_mtrr_trim 을 두번 추가 한다.
sudo -i
mkdir -p /tmp/test
cd /dev
mount synoboot1 /tmp/test
cd /tmp/test/boot/grub
sudo -i 시에 패스워드는 dsm 관리자 패스워드를 입력 하면 된다.
synoboot1을 /tmp/test에 마운트 후에 /tmp/test/boot/grub 경로로 이동 후 vi grub.cfg 실행
========================================================================================
menuentry 'RedPill DS3622xs v7.1.1-42962 (USB, Verbose)' {
savedefault
search --set=root --fs-uuid BF4E-ADE7 --hint hd0,msdos1
echo Loading Linux...
linux /zImage withefi earlyprintk syno_hw_version=DS3622xs+ console=ttyS0,115200n8 netif_num=1 pid=0x1169 earlycon=uart8250,io,0x3f8,115200n8 syno_port_thaw=1 mac1=9CB654A928BD sn=2040SQRWL3JTX vid=0x048d elevator=elevator loglevel=15 HddHotplug=0 DiskIdxMap syno_hdd_detect=0 vender_format_version=2 syno_hdd_powerup_seq=0 log_buf_len=32M root=/dev/md0 SataPortMap disable_mtrr_trim
echo Loading initramfs...
initrd /rd.gz /custom.gz
echo Starting kernel with USB boot
}
menuentry 'RedPill DS3622xs v7.1.1-42962 (SATA, Verbose)' {
savedefault
search --set=root --fs-uuid BF4E-ADE7 --hint hd0,msdos1
echo Loading Linux...
linux /zImage withefi earlyprintk syno_hw_version=DS3622xs+ console=ttyS0,115200n8 netif_num=1 pid=0x1169 earlycon=uart8250,io,0x3f8,115200n8 synoboot_satadom=2 syno_port_thaw=1 mac1=9CB654A928BD sn=2040SQRWL3JTX vid=0x048d elevator=elevator loglevel=15 HddHotplug=0 DiskIdxMap syno_hdd_detect=0 vender_format_version=2 syno_hdd_powerup_seq=0 log_buf_len=32M root=/dev/md0 SataPortMap disable_mtrr_trim
echo Loading initramfs...
initrd /rd.gz /custom.gz
echo Starting kernel with SATA boot
}
========================================================================================
menuentry 항목 중에 linux 로 시작하는 곳 제일 뒤에 disable_mtrr_trim 을 입력 후 저장
umount /tmp/test 후에 시스템을 리부 팅 하고 dsm 재 접속 후 리소스모니터 메모리를 확인하면 예약됨이 확 줄어서 가용 메모리가 늘어난 것을 알 수 있다
완료.!!
서버포럼(https://svrforum.com/)에서는 DSM7 에서는 disable_mtrr_trim=1 이렇게 넣어줘야 된다고 하는데 저의 경우에는 disable_mtrr_trim이렇게만 넣어줘도 잘 작동 하네요 테스트 해보고 편하실 대로 하시면 될 듯 합니다.
| 헤놀로지 포토스테이션 얼굴 인식 (0) | 2024.03.16 |
|---|---|
| HP N54L에 Xpenology DSM 7.1.1-42962 Update 4 설치 하기 (2) | 2023.03.17 |
N54L을 껏다 켜서 F10으로 BIOS설정에 들어간 후 Advanced 항목에서 C1E Support 항목을 꼭 Disabled로 하여야 한다.
USB(4G이상)
Win32Imager
시놀로지 설치 파일 다운 로드
https://www.synology.com/ko-kr/support/download/DS3622xs+?version=7.1#system
아래 화면에 있는 두 개 다운로드 파일 클릭
DSM 7.1.1 다운로드 및 7.1.1.-42962 Update 파일 다운로드
각각 아래 파일들이 다운이 된다.
파일 명 DSM_DS3622xs+_42962 .pat
패치 파일 synology_broadwellnk_3622xs+.pat
다운로드 https://win32diskimager.org/#download
Win32 Disk Imager - Download [Official Site]
Download Win32 Disk Imager a Fast, Secure & Reliable tool to Write Windows 10 or Windows 11 ISO Image to the Removable drive eg. Pendrive.
win32diskimager.org
로더 v0.9.4.0-1 partition sizeup & modified for M Shell
Release v0.9.4.0-1 partition sizeup & modified for M Shell · PeterSuh-Q3/tinycore-redpill
This distribution file is released by adding the m shell file to the original TCRP release of pocopico. extra Include file : my.sh.gz my.sh myv.sh myfunc.h menu.sh sngen.sh macgen.sh There is a new...
github.com
위 사이트에서 tinycore-redpill.v0.9.4.0-1.m-shell.img.gz 다운 로드 후 압축을 푼다
pc에 usb를 연결 한 후
Win32 Disk imager를 설치 후 실행
usb가 설치 되어 있는 디바이스(드라이브) 를 선택하고
tinycore-redpill.v0.9.4.0-1.m-shell.img
이미지 파일 항목에서 위 파일을 선택하고 write를 클릭 하고 100%완성 되면 USB 메모리에 부트로더 이미지를 만듭니다.
USB 메모리를 N54L 안 쪽에 디스크 꽂아 넣습니다. (밖에 포트에 해도 되나 미관상 )
리부팅 하면 부트이미지가 실행 되면 아래와 같은 창이 총 4개가 실행 됩니다.
파란화면 창에서 설정 합니다. 왼쪽에서는 아이피를 확인 합니다.
아래 순서로 진행 합니다.
Choose a Synology Model --> DS3622xs+ 선택 <<===N54L은 꼭 이모델로 해야 된다
Choose a Synology Serial Number --> Generate ...Serial Number
Choose a mac address 1 --> Get a real mac address
Build the [TCRP JOT Mod] loader <<=== N54L은 꼭 이loaderr로 해야 된다
Reboot
pc 의 브라우저 화면에서 위에서 확인 한 ip:5000 을 입력한다.(예:192.168.35.104:5000)
시놀로지 설치 화면이 나오면 수동으로 설치 선택 후
앞에서 다운 받은 DSM 설치 파일 DSM_DS3622xs+_42962 .pat 를 선택 후 설치 한다.
설치가 완료 되면
DSM 로그 인 후
제어판에 -> 업데이트 및 복원 -> 수동으로 DSM업데이트 -> 앞에서 다운 받은 synology_broadwellnk_3622xs+.pat 파일 선택
리부팅이 자동으로 된다.
리부팅 시에 GRUB 선택 화면에서 맨 아래 Tiny Core Image Build 를 선택 해야 한다.
다시 아래 화면이 나오면
Post Update for [TCRP JOT Mod] loader 선택
reboot 선택
다시 부팅이 되었 을 때
최신 버전 7.1.1-42962 Update 4 가 완료 된 것을 확인
모든 것이 끝났다.
하지만 N54L에 메모리를 4G 이상 사용 한담면 아래 설정을 추가로 해야 한다.
https://theone79.tistory.com/977
HP N54L에 Xpenology 메모리 인식 grub.cfg 수정방법
사용하다 보면 dsm에서 리소스모니터 메모리를 보면 예약됨으로 4기가 이상 할 당 되어 사용을 못하게 되어 있음을 확인 할 수 있다. 예약됨으로 나오는 메모리 용량을 사용 할 수 있게 하는 설정
theone79.tistory.com
| 헤놀로지 포토스테이션 얼굴 인식 (0) | 2024.03.16 |
|---|---|
| HP N54L에 Xpenology 메모리 인식 grub.cfg 수정방법 (0) | 2023.03.17 |
[해당 시스템 redhat 7.7 ]
버추얼 박스 7.0.6에 GUI 서버로 설치 한 후 게스트확장 이미지 설치 하려고 했으나 실패
[root@redhat7 VBox_GAs_7.0.6]# ./VBoxLinuxAdditions.run
Verifying archive integrity... 100% MD5 checksums are OK. All good.
Uncompressing VirtualBox 7.0.6 Guest Additions for Linux 100%
VirtualBox Guest Additions installer
Removing installed version 7.0.6 of VirtualBox Guest Additions...
VirtualBox Guest Additions: Starting.
VirtualBox Guest Additions: Setting up modules
VirtualBox Guest Additions: Building the VirtualBox Guest Additions kernel
modules. This may take a while.
VirtualBox Guest Additions: To build modules for other installed kernels, run
VirtualBox Guest Additions: /sbin/rcvboxadd quicksetup <version>
VirtualBox Guest Additions: or
VirtualBox Guest Additions: /sbin/rcvboxadd quicksetup all
VirtualBox Guest Additions: Building the modules for kernel
3.10.0-1062.el7.x86_64.
This system is currently not set up to build kernel modules.
Please install the gcc make perl packages from your distribution.
modprobe vboxguest failed
The log file /var/log/vboxadd-setup.log may contain further information.
[ make kernel-devel gcc perl 설치로 해결]
[root@redhat7 ~]# yum install -y make kernel-devel gcc perl
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager
This system is not registered with an entitlement server. You can use subscription-manager to register.
local-repo | 2.8 kB 00:00:00
(1/2): local-repo/group_gz | 103 kB 00:00:00
(2/2): local-repo/primary | 2.0 MB 00:00:00
local-repo 5229/5229
Package 1:make-3.82-24.el7.x86_64 already installed and latest version
Package kernel-devel-3.10.0-1062.el7.x86_64 already installed and latest version
Package 4:perl-5.16.3-294.el7_6.x86_64 already installed and latest version
Resolving Dependencies
--> Running transaction check
---> Package gcc.x86_64 0:4.8.5-39.el7 will be installed
--> Processing Dependency: cpp = 4.8.5-39.el7 for package: gcc-4.8.5-39.el7.x86_64
--> Processing Dependency: glibc-devel >= 2.2.90-12 for package: gcc-4.8.5-39.el7.x86_64
--> Running transaction check
---> Package cpp.x86_64 0:4.8.5-39.el7 will be installed
---> Package glibc-devel.x86_64 0:2.17-292.el7 will be installed
--> Processing Dependency: glibc-headers = 2.17-292.el7 for package: glibc-devel-2.17-292.el7.x86_64
--> Processing Dependency: glibc-headers for package: glibc-devel-2.17-292.el7.x86_64
--> Running transaction check
---> Package glibc-headers.x86_64 0:2.17-292.el7 will be installed
--> Processing Dependency: kernel-headers >= 2.2.1 for package: glibc-headers-2.17-292.el7.x86_64
--> Processing Dependency: kernel-headers for package: glibc-headers-2.17-292.el7.x86_64
--> Running transaction check
---> Package kernel-headers.x86_64 0:3.10.0-1062.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
=======================================================================================================================================================================
Package Arch Version Repository Size
=======================================================================================================================================================================
Installing:
gcc x86_64 4.8.5-39.el7 local-repo 16 M
Installing for dependencies:
cpp x86_64 4.8.5-39.el7 local-repo 6.0 M
glibc-devel x86_64 2.17-292.el7 local-repo 1.1 M
glibc-headers x86_64 2.17-292.el7 local-repo 687 k
kernel-headers x86_64 3.10.0-1062.el7 local-repo 8.7 M
Transaction Summary
=======================================================================================================================================================================
Install 1 Package (+4 Dependent packages)
Total download size: 33 M
Installed size: 59 M
Downloading packages:
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 66 MB/s | 33 MB 00:00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : cpp-4.8.5-39.el7.x86_64 1/5
Installing : kernel-headers-3.10.0-1062.el7.x86_64 2/5
Installing : glibc-headers-2.17-292.el7.x86_64 3/5
Installing : glibc-devel-2.17-292.el7.x86_64 4/5
Installing : gcc-4.8.5-39.el7.x86_64 5/5
Verifying : glibc-devel-2.17-292.el7.x86_64 1/5
Verifying : gcc-4.8.5-39.el7.x86_64 2/5
Verifying : kernel-headers-3.10.0-1062.el7.x86_64 3/5
Verifying : glibc-headers-2.17-292.el7.x86_64 4/5
Verifying : cpp-4.8.5-39.el7.x86_64 5/5
Installed:
gcc.x86_64 0:4.8.5-39.el7
Dependency Installed:
cpp.x86_64 0:4.8.5-39.el7 glibc-devel.x86_64 0:2.17-292.el7 glibc-headers.x86_64 0:2.17-292.el7 kernel-headers.x86_64 0:3.10.0-1062.el7
Complete!
[게스트 이미지 설치 성공]
[root@redhat7 VBox_GAs_7.0.6]# ./VBoxLinuxAdditions.run
Verifying archive integrity... 100% MD5 checksums are OK. All good.
Uncompressing VirtualBox 7.0.6 Guest Additions for Linux 100%
VirtualBox Guest Additions installer
Removing installed version 7.0.6 of VirtualBox Guest Additions...
VirtualBox Guest Additions: Starting.
VirtualBox Guest Additions: Setting up modules
VirtualBox Guest Additions: Building the VirtualBox Guest Additions kernel
modules. This may take a while.
VirtualBox Guest Additions: To build modules for other installed kernels, run
VirtualBox Guest Additions: /sbin/rcvboxadd quicksetup <version>
VirtualBox Guest Additions: or
VirtualBox Guest Additions: /sbin/rcvboxadd quicksetup all
VirtualBox Guest Additions: Building the modules for kernel
3.10.0-1062.el7.x86_64.
VirtualBox Guest Additions: Running kernel modules will not be replaced until
the system is restarted
설치 완료
| linux root 패스워드 복구 방법 (0) | 2011.05.21 |
|---|---|
| [Linux] 설치 후 설정 변경 (0) | 2010.08.11 |
| Red Hat 에 yum 설치하는 방법 (다운부터 설치까지) (0) | 2010.07.09 |
| ssh 포트 변경 (0) | 2010.02.04 |
| linux kernel panic에러시 복구 (0) | 2010.02.02 |
오라클 DB 리소스 정보가 1,2번 순서가 db 장애 이후에 바뀌어져 나올 때
리소스를 삭제하고 재 등록 하면 된다.
--------------------------------------------------------------------------------
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.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
ora.cvu
1 ONLINE ONLINE rac2 STABLE
ora.qosmserver
1 ONLINE ONLINE rac2 STABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.racdb.db
1 ONLINE ONLINE rac2 Open,HOME=/u01/app/o
racle/product/19c/db
_1,STABLE
2 ONLINE ONLINE rac1 Open,HOME=/u01/app/o
racle/product/19c/db
_1,STABLE
ora.scan1.vip
1 ONLINE ONLINE rac1 STABLE
ora.scan2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan3.vip
1 ONLINE ONLINE rac2 STABLE
--------------------------------------------------------------------------------
DB 인스턴스가 순서가 바뀌어 나옴을 확인
db 정지
srvctl stop database -d racdb
--------------------------------------------------------------------------------
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.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
ora.cvu
1 ONLINE ONLINE rac2 STABLE
ora.qosmserver
1 ONLINE ONLINE rac2 STABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.racdb.db
1 ONLINE OFFLINE Instance Shutdown,STABLE
2 ONLINE OFFLINE Instance Shutdown,STABLE
ora.scan1.vip
1 ONLINE ONLINE rac1 STABLE
ora.scan2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan3.vip
1 ONLINE ONLINE rac2 STABLE
--------------------------------------------------------------------------------
정지 확인
리소스 삭제
[racdb1:/home/oracle]> srvctl remove database -d racdb
racdb 데이터베이스를 제거하겠습니까? (y/[n]) y
삭제 완료
--------------------------------------------------------------------------------
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.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
ora.cvu
1 ONLINE ONLINE rac2 STABLE
ora.qosmserver
1 ONLINE ONLINE rac2 STABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan1.vip
1 ONLINE ONLINE rac1 STABLE
ora.scan2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan3.vip
1 ONLINE ONLINE rac2 STABLE
--------------------------------------------------------------------------------
DB 정보 나오지 않음
DB 리소스 등록
[racdb1:/home/oracle]> srvctl add database -d racdb -oraclehome /u01/app/oracle/product/19c/db_1
인스턴스 리소스 등록
[racdb1:/home/oracle]> srvctl add instance -db racdb -instance racdb1 -node rac1
[racdb1:/home/oracle]> srvctl add instance -db racdb -instance racdb2 -node rac2
[racdb1:/home/oracle]> srvctl start database -d racdb
PRCR-1079 : ora.racdb.db 리소스 시작을 실패했습니다.
CRS-5017: The resource action "ora.racdb.db start" encountered the following error:
ORA-01078: failure in processing system parameters
LRM-00109: '/u01/app/oracle/product/19c/db_1/dbs/initracdb1.ora' ������������ ��������� ��� ��� ������������
. For details refer to "(:CLSN00107:)" in "/u01/app/oracle/diag/crs/rac1/crs/trace/crsd_oraagent_oracle.trc".
CRS-5017: The resource action "ora.racdb.db start" encountered the following error:
ORA-01078: failure in processing system parameters
LRM-00109: '/u01/app/oracle/product/19c/db_1/dbs/initracdb2.ora' ������������ ��������� ��� ��� ������������
. For details refer to "(:CLSN00107:)" in "/u01/app/oracle/diag/crs/rac2/crs/trace/crsd_oraagent_oracle.trc".
CRS-2674: Start of 'ora.racdb.db' on 'rac2' failed
CRS-2632: There are no more servers to try to place resource 'ora.racdb.db' on that would satisfy its placement policy
CRS-2674: Start of 'ora.racdb.db' on 'rac1' failed
혹시 라도 기동 실패시에 1,2번 노드에서 각 각 오라클 홈 밑에 dbs 경로에 spfile 경로를 지정해 주면 된다.
파라미터 파일 을 못 찾아서 나는 에러
[racdb1:/u01/app/oracle/product/19c/db_1/dbs]> vi initracdb1.ora
spfile='+data/racdb/parameterfile/spfile.274.1093539721'
2번 서버
[racdb2:/u01/app/oracle/product/19c/db_1/dbs]> vi initracdb2.ora
spfile='+data/racdb/parameterfile/spfile.274.1093539721'
정상 적으로 기동 완료
[racdb1:/home/oracle]> srvctl start database -d racdb
--------------------------------------------------------------------------------
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.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE rac1 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE rac1 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
ora.cvu
1 ONLINE ONLINE rac1 STABLE
ora.qosmserver
1 ONLINE ONLINE rac1 STABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.racdb.db
1 ONLINE ONLINE rac1 Open,HOME=/u01/app/o
racle/product/19c/db
_1,STABLE
2 ONLINE ONLINE rac2 Open,HOME=/u01/app/o
racle/product/19c/db
_1,STABLE
ora.scan1.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan2.vip
1 ONLINE ONLINE rac1 STABLE
ora.scan3.vip
1 ONLINE ONLINE rac1 STABLE
--------------------------------------------------------------------------------
정상 확인
| ORACLE RAC DATABASE RESOURCE 삭제 (0) | 2023.03.06 |
|---|---|
| RAC 리소스 상태 확인 명령어 변경 (0) | 2023.03.06 |
| rac 리소스 재등록 (0) | 2019.10.08 |
| oracle rac to single (0) | 2016.06.10 |
| IBM General Parallel File System (GPFS) 3.2-3.5, 4.1 and Oracle RAC (문서 ID 1376369.1) (0) | 2015.09.06 |
RAC에서 DB 인스턴스 종료 후
ORACLE RAC DATABASE RESOURCE 삭제
[racdb1:/home/oracle]> srvctl remove database -d racdb
racdb 데이터베이스를 제거하겠습니까? (y/[n]) y
하면
--------------------------------------------------------------------------------
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.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
ora.cvu
1 ONLINE ONLINE rac2 STABLE
ora.qosmserver
1 ONLINE ONLINE rac2 STABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.racdb.db
1 OFFLINE OFFLINE Instance Shutdown,STABLE
2 OFFLINE OFFLINE Instance Shutdown,STABLE
ora.scan1.vip
1 ONLINE ONLINE rac1 STABLE
ora.scan2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan3.vip
1 ONLINE ONLINE rac2 STABLE
--------------------------------------------------------------------------------
삭제 후
--------------------------------------------------------------------------------
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.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
ora.cvu
1 ONLINE ONLINE rac2 STABLE
ora.qosmserver
1 ONLINE ONLINE rac2 STABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan1.vip
1 ONLINE ONLINE rac1 STABLE
ora.scan2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan3.vip
1 ONLINE ONLINE rac2 STABLE
--------------------------------------------------------------------------------
RACDB 리소스 삭제 확인
| RAC 장애 후 인스턴스 리소스 순서 이상 할 때 (0) | 2023.03.06 |
|---|---|
| RAC 리소스 상태 확인 명령어 변경 (0) | 2023.03.06 |
| rac 리소스 재등록 (0) | 2019.10.08 |
| oracle rac to single (0) | 2016.06.10 |
| IBM General Parallel File System (GPFS) 3.2-3.5, 4.1 and Oracle RAC (문서 ID 1376369.1) (0) | 2015.09.06 |
|
