What is backup and how to take database backup in Sybase ASE
What is backup and how to take database backup in Sybase ASE
00:00 Introduction
It is copy of all used pages in database .Backup is basic unit of recovery in case of disaster
ASE don’t have mechanism to back up and restore tables,
indexes, any individual data components
When we need backup
When database or hardware starts to fail, it is grate to have a disaster recovery plan so if you have these plan in place you need to worry
This backup helps you to working order quickly and efficiently.
Roles and Responsibility
DBO has responsibility and permission to execute commands that dump and load database.
DBO can not grant permission to any other user, but any user is aliased to DBO will be able to perform dump and load operation.
Any login with oper_role have permission to dump and load any database on the server.
We can have open_role to assign an individual or group responsibility to perform dump and load operation
How to grant oper_role to login by SSO or SA
Grant role oper_role to login_name1.
How often should you backup a database ?
You need backup when table corruption, database corruption , media failure, disk failure any environment catastrophes.
You must have daily backup policy however you can dump database while it is in use.
Yes make sure you have ample CPU and disk space needed Yes it hits performance 5% and it is recommended. Dump database when there is low utilisation.
For big database where there is dump needed more space we can use incremental backup we can see later in this video
Backup types
Database Dump - it is complete backup of both database and transaction log.
Transaction dumps - it is backup of transaction log only which is copy of change in database.
Explain Scenario
1) 3am full dump ,9 am dump tran ,11 am dump tran then 12 noon database disk failure
2) load database 3am , load tran 9am , Laod tran 11 am
Backup Server
This is separate application within your host which bypass ASE process and access database device directly for purpose of dump operation and load operation.
Ps -aef|grep dataserver*
Ps -aef|grep -I backup*
How to shutdown Sybase instance and Backup Server.
• How to shutdown Sybase ASE server
What are advantages of backup server
ASE instruct backup server via remote procedure calls to backup specific database.
Backup server handles I/O rather using ASE resources
Backup breaks data in fairly equal portions and dump those portion in parallel.
If have additional memory configuration backup server is capable of parallel dump and load operation