Shailesh Suvarna - SHARP DIGI | Technologist

In SQLPLUS : Control Files:-  show parameter control_files ; Dump Location:- show parameter dump ;  select * from v$diag_info ;  In  RMAN : List Backups:-  list backup of database summary; select SESSION_KEY, INPUT_TYPE, STATUS, to_char(START_TIME,'mm/dd/yy hh24:mi') start_time, to_char(END_TIME,'mm/dd/yy hh24:mi') end_time, elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS order by session_key; select file#, incremental_level, completion_time, blocks, datafile_blocks from v$backup_datafile where incremental_level > 0 and blocks / datafile_blocks > .5 order by completion_time; Verify Logical backup with Physical Backup:- crosscheck backup; Take Full Backup:- backup as backupset database plus archivelog; backup incremental level 0 cumulative database plus archivelog;  backup incremental level 0 database plus archivelog; 

Oracle Database is a popular relational database administration system. It has various advantages, including high availability, scalability, and security. This blog post will go through how to install Oracle Database software on a Windows computer. This step-by-step instruction is intended for novices who are installing Oracle Database software for the first time. Step 1: Examine the System Requirements You must check that your system fulfills the minimal requirements before installing Oracle Database software. On their website, Oracle provides a thorough list of system requirements. You can verify the requirements for your Oracle Database version and operating system. Step 2: Get the Installation Media The following step is to obtain Oracle Database installation media from the Oracle website. The programme is available for download via the Oracle Technology Network (OTN) website. To get the software, you must first register on the website. After you have registered, you may download t...

More Info  >> here << ⬆️⬆️⬆️⬆️⬆️⬆️⬆️

As an Oracle DBA, understanding memory architecture is crucial to ensuring optimal performance of your database. Memory architecture refers to the way memory is allocated and used in a system, and it plays a critical role in the overall performance of the database. In this blog post, we will explore memory architecture in Oracle databases and discuss best practices for memory management. Oracle Database Memory Architecture Oracle databases use a multi-tiered memory architecture to manage database operations efficiently. The three main tiers are: System Global Area (SGA) The SGA is a shared memory region that contains data and control information for the database instance. It is the most critical memory area in the database, and its size can significantly impact performance. The SGA consists of several components, including the buffer cache, shared pool, large pool, and Java pool. The buffer cache stores data blocks read from disk to reduce disk I/O operations. The size of the buffer ca...

For students who are interested in pursuing a career in technology, Oracle Academy Student Hub provides a comprehensive instructional platform. This platform offers students a variety of educational tools, such as online classes, workshops, and certificates, to assist them in developing the expertise and abilities required to thrive in the technology sector. You Can Join Link . The popularity of Oracle Academy Student Hub among students can be attributed to a number of factors. First off, the site provides a huge selection of classes on a range of tech-related subjects, such as database administration, programming, and cybersecurity. These classes are designed to be interactive and interesting, with an emphasis on real-world situations and practical application. Second, Oracle Academy Student Hub provides industry-recognized credentials. These certificates can provide students a competitive edge in the job market by enabling them to show prospective employers their knowledge and abilit...

Database Writer (Mandatory Process) Writing changed database blocks from the buffer cache to the disc in Oracle Database is done by the Database Writer (DBW) process. To make sure that the database updates are saved to a disc, it runs continually in the background. By lowering the likelihood of data loss in the event of any breakdown, the DBW procedure aids in maintaining the consistency and durability of the database. To achieve effective database operations, the DBW process must be monitored and tuned for maximum performance. Log Writer (Mandatory Process) The redo log buffer is written to disc by the Log Writer (LGWR) process in Oracle Database. The database updates are kept in the redo log buffer until the LGWR procedure writes them to the disc. The redo log file, which may be utilized for recovery in the event of any failure, is created as a result of the LGWR process, which makes sure that all database changes are recorded. The integrity and consistency of the database are crucia...