This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Apr 14, 2013 4:53 AM by yoonas RSS

how to restore old backupset.oracel 11g express .

947771 Newbie
Currently Being Moderated
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. Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    >
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    >
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points