Database Administrator

This article provides a complex method to compress logs and database files. 1. Clear logs: dump transaction database name WITH NO_LOG. 2. truncate transaction logs: backup log database name WITH NO_LOG. 3. Compress database files (if not compressed,

Today to the customer data recovery, found that the use of the hidden parameter _ allow_resetlogs_upload uption, the result of a 2662 error in ORA-00600. The customer said that a data file CUUG was lost. DBF, there is only one cold backup (the

EXPDP userid = vallen/123456 @ orcl schemas = vallen directory = DATA_PUMP_DIR dumpfile = aa. dmp logfile = aa. log version = 10.2.0.1.0 Import the data to the Oracle database of version 10.2.0.1.0. Aa. dmp and aa. log will be generated in the 11g

Basic MySQL database import and export operations 1 Table tt format: Create table 'TT '('Ind 'int not null auto_increment,'Name' char (100) default NULL,Primary key ('ind ')) 2. Example of d.txt:1,2, B3, c 3. Import command:Mysql> load data infile

1. First, use a statement to query data segments with a capacity greater than 1 GB. Select segment_name, sum (bytes)/1024/1024 from dba_segments group by segment_name having sum (bytes)/1024/1024> 1000; The following result is displayed: SYS_LOB00

The two master and slave mysql database servers are upgraded to hardware. The normal server is shut down. After the hardware upgrade is completed, the server is started. It is found that the master-slave synchronization process is disabled. mysql>

Incorrect database listening status$ Lsnrctl status LSNRCTL for IBM/aix risc System/6000: Version 10.2.0.5.0-Production on 05-NOV-2012 08:54:08 Copyright (c) 1991,201 0, Oracle. All rights reserved. Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL =

Source database environment: OS: WINDOWS 7 Db version: Oracle 10.2.0.4.0 Note: This migration solution cannot be used in VERSION 10.1.0.1.0. Db user: SCOTT Dba permissions and users are requiredTarget database environment: OS: WINDOWS 7 Db version: 1

How to automatically add the suffix. US. Oracle. COM when Dblink is created in ORACLE Step 1: view the global_name Parameter Obviously, the suffix automatically added is generated here. Step 2: log on to the database as a dba and modify the

Background: Processing NULL values during sorting, In Oracle official documents, null values are a special value type in the sorting process. By default, null values are regarded as the maximum value. That is to say, during sorting, when a Null

Note: Today, when I was doing a simple add and delete query of OA, there was a time-type field (data insertion time). I thought, this field directly sets a Default Value in the Oracle database, you do not need to install the value of this field at

I learned the update statement today and the $ push modifier. The example in the book makes me puzzled. The first two parameters of update () are query and new documents. The example in the book is as follows. Find the Key in the set as Gende rather

Today, I suddenly wanted to use em to input http: // localhost: 5500/em/in IE and found that it could not be opened. Later I thought that the OracleDBConsoleorcl service was not started. So we started the OracleDBConsoleorcl service and found that

1. Read only table description Before Oracle 11g, if we want to set a table to read-only, we can grant some users the select permission. But for the table owner, it is still read/write. In Oracle 11g, we can directly set the table's read and write

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/

1. view the size of all Oracle tablespaces Select tablespace_name, sum (bytes)/1024/1024 from dba_data_files group by tablespace_name; 2. The size of the tablespace not used in Oracle Select tablespace_name, sum (bytes)/1024/1024 from

Note: you must first modify the environment variables of Oracle and root users. Vi ~ /. Bash_profle Add the following content: Umask 022 Export ORACLE_BASE =/home/oracle/app Export ORACLE_HOME = $ ORACLE_BASE/oracle/product/11.2.0/dbhome_1 Export

The flexible combination of Linux/Unix Shell and SQL variable transmission greatly improves DBA efficiency, this article provides a few simple examples of passing variables between Linux/Unix shell SQL statements for your reference. Call SQL in

Customer server environment: rhel-server-5.4-x86_64 + Oracle10g Remote Backup server Environment: windows server 2008 Network Environment: the server is deployed on the Internet, and the remote backup server is deployed on the Intranet (the server

The following describes how to query the returned dataset by page in an Oracle stored procedure: Create or replace procedure PROC_GET_DATA_PAGING (P_TABLENAME IN VARCHAR2, -- table (View) NameP_STRWHERE IN VARCHAR2, -- Query ConditionP_ORDERCOLUMN