Database Administrator

In ORACLE10G, the default archiving path is $ ORACLE_BASE/flash_recovery_area. For this path,ORACLE has a limit that only 2 GB of space can be used for archiving logs by default. You can use the following two SQL statements to view the limit.1.

ORA-12545 Errors often occur when a remote client connects to the RAC database over a uniform service name. After querying METALINK, it was a small bug in Oracle.Environment: ORACLE 11G R2 RAC database, two nodes.Symptom:[Oracle @ ted35 ~] $ Sqlplus/

MySQL master-slave synchronization is a mature architecture: advantages:① The query can be performed on the slave server (that is, the READ function we often call) to reduce the pressure on the master server.② Back up data from the master server to

Chapter 3Create, update, and delete documentsInsert new document: Db. foo. insert ({"bar": "baz "}) My understanding: database. Set. insert ({key: value })Note: The insert speed is faster than that of data inserted at a time,

I use Java to connect to the MySQL database and write data through JDBC. The Chinese character string directly generated in Java is written into the database and becomes the question mark "?". Below are my records for solving this problem.First, I

Fault symptom:ERROR: 12-09-20 16:15:03 get the maximum size ERROR: CallableStatementCallback; uncategorized SQLException for SQL [{call USP_SYS_CMSCODE (?, ?, ?, ?)}]; SQL state [72000]; error code [1552]; ORA-01552: non-system tablespace 'users'

In MySQL5.5 or an older version of MySQL5.1), only one column of fields in the timestamp type can have the automatic insertion time and update time, or only one column of fields can have the automatic insertion time, the field in the other column

I just got back from Shandong and had a bunch of troubles. No, it's about to get off work. The customer says oracle rac is down.   650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131229/19233051N-0.jpg "border =" 0 "alt ="

Someone asked why SQL Server data has changed, but why is the best modification date of database files and log files not changed. In fact, this is a normal behavior.   The modification date of the SQL Server File is when the SQL Server closes the

I. Basic Information Environment: aix + ha + sybase mutual backup Cause: the same lv_tempdb name is created on the two aix servers due to the extended tempdb space. The service is switched to the same server, so that the volume group cannot be

    A: each person may have different ideas and different starting points. My starting point is to find the source and what causes lock and latch. Then explain the nature of lock & latch from different perspectives. Lock: 1. Because the business

In the forum, I encountered a problem where I could not Attach the database. The error message is:   Msg 5171, Level 16, State 1, Line2 "path \ allen_log.ldfcm not a primary database file.   Obviously, this error indicates that the file selected by

I. Configure mongodb Master/Slave using the command line [root@server11 ~]#  /usr/local/mongodb/bin/mongod --bind_ip 192.168.1.112 -port 3306 --dbpath /data/mongodb/db1/ --logpath /usr/local/mongodb/logs/server1.log  --rest --master &  [1] 144

It is very important to regularly Delete the mysql Master/Slave binlog. Generally, you can use expire_logs_days = 10 to set the number of days that binlog is retained. mysql5.0 is not supported in the current version), but sometimes this is not

A batch of data was updated last night. It took more than 20 minutes to use the old update method, but it took less than two seconds to end with merge. For details, see: Use the BIRTH field of T_TMP_SCHOOL135868) to update the BIRTHDATE field of

MySQL-mmm-two nodes (master) Architecture 650) this. width = 650; "border =" 0 "alt =" "src =" http://www.bkjia.com/uploads/allimg/131229/1Q2143928-0.png "/>In two node master-master setup, MMM uses five IPs: single permanent IP for each nodethat is

One quiet afternoon, an AIX small machine with an ORACLE database in the test environment was shut down due to an unexpected power failure. In the test environment, an engineer was assigned to solve the problem. Specifically, the server was

Go to the mysql homepage and cover all the articles about how good mysql 5.6 is. Later, I browsed the 5.6 update description, saying that replication was enhanced, and some people tested to enable replication, which had little impact on performance.

  If an archived backup set exceeds the backup retention policy, report obsolete reports that it has expired. therefore, the Backup Redundancy policy is set to 1, and the archive is backed up twice. The report obsolete command is initiated to view

1: a power outage occurred on the weekend. The newly configured Intranet Test Database active recovery uard environment is automatically disabled. The following error is reported after the master database is started this morning: [oracle@db1 ~]$