1 2 Previous Next 16 Replies Latest reply: Apr 14, 2013 6:53 AM by yoonas RSS

    how to restore old backupset.oracel 11g express .

    947771
      Hi,

      (Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production)
      (windows xp)
      i have taken two backups using(start->programs file->oracle database 11g express edition->backup database)
      i want to restore the previous one not the latest one.how can i do it?

      note: when i tried to restore using (start->programs file->oracle database 11g express edition->restore database)
      it restores latest backup set only , then just to expriment i deleted latest backup set and left the old backup set and tried to restore but it failed.

      yours sincerely
        • 1. Re: how to restore old backupset.oracel 11g express .
          Paul M.
          Next time please post XE related questions on Oracle Database Express Edition (XE). Anyway...
          i deleted latest backup set and left the old backup set and tried to restore but it failed.
          which error(s) do you get exactly ?
          • 2. Re: how to restore old backupset.oracel 11g express .
            947771
            following is the message i am getting

            ----------------------------------------------------------------------------------------------------------------

            This operation will shut down and restore the database. Are you sure [Y/N]?y
            Restore in progress...
            The requested service has already been started.

            More help is available by typing NET HELPMSG 2182.


            Recovery Manager: Release 11.2.0.2.0 - Production on Sun Mar 24 21:09:39 2013

            Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

            connected to target database: XE (DBID=2682622342, not open)

            RMAN> set echo on;
            2> startup nomount pfile=C:\DOCUME~1\rog\LOCALS~1\Temp\rman_dummy.ora force;
            3>
            echo set on

            RMAN-00571: ===========================================================
            RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
            RMAN-00571: ===========================================================
            RMAN-03002: failure of startup command at 03/24/2013 21:10:05
            RMAN-04014: startup failed: ORA-03113: end-of-file on communication channel

            Recovery Manager complete.
            ==================== ERROR =============================
            Restore of the database failed.
            RMAN Error - could not startup dummy instance .
            Log file is at .
            ==================== ERROR =============================
            Press any key to continue . . .
            -------------------------------------------------------------------------------------------------------------------------------------------------

            but i am interested in knowing how to restore old backup pieces ?
            suppose i have two .bkp files i to want restore from old one not the new one?

            so give me that procedure.

            yours sincerely

            Edited by: 944768 on Mar 24, 2013 8:45 AM
            • 3. Re: how to restore old backupset.oracel 11g express .
              yoonas
              Hi,
              restore backup from TAG <tag>
              "Overrides the default selection of the most recent backups or file copy available"
              http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta037.htm#i1036865

              or you can temporarily move latest back up to some other location so that rman restores the previous one.

              Regards
              Yoonas
              • 4. Re: how to restore old backupset.oracel 11g express .
                947771
                thank u, i will try

                mean while pls tel me is there any diffrence when we take backup by

                1) using (start->programs file->oracle database 11g express edition->backup database)


                2) using rman

                RMAN> SHUTDOWN IMMEDIATE;
                RMAN> STARTUP FORCE DBA;
                RMAN> SHUTDOWN IMMEDIATE;
                RMAN> STARTUP MOUNT;
                BACKUP DATABASE;
                ALTER DATABASE OPEN;

                ---------------------------------------------
                3)

                while restoring it is not restoring and showing this message.

                RMAN> RESTORE DATABASE FROM TAG 'TAG20121118T213230';

                Starting restore at 25-Mar-13 using channnel ORA_DISK_1

                skipping datafile 1; already restored ot file C:\ORACLE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF
                skipping datafile 2; already restored ot file C:\ORACLE\APP\ORACLE\ORADATA\XE\UNDOTBS.DBF
                .
                .
                .
                .
                .
                .


                restore not done; all files read only,offliine, or already restored Finished restore at 25-Mar-13

                RMAN>


                ----
                i am getting the same message even when i am using RESTORE DATABASE;

                yours sincerely

                Edited by: 944768 on Mar 25, 2013 6:54 AM

                Edited by: 944768 on Mar 25, 2013 9:45 PM
                • 5. Re: how to restore old backupset.oracel 11g express .
                  yoonas
                  >
                  1) using (start->programs file->oracle database 11g express edition->backup database)
                  >

                  Backup database is a script, so you can easily open it and see what oracle is doing.


                  >
                  skipping datafile 1; already restored ot file C:\ORACLE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF
                  >

                  The message is self explanatory i think, it says the file has already been restored.

                  What happens if you open the database?
                  • 6. Re: how to restore old backupset.oracel 11g express .
                    947771
                    Q1) i am a new bie , i am reading the docs, but to answer this question , is both ways of taking the backup are same, is tough for me right now and i also realy do not have time.
                    if there is any difference then pls tel me.


                    Q2) i am getting error while opening database,
                    An error was encountered performing the requested operation:

                    ORA-01033: ORACLE initialization or shutdown in progress
                    01033. 00000 - "ORACLE initialization or shutdown in progress"
                    *Cause:    An attempt was made to log on while Oracle is being started up
                    or shutdown.
                    *Action:   Wait a few minutes. Then retry the operation.
                    Vendor code 1033


                    yours sincerely

                    Edited by: 944768 on Mar 26, 2013 11:06 PM
                    • 7. Re: how to restore old backupset.oracel 11g express .
                      947771
                      you might be thinking correctelly , but if u see the post it says, restore is not done.

                      i want to restore the old backup.

                      so pls tel me if possible.

                      yours sincerely
                      • 8. Re: how to restore old backupset.oracel 11g express .
                        yoonas
                        Do you have dbf files at the C:\ORACLE\APP\ORACLE\ORADATA\XE\ location before you fire resotre database.

                        startup a sqlplus session(assume database is mount state) as sysdba and run
                        SELECT NAME,
                                STATUS,
                               ENABLED
                        FROM   V$DATAFILE;
                        What happens if you run alter database open
                        • 9. Re: how to restore old backupset.oracel 11g express .
                          947771
                          when i was trying to restore ,some thing happend and it started giving ,



                          SQL*Plus: Release 11.2.0.2.0 Production on Fri Mar 29 22:32:06 2013

                          Copyright (c) 1982, 2010, Oracle. All rights reserved.

                          SQL> SELECT NAME,
                          2 STATUS,
                          3 ENABLED
                          4 FROM V$DATAFILE;
                          SP2-0640: Not connected
                          SQL> connect /
                          ERROR:
                          ORA-01033: ORACLE initialization or shutdown in progress
                          Process ID: 0
                          Session ID: 0 Serial number: 0


                          SQL> startup nomount
                          ORA-01031: insufficient privileges
                          SQL>

                          before restoration with from tag every thing was working fine.

                          Edited by: 944768 on Mar 29, 2013 10:05 AM

                          Edited by: 944768 on Mar 29, 2013 10:07 AM
                          • 10. Re: how to restore old backupset.oracel 11g express .
                            yoonas
                            >
                            ORA-01031: insufficient privileges
                            >

                            make sure the user has proper privilege


                            sqlplus / as sysdba
                            startup mount;

                            You can try it on rman also (rman target /)

                            Post last few lines from alert log file(alert_XE.log)
                            • 11. Re: how to restore old backupset.oracel 11g express .
                              947771
                              user has all prevlages , i have already witten that every thing was working fine before restore using from tag.

                              step1) i want to make backup.

                              step2 i want to take that bakup on any other machine(having oracle 11g xe ) or i want to install oracle again on same machine after reinsatllation and make some latest backup then want to
                              restore from old backup.

                              -------------------------------
                              current situation is i have the old backup file having default tag no in it . i want to restore it on newly installed oracle 11g xe r2?


                              pls tel me procedures for above and current situation.

                              yours sincerley

                              Edited by: 944768 on Apr 4, 2013 12:34 AM

                              Edited by: 944768 on Apr 4, 2013 2:07 AM
                              • 12. Re: how to restore old backupset.oracel 11g express .
                                947771
                                hi.


                                i am able to restore old backup if it is not deleted by retencen policy,

                                i have used these comands pls check is it ok.

                                RESTORE DATABASE from tag tag TAG20130324T115722;
                                RECOVER DATABASE;

                                ALTER DATABASE OPEN;


                                q1) is recover database ; command required what is the diffrence betwenn restore and recover.

                                q2) above command is not restoring the old database on other computer but it is restoring it on same computer from where i took the backup with this it should be with in
                                retention policies.

                                yours sincerly

                                Edited by: 944768 on Apr 7, 2013 8:10 AM
                                • 13. Re: how to restore old backupset.oracel 11g express .
                                  yoonas
                                  http://docs.oracle.com/cd/B19306_01/server.102/b14220/backrec.htm#i1006585

                                  As your backup is taken when database is not open recover will not have any effect on your scenario.

                                  You can catalog backup peieces manually using catalog command.
                                  • 14. Re: how to restore old backupset.oracel 11g express .
                                    947771
                                    1)does that mean when retention policy is applied and backup becomes old then they are deleted from control file as well as from file system?

                                    2)so one has to register fist the old backup(from backup of backup) and then try to restore it?

                                    3) i am coping AUTOBACKUP,BACKUPSET as backup set
                                    is ONLINELOG and ARCHIVELOG is required (i have not enabled archiving).


                                    yours sincerely
                                    1 2 Previous Next