Question about rman
in [Oracle]
|
From: scarlosantos on 20 May 2010 13:08 I have a question about a procedure wich I have to do in RMAN. My target database is a instance called MMCEM. My catalog database is a instance called RMAN. I have a auxiliary instance called MMCEM2. I have a cold backup of the instance MMCEM made in the day 12/05/2010 with tag TAG20100512T172640. My problem is I need to restore this cold backup in the auxiliary instance and I do not know how to proceed. RMAN> list backup summary tag TAG20100512T172640; List of Backups =============== Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag ------- -- -- - ----------- --------------- ------- ------- ---------- --- 1075062 B F A SBT_TAPE 12-MAY-10 1 1 NO TAG20100512T172640 1075063 B F A SBT_TAPE 12-MAY-10 1 1 NO TAG20100512T172640 1075064 B F A SBT_TAPE 12-MAY-10 1 1 NO TAG20100512T172640 RMAN> list backup tag 'TAG20100512T172640'; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 1075062 Full 1.53G SBT_TAPE 00:01:18 12-MAY-10 BP Key: 1075067 Status: AVAILABLE Compressed: NO Tag: TAG20100512T172640 Handle: OffSite_MMCEM_718824401_3280 Media: Keep: NOLOGS Until: 11-JUN-10 List of Datafiles in backup set 1075062 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 25348658839 12-MAY-10 +MMCEM/mmcem/datafile/system. 260.714565663 2 Full 25348658839 12-MAY-10 +MMCEM/mmcem/datafile/ undotbs1.261.714565687 6 Full 25348658839 12-MAY-10 +MMCEM/mmcem/datafile/mgmt_ecm_depot_ts. 263.714565749 8 Full 25348658839 12-MAY-10 +MMCEM/mmcem/datafile/garantia_dados. 265.714565799 10 Full 25348658839 12-MAY-10 +MMCEM/mmcem/datafile/garantia_indices. 267.714565849 12 Full 25348658839 12-MAY-10 +MMCEM/mmcem/datafile/extranet_indices. 269.714565899 14 Full 25348658839 12-MAY-10 +MMCEM/mmcem/datafile/extranet_dados. 271.714565959 16 Full 25348658839 12-MAY-10 +MMCEM/mmcem/datafile/pentaho_dados. 273.714566011 17 Full 25348658839 12-MAY-10 +MMCEM/mmcem/datafile/pentaho_indices. 274.714566025 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 1075063 Full 6.50M SBT_TAPE 00:00:03 12-MAY-10 BP Key: 1075068 Status: AVAILABLE Compressed: NO Tag: TAG20100512T172640 Handle: OffSite_MMCEM_718824486_3282 Media: Keep: NOLOGS Until: 11-JUN-10 Control File Included: Ckp SCN: 25348658839 Ckp time: 12-MAY-10 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 1075064 Full 1.54G SBT_TAPE 00:02:23 12-MAY-10 BP Key: 1075069 Status: AVAILABLE Compressed: NO Tag: TAG20100512T172640 Handle: OffSite_MMCEM_718824401_3281 Media: Keep: NOLOGS Until: 11-JUN-10 List of Datafiles in backup set 1075064 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 3 Full 25348658839 12-MAY-10 +MMCEM/mmcem/datafile/sysaux. 262.714565713 4 Full 25348658839 12-MAY-10 +MMCEM/mmcem/datafile/users.275.714566041 5 Full 25348658839 12-MAY-10 +MMCEM/mmcem/datafile/mgmt_tablespace. 259.714565637 7 Full 25348658839 12-MAY-10 +MMCEM/mmcem/datafile/garantia_dados. 264.714565773 9 Full 25348658839 12-MAY-10 +MMCEM/mmcem/datafile/garantia_indices. 266.714565823 11 Full 25348658839 12-MAY-10 +MMCEM/mmcem/datafile/extranet_indices. 268.714565875 13 Full 25348658839 12-MAY-10 +MMCEM/mmcem/datafile/extranet_dados. 270.714565935 15 Full 25348658839 12-MAY-10 +MMCEM/mmcem/datafile/joramonitor_dados. 272.714565985
From: joel garry on 20 May 2010 16:07 On May 20, 10:08 am, scarlosantos <scarlosan...(a)gmail.com> wrote: > I have a question about a procedure wich I have to do in RMAN. > > My target database is a instance called MMCEM. > My catalog database is a instance called RMAN. > I have a auxiliary instance called MMCEM2. > I have a cold backup of the instance MMCEM made in the day 12/05/2010 > with tag TAG20100512T172640. > > My problem is I need to restore this cold backup in the auxiliary > instance and I do not know how to proceed. > Have you looked at the duplicate database examples in the Oracle® Database Backup and Recovery Advanced User's Guide? Note that in RMAN terminology, it is called a consistent backup. You can also just do a plain restore of a consistent backup on a different node, but then you have to watch out that you don't connect it to your catalog, as the DBID will be the same. RMAN duplicate gives a new DBID. You can also change the DBID with the nid utility. There are many ways to do this, part of deciding which is to be explicit about things like how often you intend to do it and what other constraints there are on the requirement. jg -- @home.com is bogus. "If Pearl Jam spelled their name p-e-r-l they would be a lot cooler." - Jay Moore
From: Mark D Powell on 21 May 2010 10:03 On May 20, 4:07 pm, joel garry <joel-ga...(a)home.com> wrote: > On May 20, 10:08 am, scarlosantos <scarlosan...(a)gmail.com> wrote: > > > I have a question about a procedure wich I have to do in RMAN. > > > My target database is a instance called MMCEM. > > My catalog database is a instance called RMAN. > > I have a auxiliary instance called MMCEM2. > > I have a cold backup of the instance MMCEM made in the day 12/05/2010 > > with tag TAG20100512T172640. > > > My problem is I need to restore this cold backup in the auxiliary > > instance and I do not know how to proceed. > > Have you looked at the duplicate database examples in the Oracle® > Database Backup and Recovery Advanced User's Guide? > > Note that in RMAN terminology, it is called a consistent backup. > > You can also just do a plain restore of a consistent backup on a > different node, but then you have to watch out that you don't connect > it to your catalog, as the DBID will be the same. RMAN duplicate > gives a new DBID. You can also change the DBID with the nid utility. > > There are many ways to do this, part of deciding which is to be > explicit about things like how often you intend to do it and what > other constraints there are on the requirement. > > jg > -- > @home.com is bogus. > "If Pearl Jam spelled their name p-e-r-l they would be a lot cooler." > - Jay Moore I think using the rman duplicate database feature as Joel recommended and as documented in the Backup and Recovery manuals is you best choice. The examples are pretty good and demonstrate how to change datafile locations and spfile parameters as part of the duplication. HTH -- Mark D Powell --
|
Pages: 1 Prev: Weird RMAN error Next: How to make DBA_AUDIT_TRAIL’s status to VALID |