Tibero

[ The imperialist Japanese military must officially acknowledge and apologize for the coercion of young women into sexual slaves. / 幼い女性を性の奴隷にした帝國主義日本軍の?制性を公式に認め、謝罪しなければならない. ]

사용자

ID:
PW:

INDEX

01.게시판

게시판 [72]

02.File Book

		File 자료실 [96]
		Site Link [14]
		개인폴더 [201]

03.Field Book

		Altibase [19]
		Tibero [31]
		MS-SQL [32]
		MySQL [47]
		DB2 [79]
		ORACLE [3202]
		PSQL [143]
		CUBRID [5]
		기타정보 [193]
		운영체제 [633]

04.Q/A Book

Q/A [53]

05.방명록

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

기념일

LINK

+ 가족 Hompy
+ DNSEver

IOTN :: Field Book :: Tibero

회원가입

TBR-1004: Unable to read file TBR-7004: This DDL statement is not permitted

최길호 [LIST]

2017-11-26 19:51:47, 조회 : 3,056

[tibero@dbsvr bin]$ ./tbboot
Listener port = 8629
Change core dump dir to /home/tibero/Tibero/tibero5/bin.

********************************************************
* Critical Warning : Raise svmode failed. The reason is
*   TBR-1024 :  Database needs media recovery: open failed(/home/tibero/Tibero/tibero5/database/tibero/O1_MF_FLASH_TB_CTV5F3SY_.dbf).
*   Current server mode is MOUNT.
********************************************************

Tibero 5 SP1

TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started suspended at MOUNT mode.
SQL> alter database recover automatic ;
TBR-1004: Unable to read file /home/tibero/Tibero/tibero5/database/tibero/O1_MF_FLASH_TB_CTV5F3SY_.dbf.

SQL> col error for a15
SQL> select * from v$recover_file;

     FILE# ONLINE  ERROR              CHANGE# TIME
---------- ------- --------------- ---------- --------------------------------
        13 ONLINE  open failed

SQL> alter database datafile 13 offline;
TBR-7004: This DDL statement is not permitted in the current boot mode.

SQL> alter database datafile 13 offline for drop;

Database altered.

SQL> alter database recover automatic ;

Database altered.

SQL> alter database open;

Database altered.

SQL> drop tablespace test including contents and datafiles;

[tibero@dbsvr bin]$ ./tbdown

Tibero instance terminated (NORMAL mode).

[tibero@dbsvr bin]$ ./tbboot
Listener port = 8629
Change core dump dir to /home/tibero/Tibero/tibero5/bin.

Tibero 5 SP1

TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started up (NORMAL mode).
[tibero@dbsvr bin]$

216.73.216.78

LIST

	제목	작성자	작성일	조회
Admin	error code[-18001] : System call error : 112 (SetEndOfFile())	최길호	2024/08/27	32
Troubleshoot	ERROR: bind error (port=8200) [Address already in use]	최길호	2022/02/18	225
Admin	Tibero 5 , SP1, patch, downgrad 메모	최길호	2021/02/10	2330
Admin	tibero jdbc driver version 확인	최길호	2021/02/01	603
Admin	rename db name / TB_SID	최길호	2021/02/01	1004
Troubleshoot	T-UP / SELECT COUNT(*) FROM ALL_TYPES WHERE TYPE_NAME = 'XMLTYPE'	최길호	2021/02/01	5614
Backup and Recovery	alter database backup controlfile to trace / CREATE CONTROLFILE / alter system set _CF_DD_CHECK=N	최길호	2021/01/29	486
Troubleshoot	interal dd update failed!! [ patch 필요 ]	최길호	2020/12/20	70550
Backup and Recovery	TBR-1024 : Database needs media recovery	최길호	2020/12/20	3215
Troubleshoot	* Cannot get semaphore:errno=28	최길호	2019/03/06	4409
Backup and Recovery	tbexport TBR-90401: JDBC-90401:Connection refused by the server. - Connection refused	최길호	2019/02/15	3863
Troubleshoot	TBR-8033: Specified schema object was not found.	최길호	2018/07/11	158054
Admin	tibero6 수동 설치	최길호	2018/07/11	26009
Backup and Recovery	TBR-1004: Unable to read file TBR-7004: This DDL statement is not permitted	최길호	2017/11/26	3056
Admin	Tibero SQL Trace [ SQL_TRACE / DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION / SET AUTOTRACE ON / v$sql_plan ]	최길호	2017/09/06	16278
Admin	Tibero 모니터링 가이드 - TechNet	최길호	2017/09/05	16308
Troubleshoot	java.sql.SQLSyntaxErrorException: ORA-00924: missing BY keyword	최길호	2016/08/25	3463

목록보기 다음페이지

1 [2]

최근 댓글

최근 게시물

06/27

[ORACLE]
The clock on host node2 differ....
by 최길호

06/26

[ORACLE]
PRCD-1229 ORA-29701: unable to....
by 최길호

06/17
[기타정보]
tmmd [COM0603]: Connection ref....
by 최길호