
Root Fan
19 FOLLOWERS
Covers articles related to Apache, Firewall, Linux, Oracle, Postfix, Security, and Ubuntu. Root Fan is a Oracle High Availability and Linux Blog.
Root Fan
2M ago
Smart Scan is a feature in Oracle’s Exadata platform that allows certain types of operations to be offloaded from the database server to the Exadata storage servers, dramatically improving performance by reducing the amount of data that needs to be transferred between storage and the database server. Key aspects of Smart Scan include: By reducing ..read more
Root Fan
2M ago
Hybrid Columnar Compression (HCC) is an advanced compression technology introduced by Oracle, particularly designed for environments like Oracle Exadata. Unlike traditional row-major format databases, HCC organizes data in a column-major format within storage units known as Compression Units (CUs). This format allows Oracle to compress data more efficiently, improving both storage utilization and query performance ..read more
Root Fan
5M ago
To duplicate an Oracle database with backups you have taken with RMAN there are several ways to do it. Make sure to have a full backup of the source database. The backups are located at: /home/oracle/backup The first method I will show you is with a minimal pfile, only the db_name. The second method will ..read more
Root Fan
6M ago
You can use this RMAN script to create a backup of an Oracle database and save it to a specified destination. It is important that the BACKUP_BASE_PATH exists and the ORACLE_SID is replaced in the script. The script will create a folder inside of BACKUP_BASE_PATH with the ORACLE_SID. You can also add these 2 lines ..read more
Root Fan
6M ago
Starting with Oracle Exadata X8M-2, Oracle Linux KVM is the virtualization technology for systems that use RoCE Network Fabric. Here are some of the most used vm_maker commands to manage a domain or virtual machine (domU) on Exadata. 1. How to show the running domains on a dom0 2. How to show the memory assigned to each domain 3. How ..read more
Root Fan
9M ago
Huge Pages in Oracle are a memory management feature that allows the operating system to handle large memory pages, typically 2 MB in size, as opposed to the default small memory pages, which are typically 4 KB in size. By using larger memory pages, Huge Pages can significantly reduce the overhead associated with managing memory ..read more
Root Fan
1y ago
In this article I show you how to backup your database using a bash script. You will use 3 files for the RMAN backup. You execute it like that to generate a level 0 backup for your SID: For level 1 backup you should execute it like that If you want to backup all databases ..read more
Root Fan
1y ago
Oracle Clusterware is a software component provided by Oracle Corporation that enables the management and coordination of multiple servers in a cluster environment. It provides high availability and scalability for Oracle databases and other applications by allowing multiple servers to work together as a single system. Oracle Clusterware handles tasks such as node membership, resource ..read more
Root Fan
1y ago
srvctl, the Server Control Utility, is an indispensable tool for Oracle cluster management. It offers centralized control, ensuring operations are executed efficiently, consistently, and securely. Seamlessly integrated with Oracle Clusterware, srvctl streamlines tasks, reduces human errors, and upholds best practices, making it the optimal choice for administrators seeking precision and reliability in cluster management. srvctl ..read more
Root Fan
1y ago
If you need to run the same query on all the databases hosted on your server, you could use this bash script. The script checks all Oracle instances in /etc/oratab, but it skips any lines commented. It also skips all ASM instances. You should create a script with the query you want to run and ..read more