❗️Test
<TIBERO 백업복구>
가. 점검
:티베로 데이터베이스가 정상적인 상태인지 점검하세요.
- tbdown immediate
- tbboot
- select name from v$database;
- select username from dba_users;
나. 백업
:온라인 백업을 수행하세요.
- 모든 데이터파일,리두로그,아카이브로그,컨트롤파일,파라미터파일,패스워드파일solution )
[tibero@T1:/tibero/s]$ tbsql sys/tibero
tbSQL 6
TmaxData Corporation Copyright (c) 2008-. All rights res erved.
Connected to Tibero.
SQL> ALTER TABLESPACE SYSTEM BEGIN BACKUP;
Tablespace 'SYSTEM' altered.
SQL> !cp /tibero/0930/db/data/system001.dtf /tibero/s/ba ckup_on
SQL> ALTER TABLESPACE SYSTEM END BACKUP;
Tablespace 'SYSTEM' altered.
SQL> ALTER TABLESPACE UNDO BEGIN BACKUP;
Tablespace 'UNDO' altered.
SQL> !cp /tibero/0930/db/data/undo001.dtf /tibero/s/back up_on
SQL> ALTER TABLESPACE UNDO END BACKUP;
Tablespace 'UNDO' altered.
SQL> ALTER TABLESPACE USR BEGIN BACKUP;
Tablespace 'USR' altered.
SQL> !cp /tibero/0930/db/data/usr001.dtf /tibero/s/backu p_on
SQL> ALTER TABLESPACE USR END BACKUP;
Tablespace 'USR' altered.
SQL> ALTER TABLESPACE SYSSUB BEGIN BACKUP;
TBR-24010: Tablespace SYSSUB is in online backup mode.
SQL> !cp /tibero/0930/db/data/syssub001.dtf /tibero/s/ba ckup_on
SQL> ALTER TABLESPACE SYSSUB END BACKUP;
Tablespace 'SYSSUB' altered.
SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS '/tib ero/s/backup_on/crectl.sql' REUSE NORESETLOGS;
Database altered.
SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.
SQL> !cp /tibero/tbdata/tibero/arch/*.arc /tibero/s/back up_on
cp: cannot stat ‘/tibero/tbdata/tibero/arch/*.arc’: No s uch file or directory
SQL> !cp /tibero/0930/db/arch/*.arc /tibero/s/backup_on
SQL> q
Disconnected.
[tibero@T1:/tibero/s]$ cd ~/tibero.tip
-bash: cd: /home/tibero/tibero.tip: No such file or dire ctory
[tibero@T1:/tibero/s]$ cd /tibero/tibero6
[tibero@T1:/tibero/tibero6]$ cd config/
[tibero@T1:/tibero/tibero6/config]$ ls
cm.template ilog.map.example tip.template
gen_psm_cmd.sh psm_commands variant
gen_tip_for_tac.sh tac.template
gen_tip.sh tibero.tip
[tibero@T1:/tibero/tibero6/config]$ tbsql sys/tibero
tbSQL 6
TmaxData Corporation Copyright (c) 2008-. All rights res erved.
Connected to Tibero.
SQL> !cp /tibero/tibero6/config/tibero.tip /tibero/s/ backup_on
SQL> !cp /tibero/tbdata/tibero/.passwd /tibero/s/ backup_on
cp: cannot stat ‘/tibero/tbdata/tibero/.passwd’: No such file or directory
SQL> !cp /tibero/0928/dbs/password/.passwd /tibero/s/bac kup_on
cp: cannot stat ‘/tibero/0928/dbs/password/.passwd’: No such file or directory
SQL> q
Disconnected.
[tibero@T1:/tibero/tibero6/config]$ cd ^C
[tibero@T1:/tibero/tibero6/config]$ cd /tibero/tbdata/ti bero/
[tibero@T1:/tibero/tbdata/tibero]$ ls
[tibero@T1:/tibero/tbdata/tibero]$ cd /tibero/0930/db
[tibero@T1:/tibero/0930/db]$ ls
arch cont1 cont2 data java redo1 redo2
[tibero@T1:/tibero/0930/db]$ ls -al
total 4
drwxr-xr-x 9 tibero dba 109 Oct 6 19:55 .
drwxr-xr-x 4 tibero dba 131 Sep 30 15:33 ..
drwxr-xr-x 2 tibero dba 152 Oct 7 15:47 arch
drwxr-xr-x 2 tibero dba 20 Sep 30 15:33 cont1
drwxr-xr-x 2 tibero dba 20 Sep 30 15:33 cont2
drwxr-xr-x 2 tibero dba 104 Sep 30 15:33 data
drwx------ 2 tibero dba 70 Sep 30 15:35 java
-r-------- 1 tibero dba 24 Sep 30 15:33 .passwd
drwxr-xr-x 2 tibero dba 91 Sep 30 15:33 redo1
drwxr-xr-x 2 tibero dba 91 Sep 30 15:33 redo2
[tibero@T1:/tibero/0930/db]$ tbsql sys/tibero
tbSQL 6
TmaxData Corporation Copyright (c) 2008-. All rights res erved.
Connected to Tibero.
SQL> !cp /tibero/0930/db/.passwd /tibero/s/backup_on
SQL> !ls -al /tibero/s/backup_on
total 960961
drwxrwx--- 1 root vboxsf 4096 Oct 7 15:52 .
drwxrwx--- 1 root vboxsf 4096 Oct 7 15:44 ..
-rwxrwx--- 1 root vboxsf 1192 Oct 7 15:47 crectl.s ql
-rwxrwx--- 1 root vboxsf 55296 Oct 7 15:48 log-t0-r 0-s10.arc
-rwxrwx--- 1 root vboxsf 2048 Oct 7 15:48 log-t0-r 0-s11.arc
-rwxrwx--- 1 root vboxsf 480256 Oct 7 15:48 log-t0-r 0-s6.arc
-rwxrwx--- 1 root vboxsf 15728640 Oct 7 15:48 log-t0-r 0-s7.arc
-rwxrwx--- 1 root vboxsf 3033088 Oct 7 15:48 log-t0-r 0-s8.arc
-rwxrwx--- 1 root vboxsf 7168 Oct 7 15:48 log-t0-r 0-s9.arc
-rwxrwx--- 1 root vboxsf 24 Oct 7 15:52 .passwd
-rwxrwx--- 1 root vboxsf 104857600 Oct 7 15:47 syssub00 1.dtf
-rwxrwx--- 1 root vboxsf 377487360 Oct 7 15:45 system00 1.dtf
-rwxrwx--- 1 root vboxsf 778 Oct 7 15:50 tibero.t ip
-rwxrwx--- 1 root vboxsf 377487360 Oct 7 15:46 undo001. dtf
-rwxrwx--- 1 root vboxsf 104857600 Oct 7 15:46 usr001.d tf
SQL> DESC DBA_DATA_FILES;
COLUMN_NAME TYPE CONSTRAINT
---------------------------------------- ------------------ --------------------
FILE_NAME VARCHAR(256)
FILE_ID NUMBER
TABLESPACE_NAME VARCHAR(128)
BYTES NUMBER
BLOCKS NUMBER
STATUS CHAR(9)
RELATIVE_FNO NUMBER
AUTOEXTENSIBLE VARCHAR(3)
MAXBYTES NUMBER
MAXBLOCKS NUMBER
INCREMENT_BY NUMBER
SQL> DESC V$TABLESPACE;
COLUMN_NAME TYPE CONSTRAINT
---------------------------------------- ------------------ --------------------
TS# NUMBER
NAME VARCHAR(128)
TYPE VARCHAR(4)
BIGFILE CHAR(2)
FLASHBACK_ON CHAR(2)
SQL> DESC V$DATAFILE;
COLUMN_NAME TYPE CONSTRAINT
---------------------------------------- ------------------ --------------------
FILE# NUMBER
CREATE_TSN NUMBER
CREATE_DATE DATE
TS# NUMBER
RFILE# NUMBER
STATUS VARCHAR(7)
ENABLED VARCHAR(10)
CKPT_TSN NUMBER
CKPT_DATE DATE
CREATE_BYTES NUMBER
NAME VARCHAR(256)
다. 데이터파일 삭제, 비정상종료
:데이터파일을 삭제하고. 비정상 종료하세요
- SYSTEM 테이블스페이스에서 사용하는 데이터파일 system001.dtf 삭제
- `tbdown abnormal
solution )
SQL> SELECT TS# FROM V$DATAFILE WHERE FILE#=0;
TS#
----------
0
1 row selected.
SQL> SELECT NAME FROM V$TABLESPACE WHERE TS#=0;
NAME
--------------------------------------------------------------------------------
SYSTEM
1 row selected.
SQL> Q
Disconnected.
[tibero@T1:/tibero/0930/db]$ TBDOWN
bash: TBDOWN: command not found...
[tibero@T1:/tibero/0930/db]$ tbdown
Tibero instance terminated (NORMAL mode).
[tibero@T1:/tibero/0930/db]$ tbboot
Listener port = 9629
Tibero 6
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started up (NORMAL mode).
[tibero@T1:/tibero/0930/db]$ tbsql sys/tibero
tbSQL 6
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Connected to Tibero.
SQL> SELECT NAME FROM V$DATABASE;
NAME
----------------------------------------
t0930db
1 row selected.
SQL> SELECT USERNAME FROM DBA_USERS;
USERNAME
--------------------------------------------------------------------------------
SYSCAT
SYSGIS
OUTLN
TIBERO
TIBERO1
T0930DB
EDU_DBLINK
LINKTEST
K
SYS
10 rows selected.
SQL> !rm /tibero/0930/db/data/system001.dtf
SQL> q
Disconnected.
[tibero@T1:/tibero/0930/db]$ tbdown abnormal
Tibero instance terminated (ABNORMAL mode).
라. 기동
tbboot실행하여 에러 메시지 출력함.
[tibero@T1:/tibero/0930/db]$ tbboot
Listener port = 9629
********************************************************
* Critical Warning : Raise svmode failed. The reason is
* TBR-1024 : Database needs media recovery: open failed(/tibero/0930/db/data/system001.dtf).
* Current server mode is MOUNT.
********************************************************
Tibero 6
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started suspended at MOUNT mode.
[tibero@T1:/tibero/0930/db]$ COL TIME FOR A10
bash: COL: command not found...
Similar command is: 'col'
[tibero@T1:/tibero/0930/db]$ COL TIME FOR A10
bash: COL: command not found...
Similar command is: 'col'
마. 복구
:복구를 하세요.
- 마운트 모드에서 복구명령 사용하여 진행함.
solution)
[tibero@T1:/tibero/0930/db]$ tbsql sys/tibero
tbSQL 6
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Connected to Tibero.
SQL> COL TIME FOR A10
SQL> COL ERROR FOR A30
SQL> SELECT * FROM V$RECOVER_FILE;
FILE# ONLINE ERROR CHANGE# TIME
---------- ------- ------------------------------ ---------- ----------
0 ONLINE open failed 0
1 row selected.
SQL> SELECT NAME FROM V$DATAFILE WHERE FILE# = 0;
NAME
--------------------------------------------------------------------------------
/tibero/0930/db/data/system001.dtf
1 row selected.
SQL> !ls /tibero/0930/db/data/system001.dtf
ls: cannot access /tibero/0930/db/data/system001.dtf: No such file or directory
SQL> !cp /tibero/s/backup_on/system001.dtf /tibero/0930/db/data/system001.dtf
SQL> !ls /tibero/0930/db/data/system001.dtf
/tibero/0930/db/data/system001.dtf
SQL> SELECT * FROM V$RECOVER_FILE;
FILE# ONLINE ERROR CHANGE# TIME
---------- ------- ------------------------------ ---------- ----------
0 ONLINE file restored 68187 2022/10/07
1 row selected.
SQL> ALTER DATABASE RECOVER AUTOMATIC DATABASE;
Database altered.
SQL> Q
Disconnected.
[tibero@T1:/tibero/0930/db]$ tbdown
Tibero instance terminated (NORMAL mode).
[tibero@T1:/tibero/0930/db]$ tbboot
Listener port = 9629
Tibero 6
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started up (NORMAL mode).
바. 점검
:티베로 데이터베이스가 정상적인 상태인지 점검하세요.
- tbdown immediate
- tbboot
- select name from v$database;
- select username from dba_users;
코딩하는 에디