Data Backup and Recovery

SMO backups with Oracle RAC one node

tonymu
2,314 Views

Hi 

 

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

1 REPLY 1

stanton
2,253 Views

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.

Public