Data Backup and Recovery Discussions

Highlighted

SMO backups with Oracle RAC one node

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
Highlighted

Re: SMO backups with Oracle RAC one node

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.

Check out the KB!
NetApp Insights To Action
All Community Forums