Thinking Out Loud

May 7, 2015

Find Contents of RMAN backuppiece

Filed under: RMAN — mdinh @ 12:14 am

RMAN backuppiece listings from OS

oracle@arrow:hawklas:/home/oracle
$ ll /oradata/backup/
total 216088
-rw-r-----. 1 oracle oinstall  1212416 May  5 11:06 DBF_HAWK_3130551611_20150505_hjq65thu_1_1_KEEP
-rw-r-----. 1 oracle oinstall 50536448 May  5 11:07 DBF_HAWK_3130551611_20150505_hkq65thu_1_1_KEEP
-rw-r-----. 1 oracle oinstall 39059456 May  5 11:07 DBF_HAWK_3130551611_20150505_hlq65thv_1_1_KEEP
-rw-r-----. 1 oracle oinstall  5529600 May  5 11:07 DBF_HAWK_3130551611_20150505_hmq65tie_1_1_KEEP
-rw-r-----. 1 oracle oinstall  1785856 May  5 11:07 DBF_HAWK_3130551611_20150505_hnq65tit_1_1_KEEP
-rw-r-----. 1 oracle oinstall    98304 May  5 11:07 DBF_HAWK_3130551611_20150505_hoq65tjd_1_1_KEEP
-rw-r-----. 1 oracle oinstall     2560 May  5 11:07 DBF_HAWK_3130551611_20150505_hpq65tjf_1_1_KEEP
-rw-r-----. 1 oracle oinstall  1343488 May  5 11:07 DBF_HAWK_3130551611_20150505_hqq65tjh_1_1_KEEP
-rw-r-----. 1 oracle oinstall  1212416 May  4 19:43 HAWK_3130551611_20150504_h9q647ee_1_1
-rw-r-----. 1 oracle oinstall 39051264 May  4 19:43 HAWK_3130551611_20150504_haq647ee_1_1
-rw-r-----. 1 oracle oinstall 50315264 May  4 19:43 HAWK_3130551611_20150504_hbq647ef_1_1
-rw-r-----. 1 oracle oinstall  5529600 May  4 19:43 HAWK_3130551611_20150504_hcq647em_1_1
-rw-r-----. 1 oracle oinstall  1785856 May  4 19:43 HAWK_3130551611_20150504_hdq647ep_1_1
-rw-r-----. 1 oracle oinstall   285184 May  4 19:43 HAWK_3130551611_20150504_hfq647ev_1_1
-rw-r-----. 1 oracle oinstall  1088000 May  4 19:43 HAWK_3130551611_20150504_hgq647ev_1_1
-rw-r-----. 1 oracle oinstall   280064 May  4 19:43 HAWK_3130551611_20150504_hhq647f0_1_1
-rw-r-----. 1 oracle oinstall 11075584 May  4 19:43 HAWK_c-3130551611-20150504-0e
-rw-r-----. 1 oracle oinstall 11075584 May  4 19:43 HAWK_c-3130551611-20150504-0f

Let’s find the backupset and content of backupset for backuppiece.

oracle@arrow:hawklas:/home/oracle
$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Wed May 6 17:02:57 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: HAWK (DBID=3130551611)

RMAN> list backuppiece '/oradata/backup/HAWK_3130551611_20150504_hbq647ef_1_1';

using target database control file instead of recovery catalog

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
555     554     1   1   AVAILABLE   DISK        /oradata/backup/HAWK_3130551611_20150504_hbq647ef_1_1

RMAN> list backupset 554;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
554     Full    47.98M     DISK        00:00:09     2015-MAY-04 19:43:20
        BP Key: 555   Status: AVAILABLE  Compressed: YES  Tag: TAG20150504T194309
        Piece Name: /oradata/backup/HAWK_3130551611_20150504_hbq647ef_1_1
  List of Datafiles in backup set 554
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  2       Full 1946389    2015-MAY-04 19:43:11 /oradata/HAWKLAS/datafile/o1_mf_sysaux_bg5n9c44_.dbf

RMAN>

The backuppiece is from FULL database backup containing datafile for tablespace SYSAUX.

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: