Home » RDBMS Server » Backup & Recovery » backup backupset completed between (Solaris 2.10 Oracle 11203)
backup backupset completed between [message #547560] Wed, 14 March 2012 13:12 Go to next message
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



Re: backup backupset completed between [message #547566 is a reply to message #547560] Wed, 14 March 2012 14:36 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Quote:

SPFILE Included
: Modification time: 03-13-2012 22:03:06
Control File Included: Ckp SCN: 2771057 Ckp time: 03-14-2012 10:32:13

What do you think?

[Updated on: Wed, 14 March 2012 15:31] by Moderator

Report message to a moderator

Re: backup backupset completed between [message #547567 is a reply to message #547566] Wed, 14 March 2012 14:48 Go to previous messageGo to next message
BeefStu
Messages: 208
Registered: October 2011
Senior Member
LK,

Thanks for the reponse. What I dont get is how come these files are not copied to the file system like the others.. If my FRA area was corrupted, I would not be able to get the spfile or control file. Or am I missing something?
Re: backup backupset completed between [message #547575 is a reply to message #547567] Wed, 14 March 2012 15:51 Go to previous message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Check out the following parameter to find the controlfile backup:
RMAN> show all;
#... look for:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/some/path/cfsdb1_%F';

[Updated on: Thu, 15 March 2012 00:24] by Moderator

Report message to a moderator

Previous Topic: Regardng ResetLogs
Next Topic: Restore failed - 10.2.0.1.0
Goto Forum:
  


Current Time: Thu Mar 28 20:07:58 CDT 2024