SnapManager for Oracle: How to Get Backup Info?

Hello all,
Having issues to map some informations from you backup made on SnapManager for Oracle (more info here)?

Here it goes some quick tips for first mapping:

Listing Profiles in Server

[root@server-db ~]# smo profile list
Profile name: PRODDB

Showing Specific Profile Details:

oracle $ smo profile show -profile PRODDB -verbose
Profile name: PRODDB
Comment:
Target database:
  Database name: PRODDB
  SID: PRODDB1
  Host: server-db.domain.com
  Port: 1521
  Username: snapmanager
  Password: ********
Repository:
  Database name: REPODB
  SID: REPODB
  Host: serverrepo-db.domain.com
  Port: 1521
  Username: snapmanager
  Password: ********
RMAN:
  Use RMAN via control file
Oracle user account: oracle
Oracle user group: dba
Snapshot Naming:
  Pattern: smo_{profile}_{db-sid}_{scope}_{mode}_{smid}
  Example: smo_proddb_proddb1_f_h_1_8abc01e915a55ac50115a55acc8d0001_0
Protection: None
Local backups to retain:
  Hourly: 6 copies
  Daily: 7 day(s)
  Weekly: 4 week(s)
  Monthly: 12 month(s)
Notification:
  Success operation
  Failure operation
  E-mail ID: dba@grepora.com
  E-mail Subject: smo_{operation-name}_{db-sid}_{status}
Archivelog Backups:
  Archivelog Backups Separated: Yes
  Archivelog Retention Duration: 24 hours
  Always backup archivelogs along with online backups to enable cloning: Yes
Archivelog Protection: None


Listing Last Backups:

[root@server-db ~]# smo backup list -profile PRODDB -verbose | head -6
Start Date           Status     Scope   Data  Data SCN   Data End SCN   Logs   Log Start SCN   Log End SCN   Mode       Storage    Label                  Retention  Protection    ID                               Comment
-------------------- ---------- ------- ----- ---------- -------------- ------ --------------- ------------- ---------- ---------- ---------------------- ---------- ------------- -------------------------------- --------------------
2016-12-30 11:00:13  SUCCESS    FULL    NO    311095670949 311096404131   NO     309858742044    311096406860  ONLINE     EXISTS     F_H_20161230110015EST  HOURLY     NOT REQUESTED 8a94b695595075cd01595075d27d0001 PRODDB backup every 4 Hours
2016-12-30 07:00:13  SUCCESS    FULL    NO    311055804249 311056082894   NO     309849939493    311056084892  ONLINE     EXISTS     F_H_20161230070015EST  HOURLY     NOT REQUESTED 8a94b695594f9a1301594f9a178e0001 PRODDB backup every 4 Hours
2016-12-30 03:00:13  SUCCESS    FULL    NO    310927039230 310927528088   NO     309837533635    310927530410  ONLINE     EXISTS     F_H_20161230030015EST  HOURLY     NOT REQUESTED 8a94b695594ebe5801594ebe5cb80001 PRODDB backup every 4 Hours
2016-12-29 23:00:13  SUCCESS    FULL    NO    310917466592 310917803419   NO     309825010955    310917805269  ONLINE     EXISTS     F_H_20161229230015EST  HOURLY     NOT REQUESTED 8a94b695594de2a001594de2a5590001 PRODDB backup every 4 Hours
2016-12-29 19:00:14  FAILED     FULL    NO    _          _              NO     _               _             ONLINE     N/A        F_H_20161229190015EST  N/A        NOT REQUESTED 8a94b69559522d420159522d47060001 PRODDB backup every 4 Hours
2016-12-29 11:00:14  SUCCESS    FULL    NO    310869847394 310870608685   NO     309721723699    310870612494  ONLINE     EXISTS     F_H_20161229110016EST  HOURLY     NOT REQUESTED 8a94b695594b4f7301594b4f78600001 PRODDB backup every 4 Hours


Listing Backup of Filesystems:

[orabkp@server-db ~]$ ssh 10.10.10.50 snap list Oracle_Data_Prod
Volume Oracle_Data_Prod
working...

  %/used       %/total  date          name
----------  ----------  ------------  --------
  2% ( 2%)    1% ( 1%)  Sep 26 07:02  smo_proddb_proddb1_f_h_2_8a94b695576626ff0157662703cd0001_0
  2% ( 0%)    1% ( 0%)  Sep 26 07:00  smo_proddb_proddb1_f_h_1_8a94b695576626ff0157662703cd0001_0
  3% ( 1%)    1% ( 0%)  Sep 26 03:02  smo_proddb_proddb1_f_h_2_8a94b69557654b450157654b4ab10001_0
  3% ( 0%)    1% ( 0%)  Sep 26 03:00  smo_proddb_proddb1_f_h_1_8a94b69557654b450157654b4ab10001_0
  4% ( 1%)    2% ( 1%)  Sep 25 23:02  smo_proddb_proddb1_f_h_2_8a94b69557646f8e0157646f930c0001_0
  4% ( 0%)    2% ( 0%)  Sep 25 23:00  smo_proddb_proddb1_f_h_1_8a94b69557646f8e0157646f930c0001_0
  5% ( 1%)    3% ( 1%)  Sep 25 19:02  smo_proddb_proddb1_f_h_2_8a94b695576393d301576393d8210001_0
  5% ( 0%)    3% ( 0%)  Sep 25 19:00  smo_proddb_proddb1_f_h_1_8a94b695576393d301576393d8210001_0
  6% ( 1%)    3% ( 0%)  Sep 25 15:01  smo_proddb_proddb1_f_h_2_8a94b6955762b818015762b81c230001_0
  6% ( 0%)    3% ( 0%)  Sep 25 15:00  smo_proddb_proddb1_f_h_1_8a94b6955762b818015762b81c230001_0
  6% ( 1%)    4% ( 0%)  Sep 25 11:01  smo_proddb_proddb1_f_h_2_8a94b6955761dc5e015761dc63010001_0
  6% ( 0%)    4% ( 0%)  Sep 25 11:00  smo_proddb_proddb1_f_h_1_8a94b6955761dc5e015761dc63010001_0

And this is it!
I hope it helps you!

See you next week!

Advertisements

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