Solaris database backup plus snapshots
645524Aug 11 2008 — edited Aug 12 2008Hi All,
I am having a little problem trying to backup & restore my Oracle Database plus Snapshots in the same backup proccess.
I will try to explain the scenario:
I need to get a grip on our backup and retention policy for our Oracle instance supporting my server in Solaris.
Every day at noon and midnight is running a snapshot of the volumes with the log and data files (each from different path). Those are currently held until we run out of space.
We also have the database in archive log mode.
What I am looking to do is how can I roll back to any point in the past month at any given time. In order for this server to work we would have to also have the related volumes' snapshots in 5 differents path.
This snapshots are taking by using the following script from our netapp:
#!/bin/csh
#
# Script to backup XX and associated DSL's for mydb instance
# Script runs twice daily at noon and at midnight.
#
set date=`date +%Y%m%d%H%M`
smo backup create -online -full -profile XX -verbose
cd /net/sdata
cd /net/sdata2
cd /net/data
cd /net/apps
cd /net/home
snapdrive snap create -fs /net/data -fs /net/sdata -fs /net/sdata2 -fs /net/apps -fs /net/home -snapname DSLSNAP$date -unrelated
cp /opt/NTAPsmo/log/smo_bkup.log /opt/NTAPsmo/log/smo_bkup_$date.log
#
# Mail log file to System Administrator
uuencode /opt/NTAPsmo/log/smo_bkup.log /opt/NTAPsmo/log/smo_bkup.log | mailx -s "SMO Backup Status"
To be honest, all of this were done by a third party consultant, but now they need me to start working on this by myself...and I am getting crazy how to do it.
I hope someone could give me some little help.