Database Administrator

Download patches from Metalink Log onto Metalink (https://support.Oracle.com) and Oracle users can use ARU to download it. Click the Patches & Updates tab. In the "Patch Search" area, enter your Patch number, Search, After finding your Patch, pay

When installing small patches in the RAC environment, you can use Rolling installation to provide uninterrupted business applications! When installing the patch, stop a database instance, install the patch on this node, start the instance, stop

Oracle learning can be implemented and maintained independently. Of course, optimization is a long time-consuming experience and requires more experience. The following are some online materials that you can find. In general, SQL statements are

Using RMAN to fix the issue based on time points, the strange thing is that, after setting nls_date_format, you cannot log on to RMAN?Symptoms: C:> set NLS_DATE_FORMAT = 'yyyy-MM-DD HH24: MI: ss' C:> rman nocatalog target rman/rman @ test Recovery

Connection query is a frequently used query method in database query statements. The following describes how to query connections based on the official documents provided by Oracle: 1. Connection Type: 1) Unique oracle connection types: A.Equijoin

First article on Restoration Based on SCN 1. Check the SCN number before deleting the data: SQL> col name format a45 SQL & gt; set line 300 SQL> select name, checkpoint_change # from v $ datafile_header;   NAME CHECKPOINT_CHANGE # -------------------

I.Description A friend's library cannot be opened. The error message is as follows: Errors in filef: \ app \ administrator \ diag \ rdbms \ orcl \ trace \ orcl_ora_assist.trc (incident = 89062 ): ORA-00600: Internal error code, parameter: [4194], [78

In the traditional undo management mode, Oracle treats undo and data block equally. There are three drawbacks: 1) at the beginning of the transaction, the segment header for storing the transaction table is not in memory, and the server process

NoSQL products are getting increasingly popular. NoSQL products are generally developed with high performance and high performance.ScalabilityHigh Fault Tolerance is everyone's praise. When we ask why NoSQL becomes popular, we may ask why these

Navicat Oracle features an intuitive GUI and provides powerful visualization tools such as query editor and syntax highlighting capabilities when previewing SQL, SQL console, text, hexadecimal and BLOB view/Editor, SSH tunnel and more to improve

I received a call from my colleague at home, saying that the database could not be connected. The following error was reported during connection: ORA-12516: TNS: The Listener cannot find the available handler that meets the protocol stack

The quick refresh mechanism of Oracle materialized view is completed by materialized view logs. How can Oracle quickly refresh multiple materialized views through a materialized view log? This article briefly describes the refresh principle. For

You can use the FORALL statement to Perform Batch INSERT, UPDATE, and DELETE operations in Oracle. Syntax: -- Syntax 1: FORALL subscript variable (can only be referenced as subscript)INLower limit... Upper Limit SQL statement;-- Only one SQL

I. Reserved Area Loading and aging of large objects without PIN will cause fragments in the sharing pool. Oracle wants to solve this problem. It opens up a region in the sharing pool, all objects larger than 4400 bytes will be allocated space in

I. cursor Let's talk about the concept of cursor first. From the perspective of the Oracle database administrator, cursors are collectively referred to as executable objects stored in the database cache. An SQL statement is stored in the database

I. Basic Configuration: 1.ToRootLogin, MountLinux isoFile [Root @ Oracle ~] # Hostname Oracle.junjie.com [Root @ oracle ~] # Cat/etc/sysconfig/network NETWORKING = yes NETWORKING_IPV6 = no HOSTNAME = oracle.junjie.com [Root @ oracle ~] # Ifconfig

Overview of Oracle flash deletion and recycle bin In earlier versions of the Oracle database, if a table is mistakenly deleted, the database must be restored to the previous time to restore the deleted table. This process is usually time-consuming

For RAC, when an Oracle Instance fails, the application has several high-availability technologies to ensure availability. These technologies are transparent to the client, and the client may not be able to perceive the instance failure. 1.

Add a log group in Oracle and some commands for log members1. Add a log group: Alter database add logfile group 4'/oradata/oracle/oradata/oracle_sid/redo04.log 'size 100 M; 2. Change the log group size ( First, check the archiving status: SQL>

Cause: For non-important files, it usually does not cause the instance to crash. Oracle will take these damaged data files offline and make their content inaccessible, but the rest of the database should be open. Damaged important data files can