ORACLE

[ 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]
		기타정보 [194]
		운영체제 [634]

04.Q/A Book

Q/A [53]

05.방명록

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

기념일

LINK

+ 가족 Hompy
+ DNSEver

IOTN :: Field Book :: ORACLE

회원가입

ORA-19909: datafile 1 belongs to an orphan incarnation

최길호 [LIST]

2021-09-17 20:19:02, 조회 : 786

-- 원인 : 1차 test resetlog archivelog를 catalog에 넣어서 발생

RMAN> catalog start with '/backup/arch/'; 



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

ORA-00283: recovery session canceled due to errors

ORA-19909: datafile 1 belongs to an orphan incarnation

ORA-01110: data file 1: '/backup/oradata/db10g/system.001.dbf'



ALTER DATABASE RECOVER  database using backup controlfile until cancel

Media Recovery Start

Warning: Recovery target destination is in a sibling branch

of the controlfile checkpoint. Recovery will only recover

changes to datafiles.

Datafile 1 (ckpscn 16687906561110) is orphaned on incarnation#=4

Fri Sep 17 19:23:16 KST 2021

Media Recovery failed with error 19909

ORA-283 signalled during: ALTER DATABASE RECOVER  database using backup controlfile until cancel  ...



조치

controlfile restore / recover database using backup controlfile until cancel;

216.73.216.248

LIST

	제목	작성자	작성일	조회
Admin	KO16MSWIN949 to AL32UTF8 CLOB exp/imp 한글 TEST	최길호	2024/06/30	131
Admin	IMP-00017: following statement failed with ORACLE error 2304:	최길호	2024/06/28	132
Admin	dba_audit_trail = sys.aud$ dba_fga_audit_trail = sys.fga_log$ delete where sysdate -(365*5)	최길호	2024/06/27	107
Oracle GoldenGate	OGG-00423 OGG-03533	최길호	2024/06/26	86
Oracle GoldenGate	logdump filter / x ls / count log	최길호	2024/06/26	102
Admin	sys_guid json_object json_array / indextype is ctxsys.context	최길호	2024/06/25	164
Admin	recover copy of database / change copy of database uncatalog; / list copy	최길호	2024/06/22	104
Admin	create blockchain table / 19.10 이상 부터 가능 / ORA-05715	최길호	2024/06/21	151
Admin	create proxy users	최길호	2024/06/21	97
Admin	remote_os_authent=true / create user ops$oracle identified externally ;	최길호	2024/06/21	113
Oracle GoldenGate	logdump reclen env sfet sfnt count filter save	최길호	2024/06/20	67
Oracle GoldenGate	OGG-15161	최길호	2024/06/20	127
Backup and Recovery	RMAN-06053: unable to perform media recovery because of missing log	최길호	2024/06/15	69
Oracle GoldenGate	Replicate data using Oracle Cloud Infrastructure GoldenGate [ Memo ]	최길호	2024/06/12	104
Pro*C	proc test.pc Syntax error at line 185, column 45, file /usr/include/sys/cdefs.h	최길호	2024/06/10	95
Oracle GoldenGate	Oracle GoldenGate matrix and lastest patch	최길호	2024/06/10	87
Backup and Recovery	ORA-01207	최길호	2024/06/10	72
Install and Config	Linux 9 Oracle 10.2 [ 설치 불가 / 퍼와서 운영 가능 / 장애시 책임 없지만 보통 잘된다. ]	최길호	2024/06/07	80