ORACLE

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

사용자

ID:
PW:

INDEX

01.게시판

게시판 [69]

02.File Book

		File 자료실 [95]
		Site Link [18]
		개인폴더 [194]

03.Field Book

		Altibase [19]
		Tibero [30]
		MS-SQL [18]
		MySQL [40]
		DB2 [79]
		ORACLE [2896]
		PostgreSQL [103]
		기타정보 [150]
		운영체제 [583]

04.Q/A Book

Q/A [53]

05.방명록

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

기념일

LINK

+ 가족 Hompy
+ DNSEver

IOTN :: Field Book :: ORACLE

회원가입

ORA-01152: file 1 was not restored from a sufficiently old backup ORA-16433: The database or pluggable database must be opened in read/write mode.

최길호 [LIST]

2021-09-23 11:40:25, 조회 : 6,570



_allow_error_simulation=TRUE

_allow_resetlogs_corruption=TRUE

_allow_terminal_recovery_corruption=TRUE

_no_recovery_through_resetlogs=TRUE



SYS@db19c> recover database using backup controlfile until cancel;

ORA-00279: change 16688065253279 generated at 09/23/2021 00:59:26 needed for thread 1 [ 00:59:26 시간은 DB 백업중 ]

ORA-00289: suggestion : /arch/1_1419_1083697910.arc

ORA-00280: change 16688065253279 for thread 1 is in sequence #1419



11:34:38 Specify log: {=suggested | filename | AUTO | CANCEL}

cancel [ 입력 ]

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01152: file 1 was not restored from a sufficiently old backup  [ DB 백업중 <--> 완료 까지 archive 로그가 존재 하니 더 복구 해야 한다. ]

ORA-01110: data file 1: '/oradata/db19c/SYSTEM.1.dbf'





이거 무시하고 resetlog open 하면 아래 에러 발생. [ 가능 하다면 archivelog를 더 복구 하고 cancel ]



http://iotn.co.kr/power/zboard.php?id=9_1_bbs&no=2941

ORA-00600: internal error code, arguments: [kcbzib_kcrsds_1]



SYS@19c> alter database backup controlfile to trace as '/tmp/a' reuse;

ORA-16433: The database or pluggable database must be opened in read/write mode.



SYS@19c> recover database using backup controlfile until cancel;

ORA-00283: recovery session canceled due to errors

ORA-16433: The database or pluggable database must be opened in read/write mode.

18.207.157.152

LIST

	제목	작성자	작성일	조회
Install and Config	ASM Filter / asmcmd afd_label / asmcmd afd_lslbl / gridSetup.sh 설치전 asm disk	최길호	2021/10/07	288
Troubleshoot	sqlplus: /lib64/libc.so.6: version `GLIBC_2.14' not found	최길호	2021/10/06	692
Troubleshoot	19c _optimizer_cost_based_transformation off bug [ SR 확인 ] lv:9	최길호	2021/10/05	889
Troubleshoot	ORA-12609: TNS: Receive timeout occurred	최길호	2021/10/03	1009
Troubleshoot	EXP-00083: The previous problem occurred when calling SYS.DBMS_AUTO_TASK_EXPORT.system_info_exp	최길호	2021/10/02	796
Troubleshoot	grid 19c crsctl start has / CRS-41053 / Infrastructure has 재구축	최길호	2021/10/01	833
Troubleshoot	ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT	최길호	2021/09/30	277
Admin	alter table add column large table [ 11gR2 부터 빠르다 ]	최길호	2021/09/29	261
Troubleshoot	ORA-15411 alter diskgroup data2 offline disks in failgroup fg1 / alter diskgroup data2 add failgroup fg1	최길호	2021/09/29	486
Troubleshoot	alter diskgroup data1 add failgroup fg1 DISK '/dev/sdb' name DATA1_0000 / drop disk	최길호	2021/09/28	3969
Install and Config	create diskgroup data1 normal redundancy failgroup fg1 disk	최길호	2021/09/28	310
Troubleshoot	[INS-30525] Insufficient number of failure groups specified for Normal Redundancy level.	최길호	2021/09/28	291
Troubleshoot	PRVG-11095 : The TCP system call "connect" failed with error "113"	최길호	2021/09/28	341
Troubleshoot	ORA-00600: internal error code, arguments: [tsdrv1-Bug#24841100]	최길호	2021/09/25	345
Install and Config	ORA-24247: network access denied by access control list (ACL)	최길호	2021/09/24	314
Troubleshoot	ORA-12805 Parallel Query Server Died	최길호	2021/09/23	369