Database Administrator

The log system of the Oracle 1gR2 database changes a lot. The following describes the changes in the parameter file and adr.1. parameter fileAfter converting the spfile to pfile, we can see that the original bdump, adump, cdump, and udump settings

ORA-00257 archiver error -- archiving failed due to full data flash back System: Windows Server 2008 R2 Database Version: Oracle 10.2.0.4 This morning, an error occurred at work: ORA-00257: archiver error. Connect internal only, until

Today's duty in case of really many, mirror database a large number of rollback, can not be started normally; A database inexplicable downtime; also within a month the second encountered a ORA-600, is it time to burn incense.Or simply record this

SQL> conn sys/system @ jytest as sysdbaERROR:ORA-12537: TNS: connection closed 1. The processes parameter is too small.Go to the settings processes method:The relationship between Oracle sessions and processes isSessions = 1.1 * processes + 5Use sys

Environment: Sys @ ORCL> select * from v $ version where rownum = 1;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-ProdSys @ ORCL>! Uname-Linux localhost. localdomain 2.

Today, when sqlplus is used ========================================================== ======== ERROR:ORA-28002: the password will expire within 7 days ========================================================== ======== The system prompts that the

I. header files When introducing the header file of the informix database, you can use the following method: Exec SQL INCLUDE sqlca;Exec SQL INCLUDE sqlda;Exec SQL INCLUDE sqlhdr;Exec SQL INCLUDE decimal;Exec SQL INCLUDE locator;Exec SQL INCLUDE

Cause: zabbix may monitor the running status of the mysql service, but cannot monitor whether the master-slave replication of mysql is normal: Sometimes the synchronization has stopped, but the Administrator does not know. Start: log on to the mysql

Kill Session Before using drop user cascade, kill session is usually used to terminate the currently connected session. However, if a long running transaction has not been committed, it usually takes a long time to kill a session. In addition, it is

1. Place the check script on the monitored machine (Mysql Slave: /Usr/local/zabbix/bin/check_mysql_repl.py #! /Usr/bin/python # Coding: UTF-8 Import MySQLdb Import sys Class check_mysql_repl (): Def _ init _ (self ): Self. dbhost =

1. Use mysqldump to back up mysql logically, and use binary log backup for Incremental backup. 2. Use lvs snapshots to achieve almost full hot backup from the physical point of view, and use binary log backup for Incremental Backup 3. Use percona's

When you use insert into select to load data in batches, the entire insert statement cannot be executed because some data does not meet the loading conditions. In this case, you can use the DML Error Log feature to solve this problem. You only need

Temporary Tablespace Temporary Tablespace is used to store instantaneous data, which can be viewed only during session connection. Permanentobject cannot be created in temporarytablespace. Space utilization principle: It will not be monitored or

1. Installation preparation [Root @ chen download] # tar zxvf mongodb-linux-x86_64-2.2.0.tgz [Root @ chen download] # cp mongodb-linux-x86_64-2.2.0/usr/local/mongodb-r 2. Create Database folders and log files [Root @ chen download] # mkdir/usr/local/

SQL> alter database begin backup; -- start to back up the databaseDatabase altered. SQL> host cp/u01/Oracle/oradata/ORCL/*. dbf/u01/oracle/dump1/-- power-off before execution, abort Problems occurred when restarting the database[Root @ station88 ~] #

Mr. Huang took an SQL statement and asked me if I could optimize it. After reading it, the data volume is not large and the query is not complex. The record optimization process is as follows:DB: PostgreSQL 9.1OS: CentOS 6Count

To meet this requirement, the query number ends with 11 and cannot contain "4" from the fourth to the eighth digit. It was initially assumed that Oracle and SQL server support the same [^ 4], if I have checked a lot on the internet, it also means

Oracle conn protocol adapter error-Solution C: \ Documents ents and Settings \ administrator> set oracle_sid = myoracle C: \ Documents ents and Settings \ administrator> sqlplus/nolog SQL * Plus: Release 10.2.0.1.0-Production on Wednesday December 26

Experience summary: Online logs are classified into current online logs and non-current online logs. the corruption of Non-current online logs is relatively simple. Generally, you can solve the problem by using the clear command. Corrupt non-current

The reset log option is used when the database is opened for the first time in the following cases: 1. Incomplete recovery 2. Backup control file-based recovery 3. create controlfile... RESETLOGS The primary role of log resetting is to Discard