One of the recent challenges I had was to migrate a 20TB database from ASM to NFS and then decommission ASM. This post will give an overview of how I achieved it in relation to the requirements. Currently our storage of choice for infrastructure is NFS on Netapp and most of our existing databases are…
Category: Backup
NetApp SnapManager – Get Latest Successful Snap from Repo Database
Just started working with NetApp SnapManager and one of the questions I had was how can I find the latest successful snap per host for each database. Well looking around the smo repository we see a table called SMO_33_OPERATIONHISTORY. Now we can write a query to get the data we need.
Oracle PL/SQL
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
select hostrunupon, dbsid, max(endtime) from smo_repo.SMO_33_OPERATIONHISTORY where status = ‘SUCCESS’ group by hostrunupon, dbsid order by 1, 1 desc; HOSTRUNUPON DBSID MAX(ENDTIME) ---------------------------------------- ---------------------------------------- --------------------------------------------------------------------------- myrac01.racin.hostname1.com.au RACA21 04-JUN-14 11.30.18.250000 PM +10:00 myrac01.racin.hostname21.com.au RACB21 04-JUN-14 08.09.53.354000 PM +10:00 rachost101p RACC21 30-MAY-14 06.07.50.385000 AM +10:00 rachost101p RACD21 30-MAY-14 05.38.27.392000 AM +10:00 rachost101p RACD21 30-MAY-14 05.26.30.608000 AM +10:00 rachost101p RACF21 30-MAY-14 05.16.51.995000 AM +10:00 rachost101p RACG21 30-MAY-14 05.07.53.864000 AM +10:00 rachost101p RACH21 30-MAY-14 05.04.27.403000 AM +10:00 rachost101p RACH21 30-MAY-14 04.47.30.042000 AM +10:00 rachost101p RACJ21 30-MAY-14 04.35.22.109000 AM +10:00 rachost101p RACK21 30-MAY-14 04.26.12.588000 AM +10:00 rachost101p RACL21 30-MAY-14 04.16.09.908000 AM +10:00 rachost101p RACM21 29-MAY-14 05.57.01.359000 AM +10:00 rachost101p RACN21 29-MAY-14 05.45.38.520000 AM +10:00 rachost101p RACN21 18-MAY-14 04.06.30.684000 AM +10:00 rachost201p.rachost90.com.au RACO21 05-JUN-14 01.07.49.446000 AM +10:00 |
Looks like exactly…