http://iotn.co.kr ¿¬¶ôó: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / ìíÜâïÙݤªÏìíÜâÏÚªÎàõîÜÒ¿ÖË?ßåíºªËÞóñªª¹ªÙª. ]
-- ¿øÀÎ : 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;