Tibero

http://iotn.co.kr 연락처: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / 日本政府は日本軍の性的奴隷?牲者に謝罪すべき. ]

사용자

ID:
PW:

INDEX

01.게시판

게시판 [71]

02.File Book

		File 자료실 [95]
		Site Link [17]
		개인폴더 [200]

03.Field Book

		Altibase [19]
		Tibero [30]
		MS-SQL [18]
		MySQL [41]
		DB2 [79]
		ORACLE [2955]
		PSQL [132]
		기타정보 [155]
		운영체제 [591]

04.Q/A Book

Q/A [53]

05.방명록

		방명록 [54]
		레벨업 [37]
		구인/구직 [2]

기념일

LINK

+ 가족 Hompy
+ DNSEver

IOTN :: Field Book :: Tibero

회원가입

alter database backup controlfile to trace / CREATE CONTROLFILE / alter system set _CF_DD_CHECK=N

최길호 [LIST]

2021-01-29 21:33:58, 조회 : 390

출처: https://technet.tmaxsoft.com/ko/front/technology/viewTechnology.do?cmProductCode=0301&paging.page=1&kss_seq=KSSQ-20170912-000001



select file_name, tablespace_name from dba_datafiles order by 1;

tbdown

rm /home/tibero5/tbdata/usr002.dtf

tbboot

********************************************************

* Critical Warning : Raise svmode failed. The reason is

* TBR-1024 : Database needs media recovery: open

failed(/home/tibero5/tbdata/usr002.dtf).

* Current server mode is MOUNT.

********************************************************



tbsql sys/tibero

SQL>alter database backup controlfile to trace as '/home/tibero5/tbdata/ctrl_backup.sql';



tbdown



vi /home/tibero5/tbdata/ctrl_backup.sql

CREATE CONTROLFILE REUSE DATABASE "tibero"

LOGFILE

GROUP 0 '/home/tibero5/tbdata/redo001.redo' SIZE 100M,

GROUP 1 '/home/tibero5/tbdata/redo003.redo' SIZE 100M,

GROUP 2 '/home/tibero5/tbdata/redo004.redo' SIZE 100M

NORESETLOGS

DATAFILE

 '/home/tibero5/tbdata/system001.dtf',

 '/home/tibero5/tbdata/undo001.dtf',

 '/home/tibero5/tbdata/usr001.dtf',

 '/home/tibero5/tbdata/apm_ts.dtf'

-- '/home/tibero5/tbdata/undo002.dtf' <-- 삭제

NOARCHIVELOG

MAXLOGFILES 100

MAXLOGMEMBERS 8

MAXDATAFILES 1024

MAXARCHIVELOG 500

MAXLOGHISTORY 500

CHARACTER SET UTF8

NATIONAL CHARACTER SET UTF16

;



tbboot nomount

tbsql sys/tibero

SQL> @ctrl_backup.sql

tbdown

tbboot mount



tbsql sys/tibero

SQL> alter database recover automatic;

alter system set _CF_DD_CHECK=N;

select name, value from _vt_parameter where name='_CF_DD_CHECK';

alter database open;



※ TB_SID.tip 에 완전복구 전까지 추가 _CF_DD_CHECK=N

44.200.145.223

LIST

	제목	작성자	작성일	조회
Troubleshoot	ERROR: bind error (port=8200) [Address already in use]	최길호	2022/02/18	158
Admin	Tibero 5 , SP1, patch, downgrad 메모	최길호	2021/02/10	2102
Admin	tibero jdbc driver version 확인	최길호	2021/02/01	531
Admin	rename db name / TB_SID	최길호	2021/02/01	374
Troubleshoot	T-UP / SELECT COUNT(*) FROM ALL_TYPES WHERE TYPE_NAME = 'XMLTYPE'	최길호	2021/02/01	5173
Backup and Recovery	alter database backup controlfile to trace / CREATE CONTROLFILE / alter system set _CF_DD_CHECK=N	최길호	2021/01/29	390
Troubleshoot	interal dd update failed!! [ patch 필요 ]	최길호	2020/12/20	69835
Backup and Recovery	TBR-1024 : Database needs media recovery	최길호	2020/12/20	2576
Troubleshoot	* Cannot get semaphore:errno=28	최길호	2019/03/06	4265
Backup and Recovery	tbexport TBR-90401: JDBC-90401:Connection refused by the server. - Connection refused	최길호	2019/02/15	3652
Troubleshoot	TBR-8033: Specified schema object was not found.	최길호	2018/07/11	157051
Admin	tibero6 수동 설치	최길호	2018/07/11	25909
Backup and Recovery	TBR-1004: Unable to read file TBR-7004: This DDL statement is not permitted	최길호	2017/11/26	2901
Admin	Tibero SQL Trace [ SQL_TRACE / DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION / SET AUTOTRACE ON / v$sql_plan ]	최길호	2017/09/06	16165
Admin	Tibero 모니터링 가이드 - TechNet	최길호	2017/09/05	16240
Troubleshoot	java.sql.SQLSyntaxErrorException: ORA-00924: missing BY keyword	최길호	2016/08/25	3368
Troubleshoot	Oracle dblink Tibero UTF8 DB 한글처리	최길호	2015/09/08	10887

목록보기 다음페이지

1 [2]

최근 댓글

최근 게시물

06/05

[ORACLE]
ORA-27303: additional informat....
by 최길호

06/02

[게시판]
2023년 적용 SW(소프트웨어)기술자 평균임금 ....
by 최길호

06/01
[ORACLE]
ORA-19504: failed to create fi....
by 최길호