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!
