When the Sybase server is corrupt or lost, you can restore the whole server (both user databases and system databases), and then recover it from the latest full backup. Each database would be restored from their latest backup.
You can also revert the database to a specific point-in-time. For more information, see Restoring Sybase Databases to a Point-in-Time.
Before You Begin
-
Verify that the Sybase backup server is running.
-
Set the "max memory" parameter to the source server required value. If the source server does not startup because of memory issues, you need to adjust the value. For more information, go to the Sybase website, How much memory to configure.
-
Create the RUN_<SERVER-NAME> file if it does not exist on the server in the $SYBASE/$SYBASE_ASE/install directory. Set the master device path to the same as the source when you restore to the source, or the value that you enter in the CommCell Console for a new destination. For information on how to create the file, go to the Sybase website, The runserver file.
-
If you have the "net password encryption reqd" Sybase server parameter set to 1 or 2, then perform the following actions:
-
Verify that the Sybase ocs.cfg file exists.
-
Edit the ocs.cfg file and add the following lines:
[DEFAULT] CS_SEC_EXTENDED_ENCRYPTION = CS_TRUE [isql] CS_SEC_ENCRYPTION = CS_TRUE CS_SEC_EXTENDED_ENCRYPTION = CS_TRUE [ClSybAgent] CS_SEC_EXTENDED_ENCRYPTION = CS_TRUE [NAMED_APP_DEFAULT] CS_SEC_ENCRYPTION = CS_TRUE CS_SEC_EXTENDED_ENCRYPTION = CS_TRUE
-
Procedure
-
From the CommCell Browser, expand Client Computers > client > Sybase.
-
Right-click the instance, point to All Tasks and then click Restore Sybase Server.
The Sybase Restore dialog box is displayed.
-
On the General tab, select the Sybase Create Devices check box.
-
Click OK to start the restore.
Before You Begin
-
Verify that the Sybase backup server is running.
-
Set the "max memory" parameter to the source server required value. If the source server does not startup because of memory issues, you need to adjust the value. For more information, go to the Sybase website, How much memory to configure.
-
Create the RUN_<SERVER-NAME> file if it does not exist on the server in the $SYBASE/$SYBASE_ASE/install directory. Set the master device path to the same as the source when you restore to the source, or the value that you enter in the CommCell Console for a new destination. For information on how to create the file, go to the Sybase website, The runserver file.
-
If you have the "net password encryption reqd" Sybase server parameter set to 1 or 2, then perform the following actions:
-
Verify that the Sybase ocs.cfg file exists.
-
Edit the ocs.cfg file and add the following lines:
[DEFAULT] CS_SEC_EXTENDED_ENCRYPTION = CS_TRUE [isql] CS_SEC_ENCRYPTION = CS_TRUE CS_SEC_EXTENDED_ENCRYPTION = CS_TRUE [ClSybAgent] CS_SEC_EXTENDED_ENCRYPTION = CS_TRUE [NAMED_APP_DEFAULT] CS_SEC_ENCRYPTION = CS_TRUE CS_SEC_EXTENDED_ENCRYPTION = CS_TRUE
-
Procedure
-
From the CommCell Browser, expand Client Computers > client > Sybase.
-
Right-click the instance, point to All Tasks and then click Restore Sybase Server.
The Sybase Restore dialog box is displayed.
-
On the General tab, select the Sybase Create Devices check box.
-
Click OK to start the restore.