I know nothing about Oracle databases, so if my question's path seems odd, feel free to tell me the right way to do things.
I have 2 ways I see currently that I can backup a server running 3 Oracle databases for a 3rd party app we have.
I can use Symantec BE 2010 R3's oracle agent. Which I downloaded and configured but it tells me that in order to backup the databases "when it is in NOARCHIVELOG mode, the database must be MOUNTED but not OPEN". So I guess the question here would be how to change the databases to ARCHIVELOG mode so that they can be open when I back them up or how can I pass a command to CLOSE the database prior to backing them up and then OPEN it back up after the backup completes?
I can use the "exp" command. The problem here is that I'm not sure what parameters/options to pass for each DB. The 3rd party has steps to take, but they include choosing "(2) tables" and some other choices that don't seem to be default choices in the EXP command help. For instance here's a screenshot of their exp "choices":
Any assistance with either one of these methods or if there's another/better method, please let me know.