Database Administrator

1. Create a test tableSQL> create table dump (id number, name varchar (20 ));Table created.SQL> insert into dump values (1000, 'tomsh ');1 row created.SQL> insert into dump values (1001, 'dumpceshi ');1 row created.SQL> commit;Commit complete.2.

Background: 1) When we take a disk offline in case the disk is already upted or database is not able to read or write from the disk. in case of Oracle database 10 Gb, oracle engine use to balance the other disks with the content of offline disk.

-- The archive log file of the test database has been accidentally deleted. The solution is as follows: RMAN> backup as compressed backupset database plus archivelog delete input; Start backup from 24-2-12The current log is archived.Use channel

1. Full database backupRMAN> run {Allocate channel c1 type disk maxpiecesize = 500 m;Backup current controlfile format '+ dgasm/backup/ctl _ % d _ % s ';Backup full database format' + dgasm/backup/db _ % d _ % s _ % p _ % T ';SQL 'alter system

(1) show parameter db_recovery; view the Oracle flash recovery target and recovery zone sizeSQL> show parameter db_recovery;NAME TYPE VALUE-----------------------------------------------------------------------------Db_recovery_file_dest

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

Index performance: 1. Do not design fields such as char (100) as indexes. 2. The number of Index fields cannot exceed 3 3. The Index will also be locked, which may cause performance problems of new locks. 4. Try to avoid using indexes. Index is

HBase is a Hadoop database that provides random, real-time read/write access to big data. It is an open-source, distributed, multi-version, column-oriented, and storage model. I will first explain the overall structure of HBase, for example: HBase

HEXTORAWSyntax: HEXTORAW (string)Function: converts a binary value represented by a string to a RAW value. string should contain a hexadecimal value. every two characters in String indicate one byte in the result RAW .. HEXTORAW and RAWTOHEX are two

Oracle build DB-LINK Test conditions Two servers Remote: IP: 192.168.0.18, SID: usertest, usertest, password: 123456 Local: IP: 192.168.8.90, SID: wjn, Username: userwjn, password: mosquito0 Parameter settings 1. view the database

The order of stopping the Oracle Applications service is: Stop application product services and then stop database services; The sequence for starting Oracle Applications services is to start database-related services and then start application

I.Test Environment SQL> select * from v $ version where rownum = 1; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release11.2.0.3.0-64bit Production SQL> create table

Oracle Database Synchronization The test is successful between two oracle databases. The following is a summary: Requirements: There are two oracle database servers A and B (A and B can be on the same Intranet or two independent machines on the

I suddenly thought of testing the real I/O capabilities of the database. Although the hardware engineer has a set of methods to test IOPS, Oracle also launched the ORAXXX test tool. in the actual application environment, IOPS is affected by table

In Oracle 10g logical standby mode, if the master database fails, the slave database can be quickly switched to the master database. Refer to chapter 7.3.2 Failovers Involving a Logical Standby Database in the oracle official document. The

A.1Full database backup. Command: Mysqlbackup-- Defaults-file =/home/mysql-server/mysql3/my. cnf -- user = root -- password = root -- databases = "mysql total2" -- with-timestamp -- backup-dir =/home/mysql-server/backup Parameter description: --

The preceding figure shows the unified database cluster. OLTP on the top left adopts shared storage and memory convergence technology. similar to Oracle RAC. the only difference is that there are independent node Management Servers and node

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

The restore node reports an error on DP 6.1 linux Client because the backup node configuration cannot be saved. The following method can be used to solve the problem, it is to rename the upper-case configuration file on the Cell Manager to the lower-

Oracle Database WEBDB performs a remote recovery test of backup in a new server environment, and an error of "ORA-01861: literal does not match format string" occurs when a data file is restored. This error is not caused by incorrect setting of the