dba oracle,sql server, mysql,db2 express postgres & sybase
TRANSCRIPT
![Page 1: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/1.jpg)
DBA MySQL,Postgres,Oracle,DB2 , Sybase &MS SQL
By
Sunny U Okoro
![Page 2: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/2.jpg)
1
Table of Contents
MYSQL DBA.............................................................................................................................................2
Migration.............................................................................................................................................3
Backup...............................................................................................................................................10
Recovery 1.........................................................................................................................................13
Recovery 2.........................................................................................................................................15
PostgreSQL 9.4 DBA...................................................................................................................................18
Backup and Recovery............................................................................................................................19
SQL Anywhere 16 DBA..............................................................................................................................25
SQL Server 2014 DBA.................................................................................................................................32
Backup...................................................................................................................................................32
Recovery................................................................................................................................................34
DB2 Express DBA.......................................................................................................................................38
Backup...................................................................................................................................................38
Recovery................................................................................................................................................42
Oracle 11G/12C.........................................................................................................................................43
User Accounts and Tablespace..............................................................................................................43
Objects Creation....................................................................................................................................45
Objects Verification...............................................................................................................................47
![Page 3: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/3.jpg)
2
MYSQL DBA
![Page 4: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/4.jpg)
3
MigrationSQL Server 2008R2 to MySQL
![Page 5: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/5.jpg)
4
![Page 6: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/6.jpg)
5
![Page 7: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/7.jpg)
6
![Page 8: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/8.jpg)
7
![Page 9: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/9.jpg)
8
![Page 10: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/10.jpg)
9
![Page 11: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/11.jpg)
10
Backup
![Page 12: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/12.jpg)
11
![Page 13: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/13.jpg)
12
![Page 14: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/14.jpg)
13
Recovery 1
![Page 15: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/15.jpg)
14
![Page 16: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/16.jpg)
15
Recovery 2
![Page 17: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/17.jpg)
16
![Page 18: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/18.jpg)
17
![Page 19: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/19.jpg)
18
PostgreSQL 9.4 DBA
![Page 20: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/20.jpg)
19
Backup and Recovery
![Page 21: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/21.jpg)
20
![Page 22: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/22.jpg)
21
![Page 23: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/23.jpg)
22
![Page 24: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/24.jpg)
23
![Page 25: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/25.jpg)
24
![Page 26: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/26.jpg)
25
SQL Anywhere 16 DBA
![Page 27: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/27.jpg)
26
![Page 28: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/28.jpg)
27
![Page 29: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/29.jpg)
28
![Page 30: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/30.jpg)
29
![Page 31: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/31.jpg)
30
![Page 32: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/32.jpg)
31
![Page 33: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/33.jpg)
32
SQL Server 2014 DBA
BackupSQL Server 2008R2
![Page 34: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/34.jpg)
33
![Page 35: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/35.jpg)
34
Recovery
SQL Server 2014
![Page 36: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/36.jpg)
35
![Page 37: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/37.jpg)
36
![Page 38: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/38.jpg)
37
![Page 39: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/39.jpg)
38
DB2 Express DBA
Backup
![Page 40: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/40.jpg)
39
![Page 41: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/41.jpg)
40
![Page 42: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/42.jpg)
41
![Page 43: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/43.jpg)
42
Recovery
![Page 44: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/44.jpg)
43
Oracle 11G/12C
User Accounts and Tablespace
![Page 45: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/45.jpg)
44
![Page 46: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/46.jpg)
45
Objects Creation
![Page 47: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/47.jpg)
46
Output file
![Page 48: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/48.jpg)
47
Objects Verification
![Page 49: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/49.jpg)
48
![Page 50: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/50.jpg)
49
![Page 51: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/51.jpg)
50
![Page 52: DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase](https://reader038.vdocuments.us/reader038/viewer/2022102703/587b912f1a28ab4e4f8b5225/html5/thumbnails/52.jpg)
51
DBA and Recovery