728x90
반응형
1. 기본구성
Oralce Linux 7.9 / Oracle 19.3.0.0.0
2. RMAN을 이용한 백업
[RACDB1:/home/oracle]> rman target sys/oracle@racdb
Recovery Manager: Release 19.0.0.0.0 - Production on Wed Apr 16 14:40:57 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: RACDB (DBID=1176255865)
RMAN> backup database;
Starting backup at 25/04/16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=281 instance=RACDB1 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/RACDB/DATAFILE/system.257.1178638967
input datafile file number=00003 name=+DATA/RACDB/DATAFILE/sysaux.258.1178639001
input datafile file number=00004 name=+DATA/RACDB/DATAFILE/undotbs1.259.1178639027
input datafile file number=00002 name=+DATA/RACDB/DATAFILE/cubeone01.dbf
input datafile file number=00005 name=+DATA/RACDB/DATAFILE/undotbs2.265.1178639369
input datafile file number=00007 name=+DATA/RACDB/DATAFILE/users.260.1178639027
channel ORA_DISK_1: starting piece 1 at 25/04/16
channel ORA_DISK_1: finished piece 1 at 25/04/16
piece handle=+FRA/RACDB/BACKUPSET/2025_04_16/nnndf0_tag20250416t140646_0.262.1198591607 tag=TAG20250416T140646 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 25/04/16
Starting Control File and SPFILE Autobackup at 25/04/16
piece handle=+FRA/RACDB/AUTOBACKUP/2025_04_16/s_1198591614.293.1198591615 comment=NONE
Finished Control File and SPFILE Autobackup at 25/04/16
3. 사용자 데이터 업데이트
SQL> SELECT * FROM DEPT;
DEPTNO
------------------------------------------------------------
DNAME
------------------------------------------------------------
LOC
------------------------------------------------------------
1
a
1F
2
b
2F
DEPTNO
------------------------------------------------------------
DNAME
------------------------------------------------------------
LOC
------------------------------------------------------------
SQL> insert into dept values(3,'c','3F');
1 row created.
SQL> INSERT INTO dept values(4,'d','4F');
1 row created.
SQL> INSERT INTO dept values(5,'e','5F');
1 row created.
SQL> COMMIT;
Commit complete.
SQL> select * from dept;
DEPTNO
------------------------------------------------------------
DNAME
------------------------------------------------------------
LOC
------------------------------------------------------------
1
a
1F
2
b
2F
DEPTNO
------------------------------------------------------------
DNAME
------------------------------------------------------------
LOC
------------------------------------------------------------
3
c
3F
4
d
DEPTNO
------------------------------------------------------------
DNAME
------------------------------------------------------------
LOC
------------------------------------------------------------
4F
5
e
5F
4. 장애 발생 유도
SQL> alter diskgroup DATA drop file '+DATA/RACDB/DATAFILE/users.260.1178639027';
alter diskgroup DATA drop file '+DATA/RACDB/DATAFILE/users.260.1178639027'
*
ERROR at line 1:
ORA-03135: connection lost contact
Process ID: 15366
Session ID: 282 Serial number: 65143
----------데이터베이스가 운영중이라 삭제 x
[RACDB1:/home/oracle]> srvctl stop database -d racdb
----------데이터베이스 종료
SQL> alter diskgroup DATA drop file '+DATA/RACDB/DATAFILE/users.260.1178639027';
----------파일 삭제
[RACDB1:/home/oracle]> srvctl start database -d racdb
----------데이터베이스 구동중에 오류 발생
5. 복구
[RACDB1:/home/oracle]> srvctl start database -d racdb -o mount
---------- MOUNT모드로 데이터베이스 접속
[RACDB1:/home/oracle]> rman target sys/oracle@racdb
---------- rman 접속
RMAN> list backup;
using target database control file instead of recovery catalog
List of Backup Sets
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- -------- ----------- ------ ----
1 Full 5903255 25/04/16 NO +DATA/RACDB/DATAFILE/system.257.1178638967
2 Full 5903255 25/04/16 NO +DATA/RACDB/DATAFILE/cubeone01.dbf
3 Full 5903255 25/04/16 NO +DATA/RACDB/DATAFILE/sysaux.258.1178639001
4 Full 5903255 25/04/16 NO +DATA/RACDB/DATAFILE/undotbs1.259.1178639027
5 Full 5903255 25/04/16 NO +DATA/RACDB/DATAFILE/undotbs2.265.1178639369
7 Full 5903255 25/04/16 NO +DATA/RACDB/DATAFILE/users.260.1178639027 ----------복구파일
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
10 Full 18.92M DISK 00:00:01 25/04/16
BP Key: 10 Status: AVAILABLE Compressed: NO Tag: TAG20250416T140654
Piece Name: +FRA/RACDB/AUTOBACKUP/2025_04_16/s_1198591614.293.1198591615
SPFILE Included: Modification time: 25/04/16
SPFILE db_unique_name: RACDB
Control File Included: Ckp SCN: 5903268 Ckp time: 25/04/16
RMAN> restore datafile '+DATA/RACDB/DATAFILE/users.260.1178639027';
Starting restore at 25/04/16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=271 instance=RACDB2 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00007 to +DATA/RACDB/DATAFILE/users.260.1178639027
channel ORA_DISK_1: reading from backup piece +FRA/RACDB/BACKUPSET/2025_04_16/nnndf0_tag20250416t140646_0.262.1198591607
channel ORA_DISK_1: piece handle=+FRA/RACDB/BACKUPSET/2025_04_16/nnndf0_tag20250416t140646_0.262.1198591607 tag=TAG20250416T140646
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
Finished restore at 25/04/16
RMAN> recover datafile 7;
Starting recover at 25/04/16
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:01
Finished recover at 25/04/16
RMAN> exit
[RACDB1:/home/oracle]> srvctl stop database -d racdb
---------- 데이터베이스 종료
[RACDB1:/home/oracle]> srvctl start database -d racdb
---------- 데이터베이스 구동
SQL> select * from dept;
DEPTNO
------------------------------------------------------------
DNAME
------------------------------------------------------------
LOC
------------------------------------------------------------
1
a
1F
2
b
2F
DEPTNO
------------------------------------------------------------
DNAME
------------------------------------------------------------
LOC
------------------------------------------------------------
3
c
3F
4
d
DEPTNO
------------------------------------------------------------
DNAME
------------------------------------------------------------
LOC
------------------------------------------------------------
4F
5
e
5F728x90
반응형
'Operating System > ORACLE' 카테고리의 다른 글
| Oracle Linux 7.9에 Oracle19c RAC 설치-(1) (0) | 2024.10.07 |
|---|---|
| 오라클 TABLESPACE 파일경로 확인 및 이동 (0) | 2023.11.07 |
| Oracle 11g 아카이브 로그 모드(archive log mode) 변경 (0) | 2023.07.14 |
| [ORACLE 12c] 설치 시 오류(DISPLAY not set. Please set the DISPLAY and try again.) (1) | 2023.03.14 |
| Windows 10에 Oracle 12c 클라이언트 설치 (0) | 2023.02.16 |