Database Administrator

RMAN -- Differences Between obsolete and expired If you can understand the sources of the two States, You can naturally understand the differences; EXPIRED status: This status is related to the crosscheck command. The crosscheck backup command

How to archive log files when using RMAN backup I went to a customer yesterday to deploy RMAN backup. when I ran the shell script, I was prompted that I could not find the archive log, because the customer only performed EXPDP logical export backup

Physical machines connect to virtual machine databases and Physical Virtual Machine DatabasesStep 1: ping the virtual machine and the physical machine to open the virtual machine, and thenVirtual Machine ip AddressNow the physical machines and

SQL Server System table and SQL Server System Table Stores all the system information of SQL. Stores metadata related to database services (for example, user databases on the data server, logon accounts on the database server, and tables on the

How to set the mysql root Password and mysqlroot PasswordHow to set the mysql root Password:1. The initial password for installing root for the first time is blank. Note that there is no password. Press enter to enterD: \ wamp \ bin \ mysql \ mysql5.

[Read-Only tablespace -- restore-1], read-only table --- 11> Read-Only --- backup read-only fault read-only restoration of faulty data files2> Read-Only --- backup read-only writable fault recovery backup data files, recover3> Read-Only --- backup

Huge pages Series 3, hugepages Series Use the following shell script to calculate the large page configuration parameters. Make sure that the data instance has been started before using the script, If the database version is 11 GB, check whether

Kettle-engine.jar and log4j. jar package conflict problem solution, log4j. jar Java to call kettle, reference the kettle-engine.jar in lib, log4j. jar package, test found that with the kettle-engine.jar package, log can not be written to the log

Ora-7445 [PC: 0x103E2AFA0], dbca0x103e2afa0Install Oracle Rac on AIX 7100-02-03-1334. Both grid and oracle have been installed. However, dbca database found crash, the following is the database creation of the alert. log, the database reported ora-07

High Performance MySQL Reading Notes (on), high performance mysqlHigh Performance MySQL is a classic book. From the application layer to the database to the hardware platform, all the tuning techniques and common problems are mentioned. Various

Use LinQ to query data objects, and use linq to implement data objects. As a result of project requirements, I have come into contact with LinQ. After some time of study, I have a simple understanding of LinQ. This article will briefly describe this

DynamoDB, amazondynamodb I originally wanted to write processes, threads, lightweight threads, goroutine, and coroutine. Why do I list goroutine separately because it is not a coroutine and all translation into coroutine is a concept of stealing,

JDBC data source and connection pool, jdbcJDBC data source and Connection PoolThe database connection pool is used to create enough database connection pools when the application starts.A free connection can be obtained through the data source when

Oracle (+) connector usage, oracle connector usage In the Oracle PL-SQL, left and right connections can also be implemented as follows Example: SELECT stu_name, class_nameFORM students, classesWHERE students. classid (+) = classes. id The

Oracle rman recovery from different machines and oracle Lerman recovery   Oracle source host Oracle target host Host Platform CentOS6.2 (final) CentOs6.2 (FInal) Host Name Vick Rman IP address

The five most common problems that cause the RAC instance to crash, the rac instance to crash Five most common problems that cause the RAC instance to crash (Document ID 1549191.1)   Applicable: OracleDatabase-Enterprise Edition-version 11.2.0.1

Compare and test the efficiency of inserting massive data into the database, and compare and test massive data volumes Abstract: Using. NET related technologies to insert massive data into databases is a common operation. This article compares ADO.

MySQL floating point type, mysql floating point type MySQL floating-point and fixed-point types can be expressed by the type name plus (M, D). M indicates the total length of the value, and D indicates the length after the decimal point, M and D are

"Unable to locate the update row" is reported when MYSQL is updated using ADO. Some values may have been changed after the last read. This strange error occurred when I used ADO to connect MYSQL to update data through ODBC in DELPHI today: the row

Several items to be set for PowerDesigner and several items for powerdesigner After installing PDM, You need to design several items for easy use. 1. Do not associate the name with the code automatically. We do not want the associated code to change