Question about rman
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