May 30, 2007

NetApp and Oracle backup and restore

Oracle OS Oracle backup:

  1. SQL>alter tablespace test begin backup
  2. Within netapp command line: snap create volume_name snap_name
  3. SQL> alter tablespace test end backup
  4. insert some data into table belonging this tablespace test
  5. rm one datafile test.dbf
  6. SQL>alter system checkpoint; alert log will report missing datafile 9
  7. cp ../.snapshot/../test.dbf dest_location
  8. alter database recover datafile 9;
  9. alter database datafile 9 online;

RMAN backup with SnapManager for Oracle:


- No comments Not publicly viewable


Add a comment

You are not allowed to comment on this entry as it has restricted commenting permissions.

Search this blog

Search Warwick Blogs

 

Tags

Most recent comments

  • Oracle 11g is the clear leader in this area. Oracle has invested heavily into self–tuning capabiliti… by shaane on this entry
  • All the features are very nice.I like Repair Advisors the most.Oracle 10G introduced some of the dat… by lucy on this entry
  • "logical standby failed to re–start, I am also getting the same error. I have search on internet and… by anemia on this entry
  • Thanks for the nice information because from last three days i am stuck on this problem…. by robot vacuum on this entry
  • So what happen City speed dating when you tried this coding once in your PC.. Please tell me so i am… by John Bergeron on this entry
Not signed in
Sign in

Powered by BlogBuilder
© MMXXI