Sybase ASE – Read a dumpfile with headeronly

We can use the “headeronly” qualifier when reading a dumpfile to extract useful information which we can use to work out what is needed to setup a new database to load the given dump file. Using following command to read the dumpfile:- load database headerfrom “compress::<dumpfile_path_and_name>”with headeronlygo This would generate a output something like:- Backup…

Sybase ASE – Dump/Load a database to/from multiple stripes

Following command can be used to dump a Sybase ASE database into multiple stripes:- dump database to ‘compress::<dumpfile_path_and_filename>_01.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_02.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_03.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_04.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_05.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_06.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_07.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_08.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_09.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_10.dmp’go Following command can be used to load a Sybase ASE database from multiple stripes:- load database from ‘compress::<dumpfile_path_and_filename>_01.dmp’stripe on…

Sybase ASE – Rename a Database

In the following article we would rename a Sybase ASE DB named ABC to DEF. In order to rename the database we need to set the database in single user mode, by using the following command:- sp_dboption ‘ABC’,’single user’,truegouse ABCgocheckpointgo Once the DB is set to single user mode, we would call the sp_renamedb procedure…

Sybase ASE – Create new Database & Device in Sybase ASE

In Sybase ASE the database is hosted on devices which in turn are mapped to physical datafiles. So to create a database we should have devices already created, if not we can create new devices as:- disk init name='<Device Name>’, physname='<PATH where the datafile would be created>’, size='<Size in MB>M’, directio=true go From the above…

Oracle Auto-Startup Script for Linux

This post is to provide a script to auto-start Oracle Instances on Linux upon server restart. First step would be to configure /etc/oratab file as per your requirement, oratab file is in the following format: <DB NAME>:<ORACLE HOME>:<Y|N> The last letter tells oracle if the database need to restarted or not, so we would change…