Subscribe

Configuring Snapcreator to work with Oracle (10.2) on Linux

[ Edited ]

Hi,

Is there any documentation specific to snapcreator and Oracle on Linux or can someone who has a better understanding of how to configure snapcreator help me through this please?  I am trying to get snapcreator to take snapshots of my oracle DB and vault it to another array.  I went through the gui wizard to configure a basic file and it's not working.  Below is the output of my failed attempt:

[Mon Dec 10 15:20:43 2012] INFO: Logfile timestamp: 20121210152043

[Mon Dec 10 15:20:43 2012] INFO: Plugin validation skipped for oracle, no plugin parameters file found or no parameters set

########## Parsing Environment Parameters ##########

########## PRE APPLICATION QUIESCE COMMANDS ##########

[Mon Dec 10 15:20:43 2012] INFO: No commands defined

########## PRE APPLICATION QUIESCE COMMANDS FINISHED SUCCESSFULLY ##########

########## Application quiesce ##########

[Mon Dec 10 15:20:49 2012] [orcyrac1:9090(3.6.0.1)] INFO: Quiescing databases

[Mon Dec 10 15:20:49 2012] [orcyrac1:9090(3.6.0.1)] INFO: Quiescing database orcy

[Mon Dec 10 15:20:49 2012] [orcyrac1:9090(3.6.0.1)] ERROR: [ora-00020] Oracle SQL*Plus command [/bin/su - oracle -c "ORACLE_HOME=/opt/oracle/product/10.2/;export ORACLE_HOME;ORACLE_SID=orcy;export ORACLE_SID;/opt/oracle/product/10.2/bin/sqlplus /nolog @/tmp/UWnSRTKKFZ.sc"] failed with return code [0] and message [The Oracle base for ORACLE_HOME=/opt/oracle/product/10.2 is /opt/oracle/product/10.2

  SQL*Plus: Release 10.2.0.5.0 - Production on Mon Dec 10 15:20:49 2012

  Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

  Connected to an idle instance.

select * from v$version

*

ERROR at line 1:

ORA-01034: ORACLE not available

    Disconnected

]

[Mon Dec 10 15:20:49 2012] [orcyrac1:9090(3.6.0.1)] ERROR: [ora-00001] Verifying correct version of database orcy failed

[Mon Dec 10 15:20:47 2012] [orcyrac1:9090(3.6.0.1)] ERROR: [scf-00053] Application quiesce for plugin oracle failed with exit code 1, Exiting!

########## Application unquiesce ##########

[Mon Dec 10 15:20:53 2012] [orcyrac1:9090(3.6.0.1)] INFO: Unquiescing databases

[Mon Dec 10 15:20:53 2012] [orcyrac1:9090(3.6.0.1)] INFO: Unquiescing database orcy

[Mon Dec 10 15:20:53 2012] [orcyrac1:9090(3.6.0.1)] ERROR: [ora-00010] Ending hot backup mode for database orcy failed

[Mon Dec 10 15:20:49 2012] ERROR: [scf-00054] Application unquiesce for plugin oracle failed with exit code 1, Exiting!

########## PRE EXIT COMMANDS ##########

[Mon Dec 10 15:20:49 2012] INFO: No commands defined

########## PRE EXIT COMMANDS FINISHED SUCCESSFULLY ##########

I am attaching my configuration file as well for reference.  As you can see, it's not even connecting to the oracle database, orcy, but once I get past that point, how does it take the snapshots?  Do I need to specify additional information for snapdrive to take the snapshot since the server uses lun?  Any help someone can provide is greatly appreciated.

Thanks

Michael

Re: Configuring Snapcreator to work with Oracle (10.2) on Linux

Ok, i got a little further.  For the home directory, I had a "/" at the end of the path.  I took that out and re-ran.  Now I'm getting further along.  As you can see from the out log, it says that the db was quiesced, but it cannot take it out.  My Oracle DB says that the DB is still not in hot backup so either it didn't put it in hotbackup or something took it out.  Thought?  Also, since it is luns, do I have to configure it to use snapdrive?

Thanks

[Mon Dec 10 16:53:18 2012] INFO: Logfile timestamp: 20121210165318

[Mon Dec 10 16:53:18 2012] INFO: Plugin validation skipped for oracle, no plugin parameters file found or no parameters set

 

########## Parsing Environment Parameters ##########

 

########## PRE APPLICATION QUIESCE COMMANDS ##########

[Mon Dec 10 16:53:18 2012] INFO: No commands defined

 

########## PRE APPLICATION QUIESCE COMMANDS FINISHED SUCCESSFULLY ##########

 

########## Application quiesce ##########

[Mon Dec 10 16:53:23 2012] [orcyrac1:9090(3.6.0.1)] INFO: Quiescing databases

[Mon Dec 10 16:53:23 2012] [orcyrac1:9090(3.6.0.1)] INFO: Quiescing database orcy

[Mon Dec 10 16:53:28 2012] [orcyrac1:9090(3.6.0.1)] INFO: Quiescing database orcy finished successfully

[Mon Dec 10 16:53:28 2012] [orcyrac1:9090(3.6.0.1)] INFO: Quiescing databases finished successfully

 

########## POST APPLICATION QUIESCE COMMANDS ##########

[Mon Dec 10 16:53:23 2012] INFO: No commands defined

 

########## POST APPLICATION QUIESCE COMMANDS FINISHED SUCCESSFULLY ##########

 

########## PRE COMMANDS ##########

[Mon Dec 10 16:53:24 2012] INFO: No commands defined

 

########## PRE COMMANDS FINISHED SUCCESSFULLY ##########

 

########## Detecting Data OnTap mode for cdcfas02 ##########

[Mon Dec 10 16:53:28 2012] INFO: Data OnTap 7 mode detected

 

########## Generating Info ASUP on cdcfas02 ##########

[Mon Dec 10 16:53:29 2012] INFO: ASUP create on cdcfas02 finished successfully

 

########## Gathering Information for cdcfas02:orcyarch1 ##########

[Mon Dec 10 16:53:29 2012] INFO: Performing Snapshot Inventory for orcyarch1 on cdcfas02

[Mon Dec 10 16:53:29 2012] INFO: Snapshot Inventory of orcyarch1 on cdcfas02 completed Successfully

 

########## Running Snapshot Rename on Primary cdcfas02 ##########

[Mon Dec 10 16:53:30 2012] INFO: orcy-daily_20121210165318 is the first snapshot taken for cdcfas02:orcyarch1, Skipping!

 

########## Creating snapshot(s) ##########

[Mon Dec 10 16:53:30 2012] INFO: NetApp Snap Creator Framework 3.6.0 detected that SnapDrive is not being used. File system consistency cannot be guaranteed for SAN/iSAN environments

 

########## Taking Snapshot on Primary cdcfas02:orcyarch1 ##########

[Mon Dec 10 16:53:30 2012] INFO: Creating Snapshot for orcyarch1 on cdcfas02

[Mon Dec 10 16:53:48 2012] INFO: Snapshot Create of orcy-daily_20121210165318 on cdcfas02:orcyarch1 Completed Successfully

 

########## Detecting Data OnTap mode for cdcfas01 ##########

[Mon Dec 10 16:53:48 2012] INFO: Data OnTap 7 mode detected

 

########## Generating Info ASUP on cdcfas01 ##########

[Mon Dec 10 16:53:48 2012] INFO: ASUP create on cdcfas01 finished successfully

 

########## Gathering Information for cdcfas01:orcyctrl1 ##########

[Mon Dec 10 16:53:48 2012] INFO: Performing Snapshot Inventory for orcyctrl1 on cdcfas01

[Mon Dec 10 16:53:48 2012] INFO: Snapshot Inventory of orcyctrl1 on cdcfas01 completed Successfully

 

########## Gathering Information for cdcfas01:orcydata1 ##########

[Mon Dec 10 16:53:48 2012] INFO: Performing Snapshot Inventory for orcydata1 on cdcfas01

[Mon Dec 10 16:53:50 2012] INFO: Snapshot Inventory of orcydata1 on cdcfas01 completed Successfully

 

########## Running Snapshot Rename on Primary cdcfas01 ##########

[Mon Dec 10 16:53:50 2012] INFO: orcy-daily_20121210165318 is the first snapshot taken for cdcfas01:orcyctrl1, Skipping!

[Mon Dec 10 16:53:50 2012] INFO: orcy-daily_20121210165318 is the first snapshot taken for cdcfas01:orcydata1, Skipping!

 

########## Creating snapshot(s) ##########

[Mon Dec 10 16:53:50 2012] INFO: NetApp Snap Creator Framework 3.6.0 detected that SnapDrive is not being used. File system consistency cannot be guaranteed for SAN/iSAN environments

 

########## Taking Snapshot on Primary cdcfas01:orcyctrl1 ##########

[Mon Dec 10 16:53:52 2012] INFO: Creating Snapshot for orcyctrl1 on cdcfas01

[Mon Dec 10 16:54:02 2012] INFO: Snapshot Create of orcy-daily_20121210165318 on cdcfas01:orcyctrl1 Completed Successfully

 

########## Taking Snapshot on Primary cdcfas01:orcydata1 ##########

[Mon Dec 10 16:54:02 2012] INFO: Creating Snapshot for orcydata1 on cdcfas01

[Mon Dec 10 16:54:04 2012] INFO: Snapshot Create of orcy-daily_20121210165318 on cdcfas01:orcydata1 Completed Successfully

 

########## PRE APPLICATION UNQUIESCE COMMANDS ##########

[Mon Dec 10 16:54:04 2012] INFO: No commands defined

 

########## PRE APPLICATION UNQUIESCE COMMANDS FINISHED SUCCESSFULLY ##########

 

########## Application unquiesce ##########

[Mon Dec 10 16:55:04 2012] ERROR: 500 read timeout at /<C:\Program Files\NetApp\NetApp_Snap_Creator_Framework\scServer3.6.0\snapcreator.exe>SnapCreator/Agent/Remote.pm line 541

 

[Mon Dec 10 16:55:04 2012] [orcyrac1:9090(3.6.0.1)] ERROR: [scf-00054] Application unquiesce for plugin oracle failed with exit code 1, Exiting!

 

########## Application unquiesce ##########

[Mon Dec 10 16:55:17 2012] [orcyrac1:9090(3.6.0.1)] ERROR: [agt-00008] Either no quiesce operation performed or forced unquiesce operation already triggered from watchdog, backup might not be useable

[Mon Dec 10 16:55:13 2012] ERROR: Forced unquiesced possibly triggered from watchdog

[Mon Dec 10 16:55:13 2012] ERROR: [scf-00054] Application unquiesce for plugin oracle failed with exit code 100, Exiting!

 

########## PRE EXIT COMMANDS ##########

[Mon Dec 10 16:55:13 2012] INFO: No commands defined

 

########## PRE EXIT COMMANDS FINISHED SUCCESSFULLY ##########

Re: Configuring Snapcreator to work with Oracle (10.2) on Linux

Check SC_AGENT_TIMEOUT

The unquiesce is taking longer than the timeout. It looks like you have it set to 60 seconds so try 300.

The reason why the oracle databases are not in hotbackup mode after unquiesce is because SC did its job. They should never be left in hotbackup mode. SC server send requests to agent to unquiesce then waits for duration of timeout. If agent / plugin are still not done then you get a read timeout as above. The agent however will continue to carry out its last instruction which was unquiescce regardless of if server throws timeout or not.

Hope this helps

Keith

Re: Configuring Snapcreator to work with Oracle (10.2) on Linux

Keith,

It definitely helped!  Thanks for the reply.  This is some great software and I appreciate the hard work you have provided on it and all of the support that I know I've received from you multiple times.

So, I'm a little further along now.  I have some additional questions unless you can point me to a document that will fix in the blanks. 

I noticed during in the logs it said filesystem consistency could not be guaranteed for SAN if Snapdrive is not used.  Since, I am using SAN, I'll muddle through getting those commands correct, but I'm confused if I need to place a check in the "Consistency Group" box, enable snapdrive discovery, and what other options I need there.

Also, concerning the "Backup Control File Dir".  I have seen other posts on this, but I'm still uncertain what this path should be set to.  My Orcy DB is using ASM.  Someone had mentioned to make the path on your data files path so that when you snap, the file is captured.  Since I'm using ASM, it doesn't seem like I can do that.  Since I'm already snapping my original ctrl location, archlogs, and db, how important is this field and what options do I have?

Thanks for the help.

Michael

Re: Configuring Snapcreator to work with Oracle (10.2) on Linux

SnapDrive is not required for SC, this is a big difference compared to SnapManager. The reason is flexibility and choice.

SC will not ensure file system is consistent, if you care about this then you need to use SnapDrive to trigger snapshots using SNAPDRIVE=Y, NTAP_SNAPSHOT_CREATE_CMD01=snapdrive bla bla bla -snap %SNAME-%SNAP_TYPE_recent, and TIMESTAMP_ONLY=N.

Do you need SnapDrive for unix? For NFS, never. For SAN also no not in my opinion unless you have UFS or some non-journaled file system. If you have a journaled file system then all SnapDrive buys you is maybe not having to do fsck when restoring. On Windows? yes snapdrive always.

The backup control file dir is simply where we place backup control files. We make a copy of control file before and after snapshot. Do you need these files? No not really only if you dont have original control files. I would just put them on some file system which is on netapp. Doesnt matter but then they will be captured on snapshot somewhere, otherwise local file system if you in fact dont plan on needing these.

Happy SnapCreating!

Keith

Re: Configuring Snapcreator to work with Oracle (10.2) on Linux

Thanks Keith.

As a precaution, I decided to use snapdrive to create the snapshots and to the best of my ability, everything is configured properly.  The creator job appears to works except it is not registering the backups with PM and updating the vault relationships.  I've looked over the config multiple times and don't see why it's not working.  Looking in the output, it's not even attempting to register the backup and protect it.   What am I doing wrong as I'm at a loss? I did create the dataset and imported 14 relationships.  Below is the command I used to create the dataset from my managment server.  I've attached my config and my job run output.  While you are at it, are my snapdrive snap commands correct?

Thanks!

Michael 

Command to create dataset:

snapcreator.exe --profile ORCYRAC2 --action pmsetup

Re: Configuring Snapcreator to work with Oracle (10.2) on Linux

Hi Michael

Do you see the newly created Dataset in PM?

regards

Thomas

Re: Configuring Snapcreator to work with Oracle (10.2) on Linux

Yes, I do. I was just discsussing this with a co-worker and we’re validating everything. I see the dataset, it says it was created by snapcreator, version3.6, etc. Looking back at the config via the gui, I see a Yes in the backup via PM options, etc. We’re both lost …. ☹

Re: Configuring Snapcreator to work with Oracle (10.2) on Linux

By the way, we are using creator for backing up our DB2 databases and they are working great with PM.  Something's obviously wrong, but I've been comparing my config against those that work and I'm not seeing anything obvious.  As you ca see from the output of the log, it's not even trying to protect via PM so I don't have any errors to chase.  It's like it's just not even reading that section of the config file.

Re: Configuring Snapcreator to work with Oracle (10.2) on Linux

One more thing, I don't think this would matter in the least, but I'm just throwing out all details.  This particular oracle DB is in a RAC.  On RAC1, we use SMO configured via PM to backup the DB to our DR site.  On RAC2, is where I have the creator agent installed to handle this backup to send the back via PM to another set of controllers at our primary site for our test environment.  Long story as to why we're using SMO for DR and attempting to use creator for our test environment.  Like I said though, I'm just trying to mention any details.  We are using separated datasets and protection policies for SMO and creator.  The SMO dataset shows it was created with SMO and the creator dataset shows it was created with Snapcreator.  The source volume for both datasets are identical of course, but the relationships that I'm imported are different since they are relationships configured for different destination controllers. 

Thanks for the help.