Page Index - Agnivo102/Database_Architect GitHub Wiki
127 page(s) in this GitHub Wiki:
- Home
- 1. Create Github Account
- Please reload this page
- 10.Linux(Find, Backup Script)
- Please reload this page
- 11. Database (Introduction, SQLPUS, Login, Objects, DQL (Select), Pipeline Operator)
- Please reload this page
- 12. SQL(where, and, or, in, sorting(order by), string comparison (like), functions(sum, max, min, upper, lower))
- Please reload this page
- 13. SQL Commands (between, functions (length, initcap, instr, rpad, lpad, concat, replace, round, trunc, nvl, to_date, to_char, extract, last_day, add_months), date formats, sysdate)
- Please reload this page
- 14. SQL (group by, multilevel query)
- Please reload this page
- 15. SQL(Join)
- Please reload this page
- 16. SQL, DDL(Create, Alter, Truncate , drop), DML (Insert, Delete, update), TCL (Commit, Rollback), Script in sql
- Please reload this page
- 17. SQL(Auto‐generated Column, Foriegn Key Constarint, View)
- Please reload this page
- 18. Create a Virtual Machine with Linux OS
- Please reload this page
- 19. Running some linux commands in new system
- Please reload this page
- 2. Cloud Server
- Please reload this page
- 20. Install oracle database into Linux Virtual Machine
- Please reload this page
- 21. Oracle Database Architecture (IMPORTANT)
- Please reload this page
- 22. (Important) Oracle Database Architecture (Starting process, parameter file, system views)
- Please reload this page
- 23. (Important) Oracle Database Architecture (PGA, SGA)
- Please reload this page
- 24. (Important) Oracle Database Architecture (Redolog File Architecture (Groups, Members), Instance Recovery (SMON), Creating a member group, Adding a member, Archive log)
- Please reload this page
- 25. (Important)Oracle Database Architecture (Oratab file, Control Files, creating a new control file)
- Please reload this page
- 26. (Important) Oracle Database Architecture (Data files, Tablespace, Database)
- Please reload this page
- 27. (Important) Oracle Database Architecture (Tablespace (Deleting, Changing status (offline, online)), Undo tablespace, Temp tablespace, Default Values (Undo tablespace, Temporary Tablespace), Undo management (Auto), Deleting a data file, Creating a big data file)
- Please reload this page
- 28. (Important) Oracle Database Architecture (Users (Show, Create, Delete), Privileges (types (System, Object), Show privileges, Granting a privilege, revoking a privilege ))
- Please reload this page
- 29. (Important) Oracle Database Architecture (Automated Script for Granting and Revoking Privilege, Role (Creating a role, Granting and Revoking privileges to it, Droping a role))
- Please reload this page
- 3. Cloud Server Login
- Please reload this page
- 30. Oracle Database (profile, script for granting every privilege for another user)
- Please reload this page
- 31. Oracle Database (Profile (Parameters, Creating a profile))
- Please reload this page
- 32. Networking
- Please reload this page
- 33. Install oracle database without the dbca graphical interface:
- Please reload this page
- 34. Listener (Creating, Starting), TNSName, Connecting to a database in another system using Listener and TNSName, Deleting a Database
- Please reload this page
- 35. Manual database creation without the dbca
- Please reload this page
- 36. Latch and Lock, Fixing a locked query due to incomplete transaction
- Please reload this page
- 37. Kernal, Data Dictionary, Data blocks types in Database buffer cache
- Please reload this page
- 38. Shutdown Types, Checkpoint, Alert Log
- Please reload this page
- 39. Backup(Hot Backup using RMAN tool (Full Database, Dtatabase with Archive log, Individual Datafile, Individual Tablespace ) Backup, Seeing all backups available (available, expired), Restoring Datafiles if it gets deleted (System, Sysaux, Undo, Users, User defined)), Deadlock Situation
- Please reload this page
- 4. Change Appearance in puTTY:‐
- Please reload this page
- 40. Incremental Backup (Differential, Cumulative), Restoring all the datafiles along with control file
- Please reload this page
- 41: Restoring database from backup in different locations in different machine:
- Please reload this page
- 42: Database Clone
- Please reload this page
- 43. Incomplete Recovery, Backup Script
- Please reload this page
- 44. Recap
- Please reload this page
- 45. Logical backup (Full Database, Schema, Table, Tablespace)
- Please reload this page
- 46. Logical backup(Single Query or in row basis), Logical Backup Restoration using ImpDp (schema, tablespace, full database (in a different server))
- Please reload this page
- 47. RMAN in Details:
- Please reload this page
- 48. Undo Management in Details:
- Please reload this page
- 49. Oracle Restore and Complete Recovery:
- Please reload this page
- 5. Introduction to Linux (pwd, mount point, cd,, ls, mkdir, touch)
- Please reload this page
- 50. Revision and some new things (high water mark, unused block skipping(image copy, backup set), restore validate, structure of an extent)
- Please reload this page
- 51. Multi Tenant Database
- Please reload this page
- 52. Oracle Full and Incremental Backups
- Please reload this page
- 53. Oracle Data pump Logical Migration
- Please reload this page
- 54. Interview (making spce for tablespace, invalid objects, how views can become invalid, drop vs delete vs trancate, user details stored in, scenarios(cold backup from rman, what to check when a user can;t connect to the database, what to check when a user can;t insert), start database without parameter files and using RMAN, user connection to database (PMON), PGA(sorting area funtionality), if temp tablespace gets missing)
- Please reload this page
- 55. Container Database, Pluggable Database practicals(show the PDBs, open PDB, close PDB, CDB name, change session to PDB, restricted mode, change name of a PDB, unplug a PDB, drrop a PDB, commn user, specific user of a PDB)
- Please reload this page
- 56. Introdcution to Production Database, Archive Log Monitoring(Getting more space by deleting previous unedded archive log files or increasing the FRA size), File System Monitoring(deleting audit trail files, trace files, trm files), Session independent jobs(how to run)
- Please reload this page
- 57. Hardware types(Disk tape), Backup Policy, Tablespace Monitoring, Process parameter monitoring, Transaction Monitoring(Oratop)
- Please reload this page
- 58. Database Version, Bugs, How oracle gives support, My oracle support, Patching Theory
- Please reload this page
- 59. Patching Practical
- Please reload this page
- 6. Linux (Absolute path, Relative path, Read mode, Write mode, Append mode, Timestamp modification, Redirecting output to a file, Copying, Moving, Renaming, Deleting, Word Count) Commands(cal options, , cat options, cp options, mv options, rm options, wc options)
- Please reload this page
- 60. Patching of 33859214 Logs:
- Please reload this page
- 61. Linux Filesystem(EXT4, XFS, BTRFS), Logical Volume Manager(LVM), Logical Volume, Increasing space inside a VM, Creating a new logical Volume, Increasing the existing LV Storage
- Please reload this page
- 7. Permission
- Please reload this page
- 8. Linux commands(hostname, uptime, ifconfig, grep, | , vi options (:x, :wq, esc : o, esc : O, esc : s, esc : %s)):
- Please reload this page
- 9. Linux Commands. ( su, sudo, ownership change, script, processes )
- Please reload this page
- ASM
- Please reload this page
- Patching Logs
- Please reload this page