Data Backup and Recovery

Cannot create Profile

3GISSMORACLE
4,232 Views

Hi

I've got the following error when creating the profile. I don't know what it means ,Please help !

SnapManager for Oracle 3.1P1

OS : Hp-ux 11.23

Oracle  9.2.0

-[ INFO] SMO-13046: Operation GUID 8a2aa0b231524fb90131524fc5d90009 starting on Profile EnterENTTST

--[ INFO] SMO-13505: SnapDrive environment verification passed.

--[ INFO] SMO-13506: SQLPlus verification for database SID "ENTTST" passed.  Environment: [ORACLE_HOME=/ent/oracle/product/9.2.0]

--[ INFO] SMO-07431: Saving starting state of the database: ENTTST(OPEN).

--[ INFO] SMO-07431: Saving starting state of the database: ENTTST(OPEN).

--[ INFO] SD-00016: Discovering storage resources for /ENTTST_data.

--[ INFO] SD-00017: Finished storage discovery for /ENTTST_data.

--[ INFO] SD-00016: Discovering storage resources for /controlredo.

--[ INFO] SD-00017: Finished storage discovery for /controlredo.

--[ INFO] SD-00016: Discovering storage resources for /archive.

--[ INFO] SD-00017: Finished storage discovery for /archive.

--[ INFO] SD-00040: Beginning to discover filesystem(s) upon host volume group vgnetapp_archive.

--[ INFO] SD-00041: Finished discovering filesystem(s) upon host volume group vgnetapp_archive.

--[ INFO] SD-00040: Beginning to discover filesystem(s) upon host volume group vgnetapp_orafile.

--[ INFO] SD-00041: Finished discovering filesystem(s) upon host volume group vgnetapp_orafile.

--[ INFO] SD-00040: Beginning to discover filesystem(s) upon host volume group vgnetapp_ent.

--[ INFO] SD-00041: Finished discovering filesystem(s) upon host volume group vgnetapp_ent.

--[ERROR] FLOW-11019: Failure in BuildRestoreSteps: java.lang.NullPointerException

--[ERROR] FLOW-11008: Operation failed: java.lang.NullPointerException

--[ERROR] SMO-05075: Profile create failed: SMO-13527: Error performing fast restore check: FLOW-11019: Failure in BuildRestoreSteps: java.lang.NullPointerException.

Best regard

Tien

6 REPLIES 6

pdeshaye
4,232 Views

64bits or 32bits?

3GISSMORACLE
4,232 Views

Hi

WEB GUI is  installed on windows server 2003 32bits

SMO server is installed on HpUX 11.23 64 bits

Regards/Tien

pdeshaye
4,232 Views

OK,

About smo logs, What it say?

pdeshaye
4,232 Views

🙂

I have the same error.

AIX

SMSAP 3.1P1

Oracle 10GR2

pdeshaye
4,232 Views

If Somebody have An idea:

Some Smsap logs :

2011-08-02 10:07:20,148 [default0 f8bbdcbc229dab4144e75a8cb17f684c] [DEBUG]: FileSystemRestoreScopeCalculation - recursing to directory /oracle/TR1/sapdata4/undo_8
2011-08-02 10:07:20,148 [default0 f8bbdcbc229dab4144e75a8cb17f684c] [DEBUG]: FileSystemRestoreScopeCalculation - recursing to directory /oracle/TR1/sapdata4/user1i_1
2011-08-02 10:07:21,463 [default0 f8bbdcbc229dab4144e75a8cb17f684c] [DEBUG]: Storage component: /oracle/TR1/sapdata2/cust1d_2/cust1d.data2
2011-08-02 10:07:21,463 [default0 f8bbdcbc229dab4144e75a8cb17f684c] [DEBUG]: First Diskward component is : /oracle/TR1/sapdata2, Total diskward components : 1, Scope is: FULL
2011-08-02 10:07:21,463 [default0 f8bbdcbc229dab4144e75a8cb17f684c] [DEBUG]: To find if restore to an alternal location is specified in restore spec
2011-08-02 10:07:21,473 [default0 f8bbdcbc229dab4144e75a8cb17f684c] [ERROR]: FLOW-11019: Failure in BuildRestoreSteps: java.lang.NullPointerException
java.lang.NullPointerException
at com.netapp.snapfile.restore.RestoreStepGraphFactory.createRestoreStepGraph(RestoreStepGraphFactory.java:104)
at com.netapp.snapfile.restore.BuildRestoreStepsTask.execute(BuildRestoreStepsTask.java:52)
at com.netapp.common.flow.TaskInstanceTemplate.execute(TaskInstanceTemplate.java:336)
at com.netapp.common.flow.Operation.executeCurrentStack(Operation.java:140)
at com.netapp.common.flow.Operation.execute(Operation.java:55)
at com.netapp.common.flow.Threadpool$OperationThread.run(Threadpool.java:257)
2011-08-02 10:07:21,480 [default0 f8bbdcbc229dab4144e75a8cb17f684c] [ERROR]: FLOW-11008: Operation failed: java.lang.NullPointerException
java.lang.NullPointerException
at com.netapp.snapfile.restore.RestoreStepGraphFactory.createRestoreStepGraph(RestoreStepGraphFactory.java:104)
at com.netapp.snapfile.restore.BuildRestoreStepsTask.execute(BuildRestoreStepsTask.java:52)
at com.netapp.common.flow.TaskInstanceTemplate.execute(TaskInstanceTemplate.java:336)
at com.netapp.common.flow.Operation.executeCurrentStack(Operation.java:140)
at com.netapp.common.flow.Operation.execute(Operation.java:55)
at com.netapp.common.flow.Threadpool$OperationThread.run(Threadpool.java:257)
2011-08-02 10:07:21,491 [RMI TCP Connection(2)-10.2.4.109] [ERROR]: SMSAP-05075: Profile create failed: SMSAP-13527: Error performing fast restore check: FLOW-11019: Failure in BuildRestoreSteps: java.lang.NullPointerException.
2011-08-02 10:07:27,234 [RMI TCP Connection(2)-10.2.4.109] [ERROR]: SMSAP-13032: Cannot perform operation: Profile Create. Root cause: SMSAP-13527: Error performing fast restore check: FLOW-11019: Failure in BuildRestoreSteps: java.lang.NullPointerException.
com.netapp.dlm.services.vhi.HostSessionException: SMSAP-13527: Error performing fast restore check: FLOW-11019: Failure in BuildRestoreSteps: java.lang.NullPointerException.
at com.netapp.dlm.process.operation.FastRestoreCheckAlgorithm$2.constructException(FastRestoreCheckAlgorithm.java:89)
at com.netapp.dlm.process.operation.FastRestoreCheckAlgorithm$2.constructException(FastRestoreCheckAlgorithm.java:88)
at com.netapp.dlm.services.vhi.SnapFileInvocation.invoke(SnapFileInvocation.java:73)
at com.netapp.dlm.process.operation.FastRestoreCheckAlgorithm.runCheck(FastRestoreCheckAlgorithm.java:93)
at com.netapp.dlm.process.operation.ProfileCreateOperation.processDatabase(ProfileCreateOperation.java:171)
at com.netapp.dlm.process.operation.ProfileCreateOperation.doExecute(ProfileCreateOperation.java:127)
at com.netapp.dlm.process.common.OpCycleOperation.execute(OpCycleOperation.java:146)
at com.netapp.dlm.server.RemoteOperationImpl.execute(RemoteOperationImpl.java:62)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:309)
at sun.rmi.transport.Transport$1.run(Transport.java:168)
at java.security.AccessController.doPrivileged(AccessController.java:274)
at sun.rmi.transport.Transport.serviceCall(Transport.java:164)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:506)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.handleRequest(TCPTransport.java:838)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:912)
at java.lang.Thread.run(Thread.java:811)
2011-08-02 10:07:27,237 [RMI TCP Connection(2)-10.2.4.109] [INFO ]: SMSAP-07433: Returning the database to its initial state: TR1(OPEN).
2011-08-02 10:07:27,238 [RMI TCP Connection(2)-10.2.4.109] [DEBUG]: ORACLE-10000: Executing SQL query: select status from v$instance
2011-08-02 10:07:27,239 [RMI TCP Connection(2)-10.2.4.109] [DEBUG]: ORACLE-10007: Finished executing SQL in 0:00:00.001: select status from v$instance
2011-08-02 10:07:27,239 [RMI TCP Connection(2)-10.2.4.109] [DEBUG]: ORACLE-20007: Database instance TR1 is in state OPEN.
2011-08-02 10:07:27,240 [RMI TCP Connection(2)-10.2.4.109] [INFO ]: SMSAP-13039: Successfully aborted operation: Profile Create
2011-08-02 10:07:27,404 [RMI TCP Connection(2)-10.2.4.109] [ERROR]: SMSAP-13048: Profile Create Operation Status: FAILED
2011-08-02 10:07:27,409 [Thread-9] [DEBUG]: Heartbeat thread interrupted
2011-08-02 10:07:27,411 [Thread-9] [DEBUG]: Heartbeat thread finished
2011-08-02 10:07:27,411 [RMI TCP Connection(2)-10.2.4.109] [INFO ]: SMSAP-13049: Elapsed Time: 0:04:13.437
2011-08-02 10:07:27,428 [RMI TCP Connection(2)-10.2.4.109] [DEBUG]: Operation ENDED
2011-08-02 10:07:28,489 [RMI Unreferenced-1] [DEBUG]: RemoteObjectFactory unreferenced
2011-08-02 10:07:28,489 [RMI Unreferenced-2] [DEBUG]: Cleaning up operation factory JVM.

3GISSMORACLE
4,232 Views

Hi pdeshaye.

Efter some tests ,now I knew what my problem is . The reason  why SMO(for my problem,only) cannnot create a profile is that data files and Oracle_Home are on the same volumes/disk. After seperating them into different volumes/disks it does work perfectly.

Vol1/disk1 controlfiles ,redolog files

Vol2/disk2 archivelog files

Vol3/disk3 datafiles

Vol4/disk4 ORACLE_HOME

Regards/Tien

Public