Home » RDBMS Server » Backup & Recovery » Restore from backup
Restore from backup [message #440404] Sat, 23 January 2010 20:36 Go to next message
mzarM
Messages: 8
Registered: August 2009
Junior Member
Hi,

I want to restore from my backup. I've customize my backup. How to restore from those backup below:
BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
913     112.07M    DISK        00:00:22     10-JAN-10
        BP Key: 913   Status: AVAILABLE  Compressed: YES  Tag: FULL_ARCHIVE
        Piece Name: /rman_backup/MISSION/MISSION_FULL<_922-20100110-1>.arc

  List of Archived Logs in backup set 913
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    4867    275610353  09-JAN-10 275778277  10-JAN-10
  1    4868    275778277  10-JAN-10 275930808  10-JAN-10
  1    4869    275930808  10-JAN-10 275986058  10-JAN-10
  2    4355    275610367  09-JAN-10 275663590  09-JAN-10
  2    4356    275663590  09-JAN-10 275785827  10-JAN-10
  2    4357    275785827  10-JAN-10 275908149  10-JAN-10
  2    4358    275908149  10-JAN-10 275986065  10-JAN-10

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
914     Full    45.02M     DISK        00:00:05     10-JAN-10
        BP Key: 914   Status: AVAILABLE  Compressed: NO  Tag: TAG20100110T180038
        Piece Name: /rman_backup/MISSION/controlfile/c-1356438078-20100110-00
  Control File Included: Ckp SCN: 275986163    Ckp time: 10-JAN-10
  SPFILE Included: Modification time: 09-JAN-10

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
915     Full    19.94G     DISK        01:18:17     10-JAN-10
        BP Key: 915   Status: AVAILABLE  Compressed: YES  Tag: FULL_DATAFILES
        Piece Name: /rman_backup/MISSION/MISSION_FULL<_924-20100110-1>.dbf
  List of Datafiles in backup set 915
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 275986216  10-JAN-10 +DATA/mission/datafile/system.291.670600517
  2       Full 275986216  10-JAN-10 +DATA/mission/datafile/undotbs1.268.670600525
  3       Full 275986216  10-JAN-10 +DATA/mission/datafile/sysaux.269.670600527
  4       Full 275986216  10-JAN-10 +DATA/mission/datafile/undotbs2.271.670600531
  5       Full 275986216  10-JAN-10 +DATA/mission/datafile/users.272.670600533
  6       Full 275986216  10-JAN-10 +DATA/mission/datafile/portal.258.670603797
  7       Full 275986216  10-JAN-10 +DATA/mission/datafile/portal_doc.265.670603801
  8       Full 275986216  10-JAN-10 +DATA/mission/datafile/portal_idx.266.670603803
  9       Full 275986216  10-JAN-10 +DATA/mission/datafile/portal_log.259.670603805
  10      Full 275986216  10-JAN-10 +DATA/mission/datafile/ias_meta.260.670603809
  11      Full 275986216  10-JAN-10 +DATA/mission/datafile/disco_ptm5_meta.261.670603813
  12      Full 275986216  10-JAN-10 +DATA/mission/datafile/disco_ptm5_cache.263.670603815
  13      Full 275986216  10-JAN-10 +DATA/mission/datafile/dcm.264.670603821
  14      Full 275986216  10-JAN-10 +DATA/mission/datafile/dsgateway_tab.290.670603823
  15      Full 275986216  10-JAN-10 +DATA/mission/datafile/wcrsys_ts.289.670603825
  16      Full 275986216  10-JAN-10 +DATA/mission/datafile/b2b_rt.288.670603827
  17      Full 275986216  10-JAN-10 +DATA/mission/datafile/b2b_dt.287.670603831
  18      Full 275986216  10-JAN-10 +DATA/mission/datafile/b2b_idx.286.670603833
  19      Full 275986216  10-JAN-10 +DATA/mission/datafile/b2b_lob.285.670603835
  20      Full 275986216  10-JAN-10 +DATA/mission/datafile/orabpel.284.670603837
  21      Full 275986216  10-JAN-10 +DATA/mission/datafile/bam.283.670603841
  22      Full 275986216  10-JAN-10 +DATA/mission/datafile/ocats.282.670603843
  23      Full 275986216  10-JAN-10 +DATA/mission/datafile/uddisys_ts.281.670603847
  24      Full 275986216  10-JAN-10 +DATA/mission/datafile/olts_attrstore.280.670603849
  25      Full 275986216  10-JAN-10 +DATA/mission/datafile/olts_battrstore.279.670603851
  26      Full 275986216  10-JAN-10 +DATA/mission/datafile/olts_ct_store.278.670603853
  27      Full 275986216  10-JAN-10 +DATA/mission/datafile/olts_default.277.670603855
  28      Full 275986216  10-JAN-10 +DATA/mission/datafile/olts_svrmgstore.276.670603857
  29      Full 275986216  10-JAN-10 +DATA/mission/datafile/ucm.257.672063969
  30      Full 275986216  10-JAN-10 +DATA/mission/datafile/bi01.dbf
  31      Full 275986216  10-JAN-10 +DATA/mission/datafile/cns.293.672164285
  32      Full 275986216  10-JAN-10 +DATA/mission/datafile/jive.294.675350843
  33      Full 275986216  10-JAN-10 +DATA/mission/datafile/prefstore.295.678027425
  34      Full 275986216  10-JAN-10 +DATA/mission/datafile/bi_test.296.679068461
  35      Full 275986216  10-JAN-10 +DATA/mission/datafile/jive1.297.679152567
  36      Full 275986216  10-JAN-10 +DATA/mission/datafile/jive2.298.679152655
  37      Full 275986216  10-JAN-10 +DATA/mission/datafile/jive3.299.679152787
  38      Full 275986216  10-JAN-10 +DATA/mission/datafile/jive4.300.679152819
  39      Full 275986216  10-JAN-10 +DATA/mission/datafile/jive5.301.679152869
  40      Full 275986216  10-JAN-10 +DATA/mission/datafile/missiontest.302.685010997
  41      Full 275986216  10-JAN-10 +DATA/mission/datafile/portal.386.692729235
  42      Full 275986216  10-JAN-10 +DATA/mission/datafile/portal_doc.390.692794953
  43      Full 275986216  10-JAN-10 +DATA/mission/datafile/sysaux.391.692795017
  44      Full 275986216  10-JAN-10 +DATA/mission/datafile/databank.406.697119995

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
916     Full    45.02M     DISK        00:00:04     10-JAN-10
        BP Key: 916   Status: AVAILABLE  Compressed: NO  Tag: TAG20100110T191918
        Piece Name: /rman_backup/MISSION/controlfile/c-1356438078-20100110-01
  Control File Included: Ckp SCN: 276006646    Ckp time: 10-JAN-10
  SPFILE Included: Modification time: 09-JAN-10

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
917     Full    1.53M      DISK        00:00:03     10-JAN-10
        BP Key: 917   Status: AVAILABLE  Compressed: YES  Tag: FULL_CONTROLFILE
        Piece Name: /rman_backup/MISSION/MISSION_FULL<_926-20100110-1>.ctrl
  Control File Included: Ckp SCN: 276006698    Ckp time: 10-JAN-10

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
918     Full    45.02M     DISK        00:00:04     10-JAN-10
        BP Key: 918   Status: AVAILABLE  Compressed: NO  Tag: TAG20100110T191935
        Piece Name: /rman_backup/MISSION/controlfile/c-1356438078-20100110-02
  Control File Included: Ckp SCN: 276006708    Ckp time: 10-JAN-10
  SPFILE Included: Modification time: 09-JAN-10

I want to restore from BS key 913,914 and 915.
Please assist me. Thank you.

[Updated on: Sat, 23 January 2010 20:39]

Report message to a moderator

Re: Restore from backup [message #440414 is a reply to message #440404] Sun, 24 January 2010 01:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use SET UNTIL to set time just after backup 915.

Regards
Michel
Re: Restore from backup [message #441181 is a reply to message #440404] Fri, 29 January 2010 04:39 Go to previous message
entekeralam
Messages: 19
Registered: January 2010
Junior Member
Is it hot backup or cold backup? List backup above does not show any of the archive log after the backup.

If it is hot backup and l

RMAN > list backup of archivelog all;

Check the last archive sequence for all redo threads and select the archive sequence having LEAST "Next SCN" among them.

- Having determined the point upto which media recovery should run, start the restore/recovery using:

RMAN> run {
set until sequence < sequence# from above> thread < thread# >;
restore database;
recover database;
}

SQL> alter database open resetlogs;


If all the archive log files after backup is available and you want full recovery..

RMAN> run {
restore database;
recover database;
}

[Updated on: Fri, 29 January 2010 05:17] by Moderator

Report message to a moderator

Previous Topic: recover a single table from backup
Next Topic: Restoring Rman backup on test db in same network
Goto Forum:
  


Current Time: Thu Mar 28 13:19:33 CDT 2024