backup backupset completed between [message #547560] |
Wed, 14 March 2012 13:12 |
|
BeefStu
Messages: 208 Registered: October 2011
|
Senior Member |
|
|
I am migrating my DB to ASM and have setup an FRA area to hold my backups. Once I backup to FRA, I want to copy that data to TAPE. In order to keep my example, simple I am backing up to FS for now.
my code to backup from FRA area to FS.
rman <<EOF
connect target /
connect catalog rman/rman08
run
{
allocate channel c1 type disk FORMAT '/vzwhome/oracle/log/paul_test/%U';
allocate channel c2 type disk FORMAT '/vzwhome/oracle/log/paul_test/%U';
allocate channel c3 type disk FORMAT '/vzwhome/oracle/log/paul_test/%U';
backup backupset completed between "TO_DATE('14-MAR-2012 10:31:39', 'DD-MON-YYYY
HH24:MI:SS')" AND "TO_DATE('14-MAR-2012 10:32:58', 'DD-MON-YYYY HH24:MI:SS')";
release channel c1;
release channel c2;
release channel c3;
}
EOF
Output of list backup
RMAN>
List of Backup Sets
===================
BS Key Type LV Size
------- ---- -- ----------
2282 Full 641.00M
List of Datafiles in backup set 2282
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 Full 2770958 03-14-2012 10:31:46 +DATA/vsccst1/datafile/system.257.776442365
3 Full 2770958 03-14-2012 10:31:46 +DATA/vsccst1/datafile/undotbs1.260.776442365
4 Full 2770958 03-14-2012 10:31:46 +DATA/vsccst1/datafile/users.261.776442365
7 Full 2770958 03-14-2012 10:31:46 +DATA/vsccst1/datafile/vscc_idx01.271.777215867
Backup Set Copy #1 of backup set 2282
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ ------------------- ---------- ---
DISK 00:00:11 03-14-2012 10:31:57 NO TAG_1203141031
List of Backup Pieces for backup set 2282 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
2284 1 AVAILABLE +FRA/vsccst1/backupset/2012_03_14/nnndf0_tag_1203141031_0.306.777897107
Backup Set Copy #2 of backup set 2282
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ ------------------- ---------- ---
DISK 00:00:11 03-14-2012 10:48:30 NO TAG_1203141031
List of Backup Pieces for backup set 2282 Copy #2
BP Key Pc# Status Piece Name
------- --- ----------- ----------
2452 1 AVAILABLE /vzwhome/oracle/log/test/2gn5rh4i_1_2
BS Key Type LV Size
------- ---- -- ----------
2283 Full 652.24M
List of Datafiles in backup set 2283
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
2 Full 2770971 03-14-2012 10:32:01 +DATA/vsccst1/datafile/sysaux.256.776442365
5 Full 2770971 03-14-2012 10:32:01 +DATA/vsccst1/datafile/tools.269.776493019
6 Full 2770971 03-14-2012 10:32:01 +DATA/vsccst1/datafile/vscc_data01.270.777215855
Backup Set Copy #1 of backup set 2283
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ ------------------- ---------- ---
DISK 00:00:07 03-14-2012 10:32:08 NO TAG_1203141031
List of Backup Pieces for backup set 2283 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
2285 1 AVAILABLE +FRA/vsccst1/backupset/2012_03_14/nnndf0_tag_1203141031_0.303.777897123
Backup Set Copy #2 of backup set 2283
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ ------------------- ---------- ---
DISK 00:00:07 03-14-2012 10:48:30 NO TAG_1203141031
List of Backup Pieces for backup set 2283 Copy #2
BP Key Pc# Status Piece Name
------- --- ----------- ----------
2453 1 AVAILABLE /vzwhome/oracle/log/test/2hn5rh51_1_2
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
2300 Full 14.95M DISK 00:00:01 03-14-2012 10:32:14
BP Key: 2304 Status: AVAILABLE Compressed: NO Tag: TAG20120314T103213
Piece Name: +FRA/vsccst1/autobackup/2012_03_14/s_777897133.304.777897135
SPFILE Included: Modification time: 03-13-2012 22:03:06
SPFILE db_unique_name: VSCCST1
Control File Included: Ckp SCN: 2771057 Ckp time: 03-14-2012 10:32:13
BS Key Size
------- ----------
2352 19.63M
List of Archived Logs in backup set 2352
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 145 2761718 03-14-2012 08:38:47 2770910 03-14-2012 10:31:33
1 146 2770910 03-14-2012 10:31:33 2771152 03-14-2012 10:32:36
1 147 2771152 03-14-2012 10:32:36 2771180 03-14-2012 10:32:40
Backup Set Copy #1 of backup set 2352
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ ------------------- ---------- ---
DISK 00:00:01 03-14-2012 10:32:52 NO TAG20120314T103247
List of Backup Pieces for backup set 2352 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
2355 1 AVAILABLE +FRA/vsccst1/backupset/2012_03_14/annnf0_tag20120314t103247_0.313.777897171
Backup Set Copy #2 of backup set 2352
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ ------------------- ---------- ---
DISK 00:00:01 03-14-2012 10:48:15 NO TAG20120314T103247
List of Backup Pieces for backup set 2352 Copy #2
BP Key Pc# Status Piece Name
------- --- ----------- ----------
2451 1 AVAILABLE /vzwhome/oracle/log/test/2jn5rh6j_1_2
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
2369 Full 14.95M DISK 00:00:01 03-14-2012 10:32:58
BP Key: 2373 Status: AVAILABLE Compressed: NO Tag: TAG20120314T103257
Piece Name: +FRA/vsccst1/autobackup/2012_03_14/s_777897177.302.777897177
SPFILE Included: Modification time: 03-13-2012 22:03:06
SPFILE db_unique_name: VSCCST1
Control File Included: Ckp SCN: 2771255 Ckp time: 03-14-2012 10:32:57
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
2458 Full 14.95M DISK 00:00:01 03-14-2012 10:48:45
BP Key: 2462 Status: AVAILABLE Compressed: NO Tag: TAG20120314T104844
Piece Name: +FRA/vsccst1/autobackup/2012_03_14/s_777898124.310.777898125
SPFILE Included: Modification time: 03-13-2012 22:03:06
SPFILE db_unique_name: VSCCST1
Control File Included: Ckp SCN: 2773952 Ckp time: 03-14-2012 10:48:44
RMAN> exit;
For example If I look at BS KEY 2882 I beleive this says
it backed up files:
+DATA/vsccst1/datafile/system.257.776442365
+DATA/vsccst1/datafile/undotbs1.260.776442365
+DATA/vsccst1/datafile/users.261.776442365
+DATA/vsccst1/datafile/vscc_idx01.271.777215867
To +FRA/vsccst1/backupset/2012_03_14/nnndf0_tag_1203141031_0.306.777897107
Than backed up +FRA/vsccst1/backupset/2012_03_14/nnndf0_tag_1203141031_0.306.777897107 to /vzwhome/oracle/log/test/2gn5rh4i_1_2
So far so good.
What I dont understand is this output, is this a backup of
a control file?
Secondly, are control files placed in backupsets? If not,
what do I need to do in order to get this backup set to
a file system.
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
2300 Full 14.95M DISK 00:00:01 03-14-2012 10:32:14
BP Key: 2304 Status: AVAILABLE Compressed: NO Tag: TAG20120314T103213
Piece Name: +FRA/vsccst1/autobackup/2012_03_14/s_777897133.304.777897135
SPFILE Included: Modification time: 03-13-2012 22:03:06
SPFILE db_unique_name: VSCCST1
Control File Included: Ckp SCN: 2771057 Ckp time: 03-14-2012 10:32:13
|
|
|
|
|
|