ORACLE

  First, We connect to the node that the database is running with ssh. We see a list of backup jobs with the following command. …

  First, we connect to the node where the database is located with ssh. After loading the database’s profile, we connect to RMAN with the …

  Extent Management Control can be LOCAL or Dictionary Based. If local, the information in the bitmaps in the datafile is used. If Dictionary Based, …

In some cases, you may need to move the TEMP tablespace to another diskgroup if there is no space left in the ASM or because …

  With the flashback database we can use the restore point to return the database to a time in the past. For more detailed information …

  Using the FLASHBACK database, we can return the database to a time or a SCN number in the past. You can think of FLASHBACK …

  With the logging_clause parameter, we can specify whether the database objects are to be logged in the redo log when they are created, using …

Before you read this article, I suggest you read the article “What is logging_clause On Oracle (LOGGING or NOLOGGING)” to better understand the concept of …

  For restart operation, we must stop and start the Oracle database. In this article we will show the below scenarios; stop an instance of …

  You can use Undo Advisor to set UNDO_RETENTION and the required undo tablespace size. You can open the Undo Advisor using the Database-> Diagnose-> …