1 2 3 Previous Next 38 Replies Latest reply: Apr 30, 2013 9:50 AM by John Stegeman Go to original post RSS
      • 30. Re: RESTORE DATABASE OR RECOVER DATABASE
        Justin_Mungal
        sybrand_b wrote:
        https://forums.oracle.com/forums/ann.jspa?annID=718

        Especially the first point.

        From now on I will completely ignore you.
        I recommend all others to do that too, starting immediately,

        ------------
        Sybrand Bakker
        Senior Oracle DBA
        I hate to say it, but I will do the same. It's for the OP's own good.
        • 31. Re: RESTORE DATABASE OR RECOVER DATABASE
          yxes2013
          Thanks :)
          • 32. Re: RESTORE DATABASE OR RECOVER DATABASE
            John Stegeman
            If you can't read the documentation, I sure hope that the certification exam exposes the level of knowledge that you have obtained....

            Ignoring your questions too, except to say, "read the d%%n manual"
            • 33. Re: RESTORE DATABASE OR RECOVER DATABASE
              EdStevens
              Fran wrote:
              restore controlfile --> database nomount
              restore database --> database mount
              recover database --> database mount
              when all will be restore/Recover --> alter database open resetlogs;

              you can't restore/recover something that is not there. How you can repair a car if you haven't car? (based in sb theory,I hope he is not offended)

              Edited by: Fran on 30-abr-2013 1:51
              Fran .. I know you want to be helpful, but I'm afraid you are just feeding a troll. Please reconsider.
              • 34. Re: RESTORE DATABASE OR RECOVER DATABASE
                EdStevens
                Mahir - I know you want to be helpful, but I'm afraid you are just feeding a troll. Please take a look at his posting history and consider ...
                • 35. Re: RESTORE DATABASE OR RECOVER DATABASE
                  yxes2013
                  Hi all,

                  Is this documented? I resolved my issue by running recover database "many times" or i am the first one to discover it? :)
                  RMAN> recover database;
                  
                  Starting recover at 30-APR-13
                  using channel ORA_DISK_1
                  
                  starting media recovery
                  
                  archive log thread 1 sequence 776 is already on disk as file /u01/app/oracle/flash_recovery_area/TEST1/archivelog/2013_04_30/o1_mf_1_776_8qyw734q_.arc
                  archive log thread 1 sequence 777 is already on disk as file /u01/app/oracle/flash_recovery_area/TEST1/archivelog/2013_04_30/o1_mf_1_777_8qyw73fy_.arc
                  archive log thread 1 sequence 778 is already on disk as file /u01/app/oracle/flash_recovery_area/TEST1/onlinelog/redo_1_1.log
                  archive log filename=/u01/app/oracle/flash_recovery_area/TEST1/archivelog/2013_04_30/o1_mf_1_776_8qyw734q_.arc thread=1 sequence=776
                  archive log filename=/u01/app/oracle/flash_recovery_area/TEST1/archivelog/2013_04_30/o1_mf_1_777_8qyw73fy_.arc thread=1 sequence=777
                  archive log filename=/u01/app/oracle/flash_recovery_area/TEST1/onlinelog/redo_1_1.log thread=1 sequence=778
                  media recovery complete, elapsed time: 00:00:04
                  Finished recover at 30-APR-13
                  
                  RMAN> recover database;
                  
                  Starting recover at 30-APR-13
                  using channel ORA_DISK_1
                  
                  starting media recovery
                  
                  archive log thread 1 sequence 778 is already on disk as file /u01/app/oracle/flash_recovery_area/TEST1/onlinelog/redo_1_1.log
                  archive log filename=/u01/app/oracle/flash_recovery_area/TEST1/onlinelog/redo_1_1.log thread=1 sequence=778
                  media recovery complete, elapsed time: 00:00:01
                  Finished recover at 30-APR-13
                  
                  RMAN> recover database;
                  
                  Starting recover at 30-APR-13
                  using channel ORA_DISK_1
                  
                  starting media recovery
                  
                  archive log thread 1 sequence 778 is already on disk as file /u01/app/oracle/flash_recovery_area/TEST1/onlinelog/redo_1_1.log
                  archive log filename=/u01/app/oracle/flash_recovery_area/TEST1/onlinelog/redo_1_1.log thread=1 sequence=778
                  media recovery complete, elapsed time: 00:00:00
                  Finished recover at 30-APR-13
                  
                  RMAN> alter database open resetlogs;
                  
                  database opened
                  
                  RMAN>
                  How can you explain that?

                  Thanks
                  • 36. Re: RESTORE DATABASE OR RECOVER DATABASE
                    John Stegeman
                    How can you explain that?
                    Well, billions of years ago, the earth was a molten mass...

                    post hoc ergo propter hoc
                    • 37. Re: RESTORE DATABASE OR RECOVER DATABASE
                      yxes2013
                      Hi Johnny & Fran

                      If i use what Fran has suggested:

                      recover until scn XXXXX;
                      recover until time TO_DATE('30/04/2013','MM/DD/YYYY');
                      recover until sequence XXXXX;

                      Would I be replacing infinite trial and error values? before I hit the right one :(
                      • 38. Re: RESTORE DATABASE OR RECOVER DATABASE
                        John Stegeman
                        Who is "Johnny?"
                        Would I be replacing infinite trial and error values? before I hit the right one
                        I don't know, would you?
                        1 2 3 Previous Next