Question about rman

From: scarlosantos <scarlosantos_at_gmail.com>
Date: Thu, 20 May 2010 10:08:01 -0700 (PDT)
Message-ID: <101890fe-933e-4132-9f01-3c654fac77e9_at_l6g2000vbo.googlegroups.com>



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 Received on Thu May 20 2010 - 12:08:01 CDT

Original text of this message