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

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

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

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

You often need to know the size of an Oracle database to move it from one server to another. Or just to know if your export or whatever is going to take a lot of space and time. In this article I show you a simple way to calculate the size of your Oracle database ..read more

You should run a shell with nohup on Linux to ensure long-running tasks or processes continue to execute even if your user session is terminated or a network connection is lost. For instance, when managing an Oracle Database, you often need to execute tasks that can take a significant amount of time, such as data ..read more

In many cases you need to recover an Oracle database until time in the past or a point in time recovery because there was some kind of error or someone made a mistake. First you need to shut down the database and start it in mount state. Then you can run this command inside RMAN ..read more

When you are doing an important change to your Oracle database, you need to be able to go back to the point you were before the change in case something goes wrong. There is no better way to go back in time than with a guaranteed restore point. 1. Create a guaranteed restore point 1. Stop ..read more

When you are doing an important change to your Oracle database, you need to be able to go back to the point you were before the change in case something goes wrong. There is no better way to go back in time than with a guaranteed restore point. 1. CREATE GUARANTEED RESTORE POINT 1. Stop redo transport ..read more

You might need to get the sql_id of a Query in Oracle to troubleshoot some performance problem or just to check some stats. This is the simplest way to do it. You query v$sql with some text that you know your query contains. If you don’t find it in the query above, you can use ..read more