alexkorenori Posted July 30, 2008 Report Share Posted July 30, 2008 Is there a good way to do a nightly unattended backup of an Oracle database using Restrospect? I am the system-administrator-by-default at a small company and am being told by our main vendor that for the Oracle server we really need to install Backup Exec which is apparently able to stop the Oracle services before backing up and restart it after. I would like if possible to use Retrospect for the Oracle server as well since I am planning to use it for our desktop pcs/macs, fileserver, ad server etc. Is it going to be too difficult to implement Oracle backup using Retrospect? Any suggestions would be much appreciated! Quote Link to comment Share on other sites More sharing options...
Mayoff Posted July 31, 2008 Report Share Posted July 31, 2008 You can use the Open File Backup Add-on to get a crash consistent state of the databases. No oracle addon is available. Quote Link to comment Share on other sites More sharing options...
alexkorenori Posted July 31, 2008 Author Report Share Posted July 31, 2008 Thank you Robin for the information. I'm still reading through the manual so I'm not sure about the terminology... Is a "crash consistent state" the same as a backup? Also, my vendor tells me that I need to do a cold backup of Oracle rather than an open file backup. Is there going to be a difference in accuracy? Thanks for your help. Quote Link to comment Share on other sites More sharing options...
Mayoff Posted July 31, 2008 Report Share Posted July 31, 2008 Cold Backup would require you to close the database before a backup or use an Oracle export tool to save a copy of the DB before the backup. Quote Link to comment Share on other sites More sharing options...
Lennart_T Posted July 31, 2008 Report Share Posted July 31, 2008 Cold Backup would require you to close the database before a backup or use an Oracle export tool to save a copy of the DB before the backup. The latter is exactly what we do here: Create a DB dump file and backup that file. Quote Link to comment Share on other sites More sharing options...
alexkorenori Posted July 31, 2008 Author Report Share Posted July 31, 2008 Do you do the dump manually, or is there a way to automate the dump so that it is there waiting for Retrospect to back it up at its scheduled time? I know nothing about Oracle so I may be asking a really stupid question here but any tips would be greatly appreciated! Quote Link to comment Share on other sites More sharing options...
Lennart_T Posted July 31, 2008 Report Share Posted July 31, 2008 No, we schedule the dump, so it's finished before the backup runs. Sorry, I have NO idea how on Windows, we normally run Oracle on Solaris (Unix). We have test installations of Oracle on Windows, but we don't backup them. There is a command line interface to Oracle on Windows, so I assume you can schedule a .bat file, but you are on your own here. Quote Link to comment Share on other sites More sharing options...
alexkorenori Posted July 31, 2008 Author Report Share Posted July 31, 2008 Thanks. I'll look into the command line interface. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.