1 2 Previous Next 28 Replies Latest reply: Apr 9, 2013 12:15 AM by Hemant K Chitale Go to original post RSS
      • 15. Re: Tablespace Point in Time Recovery fails with RMAN-06026:
        1001066
        Hi Hemanth,

        "To make it aware of the snapshot as datafile backups, you have to *CATALOG the datafiles into the controlfile*."
        How??
        Could you please tell me how to catalog the datafile backups into the controlfile?

        Thanks and Regards,
        Pranam
        • 16. Re: Tablespace Point in Time Recovery fails with RMAN-06026:
          1001066
          Hi Hemanth,

          "To make it aware of the snapshot as datafile backups, you have to *CATALOG the datafiles into the controlfile*."
          How??
          Could you please tell me how to catalog the datafile backups into the controlfile?

          Thanks and Regards,
          Pranam
          • 17. Re: Tablespace Point in Time Recovery fails with RMAN-06026:
            Hemant K Chitale
            CATALOG START WITH 'location'


            as you've done before.


            Hemant K Chitale
            • 18. Re: Tablespace Point in Time Recovery fails with RMAN-06026:
              1001066
              Hi Hemanth,

              "To make it aware of the snapshot as datafile backups, you have to *CATALOG the datafiles into the controlfile*."
              How??
              Could you please tell me **how to catalog the datafile backups into the controlfile**?

              Thanks and Regards,
              Pranam
              • 19. Re: Tablespace Point in Time Recovery fails with RMAN-06026:
                1001066
                Hi Hemanth,

                CATALOG START WITH 'location'

                location is location of controlfile or datafile?

                Because before recovering I catalog the snapshot datafiles using
                CATALOG START WITH "+TBL_DG_DATA/ORCL/DATAFILE/" NOPROMPT;

                and after this how will the controlfile become aware?

                Regards,
                Pranam
                • 20. Re: Tablespace Point in Time Recovery fails with RMAN-06026:
                  Hemant K Chitale
                  You CATALOG the datafiles to update the controlfile.

                  CATALOG START WITH 'location_of_datafile_snapshot_folder'


                  Hemant K Chitale
                  • 21. Re: Tablespace Point in Time Recovery fails with RMAN-06026:
                    1001066
                    Hi Hemanth,

                    These were the steps performed.

                    alter system archive log current;
                    ALTER DATABASE BEGIN BACKUP;
                    Backup(Snapshot) involving datafiles and archivelogs
                    alter database backup controlfile to '/tmp/auxpran/controlfile.ctl';
                    CATALOG START WITH "+SNAP_DATA/ORCL/DATAFILE/" NOPROMPT; ------------------------snapshot datafile folder
                    catalog start with "+DG_ARCH/ORCL/ARCHIVELOG/" NOPROMPT;------------------------------database archive logs folder

                    SQL 'ALTER TABLESPACE TSPC OFFLINE IMMEDIATE';

                    RECOVER TABLESPACE TSPC UNTIL TIME "to_date('04-apr-2013 02:56:00','dd-mon-yyyy hh24:mi:ss')" AUXILIARY DESTINATION '/tmp/auxpran'; -------- Time after the snapshot was taken.

                    Inside the memory script of auxiliary instance of RMAN

                    channel ORA_AUX_DISK_1: restoring control file
                    channel ORA_AUX_DISK_1: copied control file copy
                    input file name=/tmp/auxpran/controlfile.ctl
                    output file name=/tmp/auxpran/ORCL/controlfile/o1_mf_8os9y71s_.ctl
                    Finished restore at 04-APR-13

                    After this it failed with the following error.

                    RMAN-06026: some targets not found - aborting restore
                    RMAN-06023: no backup or copy of datafile 5 found to restore
                    RMAN-06023: no backup or copy of datafile 2 found to restore
                    RMAN-06023: no backup or copy of datafile 3 found to restore
                    RMAN-06023: no backup or copy of datafile 1 found to restore

                    Regards,
                    Pranam

                    Edited by: 998063 on Apr 8, 2013 12:28 AM
                    • 22. Re: Tablespace Point in Time Recovery fails with RMAN-06026:
                      Hemant K Chitale
                      Where did you run the CATALOG ? It seems as if you ran the CATALOG against the production controlfile not the backup controlfile which was created before the CATALOG. Oracle restored the backup controlfile which hadn't been updated with the CATALOG.




                      You could run the controlfile backup after the CATALOG so that the backup is updated --- but that presupposes that the snapshot path is the same on the primary and auxiliary servers. To avoid ambiguity, I have earlier suggested running CATALOG on the auximilary instance. You can STARTUP MOUNT with the backup that had been created from the primary instance, CATALOG START WITH all the snapshottted datafiles and Archivelogs, SHUTDOWN and then let the TSPITR use this updated controlfile backup as the backup source.




                      Hemant K Chitale

                      Edited by: Hemant K Chitale on Apr 8, 2013 3:45 PM
                      • 23. Re: Tablespace Point in Time Recovery fails with RMAN-06026:
                        1001066
                        Thanks a lot Hemanth!!!!

                        When I generated the controlfile after cataloging it succeeded the first time itself.
                        Please consider the case below :

                        create snapshot at time 08-apr-2013 3:07:45

                        make some changes to the tablespace at time 08-apr-2013 04:35:54

                        perform recovery.

                        catalog the backup datafiles.

                        alter database backup controlfile to '/tmp/ctrl.ctl';

                        Now for performing recovery if i give a time between the snapshot and changes to tablespace, say 08-apr-2013 03:45:00,

                        It takes controlfile before the specified time i.e.,before 08-apr-2013 03:45:00

                        whereas the alter database backup controlfile to '/tmp/ctrl.ctl'; command generates to controlfile wil have the recent timestamp. So the recovery fails with no backup controlfile found error.

                        Is there a way to specify the controlfile in auxiliary instance in case of RMAN automated auxiliary instance i.e., while using the 'auxiliary destination' clause?

                        Ex : RECOVER TABLESPACE TSPC UNTIL TIME "to_date('03-apr-2013 02:18:00','dd-mon-yyyy hh24:mi:ss')" AUXILIARY DESTINATION '/tmp/auxpran';

                        Here in memory script of RMAN it directly restores the controlfile from auxiliary destination taking into regard the time given in the recover command.

                        i.e.,

                        contents of Memory Script:
                        *{*
                        *# set requested point in time*
                        set until  time "to_date('03-apr-2013 02:18:00','dd-mon-yyyy hh24:mi:ss')";
                        *# restore the controlfile*
                        restore clone controlfile;
                        *# mount the controlfile*
                        sql clone 'alter database mount clone database';
                        # archive current online log
                        sql 'alter system archive log current';
                        # avoid unnecessary autobackups for structural changes during TSPITR
                        sql 'begin dbms_backup_restore.AutoBackupFlag(FALSE); end;';
                        }
                        executing Memory Script

                        executing command: SET until clause

                        Starting restore at 03-APR-13
                        allocated channel: ORA_AUX_DISK_1
                        channel ORA_AUX_DISK_1: SID=19 device type=DISK

                        channel ORA_AUX_DISK_1: restoring control file
                        channel ORA_AUX_DISK_1: copied control file copy
                        input file name=/tmp/auxpran/controlbc.ctl
                        output file name=/tmp/auxpran/ORCL/controlfile/o1_mf_8opkv8v4_.ctl
                        Finished restore at 03-APR-13

                        Regards,
                        Pranam
                        • 24. Re: Tablespace Point in Time Recovery fails with RMAN-06026:
                          Hemant K Chitale
                          Don't delay the CATALOG and BACKUP CONTROLFILE.

                          Immediately after creating the Snapshot, run CATALOG START WITH and ALTER DATABASE BACKUP CONTROLFILE.

                          Thus, if your snapshot is at 3:07:45, you run CATALOG and BACKUP CONTROLFILE commands by 03:08:15 (or as many seconds is it takes to run these commands).
                          Therefore, when you specify an UNTIL TIME of 03:45:00, it will take the 03:08:15 backup.


                          Hemant K Chitale
                          • 25. Re: Tablespace Point in Time Recovery fails with RMAN-06026:
                            1001066
                            Hi Hemanth,

                            Is there any way to specify the controlfile of auxiliary instance in case of RMAN automated auxiliary instance i.e., while using the auxiliary destination clause?
                            So that I can use snapshots(backups) of any time and after cataloging them generate the controlfile and give a point in time for recovery and correspondingly give the controlfile which contains the information of the backups!!!
                            Or in any of the 3 cases of RMAN tablespace point in time recovery(TSPITR)?

                            Thanks and Regards,
                            Pranam
                            • 26. Re: Tablespace Point in Time Recovery fails with RMAN-06026:
                              Hemant K Chitale
                              The specification of the controlfile is "assumed" based on the UNTIL TIME that you specify. Oracle picks the closest controlfile to that time.
                              You could manually juggle the actual controlfile backups and make the wrong one unavailable (e.g. by removing or renaming it).

                              Hemant K Chitale
                              • 27. Re: Tablespace Point in Time Recovery fails with RMAN-06026:
                                1001066
                                Hi Hemanth,

                                Is there any way,option to specify a specific controlfile to the auxiliary instance?
                                I mean can we tell the auxiliary instance to pick up a specified controlfile regardless of time?

                                Thanks and Regards,
                                Pranam
                                1 2 Previous Next