Database Administrator

Restore database backup in a new environment. An error occurs during data file restoration. Environment Description: Oracle 10.2.0.3 for solaris 10, the backup database is RAC, and the recovery is performed on a single instance. The operation

The master-slave replication configuration of apsaradb for redis is quite simple. Only two sentences are required. Through master-slave replication, multiple server Load balancer instances can have the same database copies as the master server. The

Analysis process:1. tjcw database background alert alarm a large number of the following ora-00600 error alarmFri Jul 06 15:59:13 2012Errors in file f: \ Oracle \ admin \ tjcw \ udump \ tjcw_ora_3200.trc:ORA-00600: Internal error code, parameter: [61

Oracle storage structure, which can be divided into physical and logical structures. The latter is born to facilitate management of the former. Oracle stores data in tablespaces logically and physically in data files.There are two views that we may

After a data recovery, encountered the ORA-00600 kcbz_check_objd_typ_3 error, record here.First, the error kcbz_check_objd_typ_3 indicates:When Oracle checks the data block in the memory, it finds that the object number on the data block is

1. Create Table T2SQL> create table t2 (A1 number (10 ),A2 char (10) tablespace users; 2. Insert two rows of dataSQL> insert into t2 values (33, 'cc ');SQL> commit;SQL> alter system switch logfile;SQL> insert into t2 values (44, 'dd ');SQL> commit; 3

Today, a colleague asked me to say that his local database was deleted by him by mistake, so he could not open the file. Let's take a look.SQL> conn jjw/jjwERROR:ORA-01033: Oracle initialization or shutdown in progress Warning: You are no longer

After the Select statement, create index, and other sorting operations using the TEMP tablespace are completed, Oracle Automatically releases the temporary segment. However, if some temporary segments are not released, the TEMP tablespace is almost

1. Create a table T2 to insert two rows of data. If the first row of data is written into the archived log, the second row of data is in the online log.SQL> create table t2 (A1 number (10 ),A2 char (10) tablespace users;SQL> insert into t2 values (11

The following error occurs in the database of the latest User:Ioctl ASYNC_CONFIG error, errno = 11 The environment is as follows:HP-UX 11.31, Oracle 10.2.0.5.7 Metalink:Applies:Oracle Server-Enterprise Edition-Version: 9.2.0.1 and later [Release: 9.2

Last time we introduced the new feature of Oracle 11 GB-virtual columns. Today we will introduce another new feature-read-only tables. Read-Only tables are no different from normal tables, but no DML (Insert, Update, Delete) operations can be

Cancel-based Inconsistency Recovery (archive) Article 1   Cancellation-based recovery only applies to the following situations: loss of archived logs leads to full recovery failure; loss of data files and Unarchived redo logs (online redo logs );  

We know that MYSQL 5.1 supports horizontal partitioning. Let's try to optimize the query on a partitioned table.In general, the optimization principle is the same as the optimization for individual tables, ensuring that the number of scans on the

Redis is a distributed NoSQL Database System Oriented to "key/value" pairs of data types. It features high performance and persistent storage, and is suitable for high-concurrency application scenarios. It started late and developed rapidly. It has

Remote access to the mysql database:1. First, make sure that the firewall blocks the mysql database port (default: 3306 ).In Linux, you can use the following command to disable the Firewall:# Service iptables stopFor more information about how to

Only Oracle is installed in Linux, and an Oracle user is installed in Linux. The user's directory is in/home/oracle Therefore, you must use an Oracle user before logging on to Oracle. Su-oracle conversion user Sqlplus/nolog does not connect to

CRS provides many commands to manage and view the cluster service status. Common Commands include crs_stat, crs_start, crs_stop, and crsctl.  1. view the cluster statusYou can run the crs_stat command to view the status of all resources in the

1. display the lock information in the Linux Database Select sid, addr kaddr, type, lmode, block from v $ lock; SID KADDR TY LMODE BLOCK------------------------------------------------3 0000000077459298 XR 1 03 0000000077459368 RD 1 03 00000000774594

MSCA (Mobile Supply Chain Application) log collection Reference Note: 338291.1-Howto Enable WMS/MSCA Logging 1. Locate the mwa. cfg file:In 11i: $ MWA_TOP/secure/In R12: $ INST_TOP/admin/install/2. Ensure trace is enabled in the mwa. cfg file.You

These two days are busy studying postgresql. The basic usage is similar to that of other databases. I will not explain it myself. Today I want to record the postgresql cluster solution hot standby. Set the Cluster Environment myself: Three computers: