tag:blogger.com,1999:blog-1939193459916707700.post6844599844664280745..comments2023-06-25T08:29:34.418-07:00Comments on Khurram Siddiqui: Recovered SCNKhurram Siddiquihttp://www.blogger.com/profile/15255478377912582790noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-1939193459916707700.post-42480730098216364462022-03-03T21:56:37.482-08:002022-03-03T21:56:37.482-08:00Best Casino & Hotel Deals in Maricopa, AZ - Ma...Best Casino & Hotel Deals in Maricopa, AZ - Mapyro<br />Save up to 70% with MapYRO® <a href="https://www.mapyro.com/%ec%b0%bd%ec%9b%90%ec%b5%9c%ea%b3%a0%ec%8b%9c%ec%84%a4%ec%b6%9c%ec%9e%a5%eb%a7%88%ec%82%ac%ec%a7%80.html" rel="nofollow">창원 출장샵</a> Resort and Casino® Resort® Hotel Deals <a href="https://www.mapyro.com/%ec%98%81%ec%b2%9c%ec%b5%9c%ea%b3%a0%ec%8b%9c%ec%84%a4%ec%b6%9c%ec%9e%a5%ec%95%88%eb%a7%88.html" rel="nofollow">영천 출장마사지</a> on your <a href="https://www.mapyro.com/%ec%9a%b8%ec%82%b0%ea%b4%91%ec%97%ad%ec%b6%9c%ec%9e%a5%ec%95%88%eb%a7%88%ea%b0%80%ec%9d%b4%eb%93%9c.html" rel="nofollow">울산광역 출장안마</a> trip to <a href="https://www.jtmhub.com/%ec%97%ac%ec%88%98%ec%a3%bc%eb%b3%80-%ea%b0%80%ea%b9%8c%ec%9a%b4%ec%b6%9c%ec%9e%a5%ec%95%88%eb%a7%88.html" rel="nofollow">여수 출장마사지</a> Maricopa, <a href="https://www.mapyro.com/%eb%b6%80%ec%82%b0%ea%b4%91%ec%97%ad%ec%b6%9c%ec%9e%a5%ec%95%88%eb%a7%88%ea%b0%80%ec%9d%b4%eb%93%9c.html" rel="nofollow">부산광역 출장안마</a> AZ.xanthelanevehttps://www.blogger.com/profile/08552153222156785456noreply@blogger.comtag:blogger.com,1999:blog-1939193459916707700.post-15611703655900108302011-12-04T11:25:51.414-08:002011-12-04T11:25:51.414-08:00I am really sorry scofield , i was too sick and go...I am really sorry scofield , i was too sick and got a bed rest , i was not following anything regarding my blog as well oracle's stuff , i am back now and will continue my effort to share all of you about my findings.<br /><br />KhurramKhurram Siddiquihttps://www.blogger.com/profile/15255478377912582790noreply@blogger.comtag:blogger.com,1999:blog-1939193459916707700.post-64517134967019287972009-12-04T23:47:19.098-08:002009-12-04T23:47:19.098-08:00Dear Khurram;
First of all, I would like to thank ...Dear Khurram;<br />First of all, I would like to thank you for helping me with my rman questions.<br />To be honest, I really learned a lot from you.<br /><br />I have one more question, that I`ve been thinking for the last couple of days.<br />I really appreciate if you clear my doubts.<br /><br /><br />I have a production database(orcl) and a copy of production database(orcl2) which is refreshed every night.<br />Everyday we take hot backup with (alter tablespace begin backup) and perform flash copy of the<br />datafiles to orcl2 and open resetlogs.<br /><br />Yesterday, this operation failed and I even couldnt manage to open orcl2.<br />The thing is even the flash copy failed, I couldnt even open the database normally.(old version)<br /><br />When I try to recover with latest controlfile it just says:<br /><br />SQL> recover database using backup controlfile;<br />ORA-00283: recovery session canceled due to errors<br />ORA-01190: controlfile or data file 1 is from before the last RESETLOGS<br />ORA-01110: data file 1: '...'<br /> <br /><br /><br />When I recreate the controlfile from controltrace, and perform recovery in the alertlog it says:<br /><br />WARNING! Recovering data file ... from a fuzzy file. If not the current file<br />it might be an online backup taken without entering the begin backup command<br /><br />Also it is requesting archivelog sequence _0000000010_1.arc which was generated in April?<br />However my current log seq is _0000019202_1.arc<br />I dont understand why it requests very very very old archivelog... It doesnt make sense<br /><br /><br /><br />When I check datafile headers:<br /><br />I see:<br /><br />ERROR FUZ<br />----------------------------------------------------------------- ---<br />WRONG RESETLOGS YES<br /><br /><br />SQL> select CHECKPOINT_CHANGE# from v$datafile where rownum<3;<br /> <br />CHECKPOINT_CHANGE#<br />------------------<br /> 4446922742<br /> 4446922742<br /> <br />SQL> select CHECKPOINT_CHANGE# from v$datafile_header where rownum<3;<br /> <br />CHECKPOINT_CHANGE#<br />------------------<br /> 4443857329<br /> 4443857329<br /> <br /><br /><br /><br />and in orcl<br /><br />SQL> select RESETLOGS_CHANGE# from v$datafile_header where rownum<2;<br /><br />RESETLOGS_CHANGE#<br />-----------------<br /> 3250834775<br /><br />Flash copy one:<br /><br />SQL> select RESETLOGS_CHANGE# from v$datafile_header where rownum<2;<br /><br />RESETLOGS_CHANGE#<br />-----------------<br /> 4443659941<br /><br /><br /><br />I think this shows that flash copy didnt happen, but why I cant open the database?<br />As I showed you above, I have also trace to recreate controlfile from traceScofieldnoreply@blogger.com