Scribd
Upload
4 views3 pages

Oracle Database Architecture and Management Guide

The document outlines key concepts and processes related to Oracle Database architecture, including SGA, PGA, control files, and the differences between physical and logical database structures. It details installation steps, backup types, recovery methods, and the functionalities of Oracle RAC and Data Guard. Additionally, it covers database management practices, performance monitoring, user management, and troubleshooting strategies.

Uploaded by

venkatesh1989oct
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
4 views3 pages

Oracle Database Architecture and Management Guide

The document outlines key concepts and processes related to Oracle Database architecture, including SGA, PGA, control files, and the differences between physical and logical database structures. It details installation steps, backup types, recovery methods, and the functionalities of Oracle RAC and Data Guard. Additionally, it covers database management practices, performance monitoring, user management, and troubleshooting strategies.

Uploaded by

venkatesh1989oct
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

Explain Oracle Database architecture.

What are SGA and PGA? Components of SGA.

Difference between physical and logical database structure.

What is a control file and why is it important?

What happens during database startup and shutdown?

Explain different Oracle background processes.

Steps to install Oracle database on Linux.

How do you create a database manually?

Difference between DBCA and manual database creation.

What pre-requisites do you check before installation?

How do you configure listener and TNS?

What types of backups are available in RMAN?

Difference between hot backup and cold backup.

What is ARCHIVELOG mode, and why is it required?

How do you perform full database recovery?

Steps to recover:

Lost datafile

Lost control file

Lost redo log file

What is RMAN catalog?

Difference between restore and recover.

What is point-in-time recovery (PITR)?

Have you performed database cloning using RMAN?

How do you validate RMAN backups?

Difference between exp/imp and expdp/impdp.

Types of Data Pump exports.

How do you perform schema-level and table-level exports?

How do you troubleshoot Data Pump job failures?

What is a directory object?

Have you used Data Pump for backup and recovery?


What is Oracle RAC, and why is it used?

Difference between Single Instance and RAC.

Explain RAC architecture.

What is Clusterware?

What is Voting Disk and OCR?

How do you check RAC status?

What is SCAN listener?

How do you add or remove RAC instances?

What is cache fusion?

How do you manage RAC using SRVCTL?

What is ASM, and why do we use it?

Difference between ASM and file system.

What are ASM disk groups?

Explain normal, high, and external redundancy.

How do you add or drop ASM disks?

What happens when an ASM disk fails?

How do you check ASM space usage?

What is Oracle Data Guard?

Difference between Physical and Logical Standby.

Explain Data Guard architecture.

How do you configure a Physical Standby?

What is redo transport services?

Difference between SYNC and ASYNC?

What is switchover and failover?

How do you monitor Data Guard?

What issues have you faced in Data Guard?

What is a PSU patch?

Steps to perform Oracle database upgrade.

Pre and post-upgrade checks.


What tools have you used for upgrade?

How do you rollback a patch?

How do you apply patches in RAC?

How do you manage tablespace growth?

What is AUTOEXTEND?

How do you find top space-consuming objects?

How do you handle tablespace full issues?

How do you monitor database performance?

What is AWR and ADDM?

What steps do you take when database is down?

How do you handle alert log errors?

How do you troubleshoot archive log full issues?

How do you handle hung sessions?

What is your approach during production incidents?

How do you communicate during P1 incidents?

Explain your 24×7 support experience.

How do you create and manage users?

Difference between roles and privileges.

What is profile, and why is it used?

How do you handle password expiration?

How do you audit user activities?

You might also like