Database Administrator

Add, delete, modify, and query an Oracle 11g monitoring table Preface:The data in a table in the online Oracle database is a little messy. No change was found based on the application database log and Application log, therefore, we decided to

When the Oracle tablespace is in hot backup, the instance restart error is disabled to reproduce and solve the problem.A recent database of a customer reported an error during OPEN and needed to be restored. The reason was that a TABLESPACE was

Summary of methods for detecting Oracle data block corruption 1: Use initialization parameters You can use the initialization parameter db_block_checksum \ db_block_checking to set the database's physical consistency and logical consistency check

Mysql relay log parameter Summary MySQL generates a relay log under the home Directory when performing master-slave replication or master-slave replication. This document summarizes the definitions and explanations of these parameters. 1. What is

DBMS_REPAIR package Usage Details Oracle provides the DBMS_REPAIR package to discover, identify, and modify Bad blocks in data files. Any tool is not omnipotent. Using this package may cause data loss, inconsistent data returned from tables and

If the RMAN database fails to be restored, the RMAN database fails to be restored. Problem: This is an operation to restore the RAMN backup of a database in the RAC environment to a single database. The following error is reported when the data

Mysql DATA Export Permission There are many ways to export mysql data, such as mysqldump, mysql-e 'SQL'> file, which can easily export data. However, when using a common user to export data, an error occurred. 1 Select * into outfile

Mysql advanced permission check principle and mysql permission Principle You can perform database operations in two steps: 1. Whether the connection is permitted. The connection is based on host, name, and password; 2. Are you authorized to

Qt implements a small supermarket cash register system and qt supermarket As a contact, I plan to use Qt to develop a small cash register system. From the initial conception to the implementation of basic functions, after some time, many times other

Oracle trigger failed Routine checks on the AWR Report of the database. An update statement is executed multiple times for over 30 seconds each time. This SQL statement is very simple, that is, modifying data based on primary key conditions, the

ORACLE profile series 4 and oracleprofile Series This blog is the fourth article in the ORACLE profile series. It mainly describes how to create a profile and use it for resource and password control.CREATE PROFILE Note:Oracle recommends that you

The status of the Hibernate Persistence object.1. From the perspective of persistence,Hibernate divides objects into four states.:Persistence status,Temporary status,Free Status (off-pipe status),Delete state. The Session method can convert an

ORACLE _ Data Processing and oracle Data ProcessingZookeeper ORACLE _ Data Processing ① Data manipulation languageDML (Data Manipulation Language-Data Manipulation Language) can be executed under the following conditions:Insert data to a tableModify

How can I query my husband's call records? QQ1622863529I recommend them QQ plus (1622863529). When you add it, remember to say it was recommended by a friend. Otherwise, they may not help you. It was also the hope that my friend recommended me to

MYSQL stored procedures and events, MYSQL Stored Procedure events About the creation of stored procedures and events in mysql The following stored procedure mainly implements the function of querying the data in the table half a year ago. If yes, It

Rac_udev does not recognize a disk when installing a grid when creating a disk. rac_udevgrid Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you

Rac_grid self-check prompt pdksh-5.2 package missing, rac_gridpdksh-5.2 Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally

Shutdown abort mode: The redo is lost. Use the implicit parameter to start the database, abortredoShutdown abort ModeLoss of redo logUnable to open databaseThrough the alarm error ORA-00354: upt redo log block header from this error can be seen that

Use bbed to modify data and bbed to modify data Bbed is a powerful tool that allows us to directly modify the corresponding content from the data file without bypassing oracle. ZBDBA@orcl11g>select * from emp; EMPNO ENAME JOB

Oracle view Summary (create, query, modify, delete, etc.), oracle View View definition: -A view is a virtual table.--A view is created on the basis of an existing table. The tables on which a view is created are called base tables. -The statement