When I try to config one single profile (SC 3.4) with two or more Oracles databases (11g), I'm facing the following problem when I run the backup:
alter database begin backup
ERROR at line 1:
ORA-01146: cannot start online backup - file 1 is already in backup
ORA-01110: data file 1: 'D:\DEMO3\SYSTEM01.DBF'
In this configuration there are two Oracle databases in the same profile (VM + Aplication Consistent). Both databases share the same Oracle Home directory. (this is a VMware VM housed alone in a NFS datastore).
I think the first "begin backup" command put all databases in backup mode, thus further "begin backup" will fail.
Due a lack of information, I don't know how to config this profile properly.
We dont want an oracle user we want an OS user that has access to oracle DB. For example on unix this is usually oracle. On windows it could be administrator, it depends on your setup.
Basically do following from command prompt
sqlplus / as sysdba
If you get connection to Oracle that that OS user has permissions. Assuming OS user is administrator you would do following:
Also for windows ORACLE_EXPORT_PARAMETERS wont do anything and probably should be set to N, that is mostly for UNIX systems where we see many DBs on one host, usually windows is one DB per host. On windows we require that ORACLE_HOME and ORACLE_SID are setup.
Again to verify open command shell
If these are not set then they should be, so please add them to environment
I tried your suggestion, but there is one point that is not clear for me: what "ORACLE_SID" parameter is valid if there are two databases in the same host? I just put the first DB name.
The ORACLE_HOME parameter now was corrected in my environment and I put "administrator" as you suggested, but didn't change the behaviour.
I think the second command below will always fail if the first line issues "alter database begin backup" first. I analyzed the error log from the second command below and I see "alter database begin backup" has failed ( file 1 is already in backup).
APP_QUIESCE_CMD01="C:/Program Files/Netapp/NetApp_Snap_Creator_Framework/scServer3.4.0/snapcreator.exe" --profile oracle_vm_2i --config oracle_vm_2i_oracle_1 --action quiesce (first DB - no errors)
APP_QUIESCE_CMD02="C:/Program Files/Netapp/NetApp_Snap_Creator_Framework/scServer3.4.0/snapcreator.exe" --profile oracle_vm_2i --config oracle_vm_2i_oracle_2 --action quiesce (second DB - I got the error "ORA-01146: cannot start online backup - file 1 is already in backup"
APP_QUIESCE_CMD03="C:/Program Files/Netapp/NetApp_Snap_Creator_Framework/scServer3.4.0/snapcreator.exe" --profile oracle_vm_2i --config oracle_vm_2i_vibe --action quiesce (didn't run due error above)
Sorry, I forgot to mention that scServer (from where I issue all SC commands) and scAgent (where Oracle resides) are different machines so I can't make a .bat that sets ORACLE_HOME in scServer (that does not have Oracle installed). In the same way I can't issue SC commands from scAgent because there is no conf files there.
Sorry again, I'm not so expert in Oracle to tell what's happening. There are two databases named DEMO2 and DEMO3 and I dont know if I must use DEMO2 or DEMO3 for ORACLE_SID when is required. But IMHO I'm not pretty sure that is the root of the problem.
Why don't you just backup DEMO2 and DEMO3 separately?
Again all that is required is oracle_sid and oracle_home be set correctly and this must be done outside of SC.
If you have to back them up together only way is installing scServer on DB host and creating wrapper script so oracle_home and oracle_sid are set correctly or running two agents, one fir each DB. So when you start agent you could set oracle_home and oracle_sid then through wrapper.
The problem right now is DEMO2 is set as oracle_sid so quiescing it works but when we do DEMO3, DEMO2 is set as oracle_sid. SC supports no way of changing this so you have to handle it on your own.
i'm try to configure SnapCreator to perform hotbackup of Oracle database. For Solaris client platform it work well but not on microsoft windows platform. My windows has only 1 oracle database instance. Below is message that i got all time when i execute quiesce operation
Yes. The domain user that has permissions to run sqlplus command connect as sysdba will also work.
Please ensure the snapcreator service is also started as the same domain user, since the environment variables may differ if you run the snapcreator service in a different account. (like system or administrator).