SMO backups with Oracle RAC one node

tonymu — Thu, 05 Jun 2025 04:36:33 GMT

We're currently doing a POC for oracle RAC one node and i'm having issues trying to create the smo profile here is the error.

[oracle@pocdb1 ~]$ smo profile create -profile TEST -profile-password password -repository -dbname SMOPROD1 -host 10.217.0.32 -login -username smo_rep_owner -port 1521 -database -login -username smo_oper -password password -dbname TEST -host pocdb1 -sid TEST_2 -port 1521 -osaccount oracle -osgroup oinstall -retain -daily -count 7 -duration 7 -hourly -count 4 -duration 24 -monthly -count 12 -duration 12 -weekly -count 4 -duration 4 -snapname-pattern smo_{profile}_{db-sid}_{scope}_{mode}_{smid}
[ INFO] SMO-20020: Set password for profile "TEST" in user credentials for "oracle".
[ERROR] SMO-05075: Profile create failed: ORACLE-00300: Error executing srvctl command srvctl status database -d TEST. The command returned: [Instance TEST_2 is running on node pocdb1, Online relocation: INACTIVE]
[ INFO] SMO-20022: Deleted credentials and repository mapping for profile "TEST" in user credentials for "oracle".
Operation Id [8a9a83744ca34820014ca34824940009] failed. Error: Error executing srvctl command srvctl status database -d TEST. The command returned: [Instance TEST_2 is running on node pocdb1, Online relocation: INACTIVE]

To me it seems as though it doesn't like the output from srvctl status database, does anybody use SMO with oracle RAC one node? I've tried setting up a profile to a RAC database on the same cluster and that seems to work ok.

The output from srvctl status database differ from a RAC database to a RAC one database

RAC database output

[oracle@pocdb1 ~]$ srvctl status database -d TESTRAC
Instance TESTRAC1 is running on node pocdb1
Instance TESTRAC2 is running on node pocdb2

RAC one node database output

[oracle@pocdb1 ~]$ srvctl status database -d TEST
Instance TEST_2 is running on node pocdb1
Online relocation: INACTIVE

Any help appreciated!

Thanks

Tony

Re: SMO backups with Oracle RAC one node

stanton — Wed, 22 Apr 2015 18:56:47 GMT

Unfortunately it will not work. According to note 5629 in the Interoperability Matrix Tool (http://mysupport.netapp.com/matrix) SnapManager for Oracle and SAP does not support Oracle Real Application Clusters One Node (Oracle RAC One Node) on Oracle 11gR2 databases.

topic Re: SMO backups with Oracle RAC one node in Data Protection

SMO backups with Oracle RAC one node

Re: SMO backups with Oracle RAC one node