Database Administrator

Cold backup is to copy the database-related files. It can only perform restoration operations and cannot perform restoration operations. Log on to the database, find the path for storing data files, control files, and log files, close the database,

1. Use SQL * plus to move data files SQL>SelectFILE_NAME, ONLINE_STATUSFromDba_data_filesWhereFILE_NAMELike '% Ttb %'; FILE_NAME ONLINE _ Certificate ----------------------------------------------------------------------------------------------

No matter when the process or user calls back to modify the data in the database, Oracle saves it (the data in the database) as undo data as the old value that has been modified before. This design provides many benefits for database users. Allow

/U01/app/Oracle/product/11.2.0/dbhome_1/root. sh Running Oracle 11g root. sh script... The following environment variables are set: ORACLE_OWNER=Oracle ORACLE_HOME=/U01/app/oracle/product/11.2.0/dbhome_1 Enter the full pathname of the local

# CentOS 4.7 Oracle 10.2.0.1 # Scp user @ host 10201_database_linux_x86_64.cpio/local Decompress the package to/home/oracle/database. # Cpio-ivmd ####################### # System Environment Settings ####################### 1) view the kernel

I have never been familiar with Oracle databases before, and I have been using MSSQL. Speaking of the SQL statements of these two databases, there are many differences. I cannot tell the specifics, daniel knows better than me. Here I just want to

Some people said that they would first delete a user and then create the user. I want to delete all tables under this user, but do not delete others. 1. query all tables under this user: Run the command under this user (no result, because it

1. Delete the undo tablespace Rm-f undotbs01.dbf 2. Error SQL> create table t3 as select * from dba_objects where rownum Create table t3 as select * from dba_objects where rownum *ERROR at line 1:ORA-01116: error in opening database file 2ORA-0111

This is the MySQL backup script of cainiao-level O & M. I wrote it here to take notes, and I got to know two gadgets: mysqldump/pdumpfs. The first part is mysql Data Backup. [Root @ localhost ~] # Mkdir-p/usr2/backup/mysql [Root @ localhost ~] # Vi

There are three installation methods for mysql in Linux: 1. yum/rpm 2. Source Code installation 3. Binary Installation The first installation method is not mentioned here. The upgrade method is mainly binary installation, which is very

System installation: Select as many development software as possible. X Windows is required. 1. create necessary users, groups, and directories # Mkdir-p/u01/Oracle # Groupadd dba # Groupadd oinstall # Useradd-g oinstall-G dba/u01/oracleOracle #

Data Block overview Oracle manages the storage space in the database data file. The unit is data block ). A data block is the smallest (logical) data unit in a database. The minimum physical storage unit of all data at the operating system level is

Some colleagues asked a few MySQL parameter settings. Here is a simple record: Innodb_thread_concurrency, used to limit the number of threads that can enter the innodb Layer When read_row/write_row/update_row/delete_row is called at the innodb layer,

The ebs form cannot export Master-slave relationship (Master Detail) data to EXCEL.The following describes how to solve the problem that the EBS standard export function cannot export master-slave relationship data. Solution: 1. Add an export button

Fault symptom: 15:45:29WARNING OGG-01004Oracle GoldenGate Delivery for Oracle, rora_001.prm:Aborted grouped transaction on 'realestate. JZWFCMS ', Database error 1403 ().15:45:29WARNING OGG-01003Oracle GoldenGate Delivery for Oracle,

For Oracle, Java-class functions can be used because Java JVM is built in. Usage Use pl/SQL developer: (1) Go to pl/SQL developer and select java sources: Create Enter the following code: (import can not, here to point out that the import package

Restore archived logs: select * from v $ log_history t where t. THREAD # = '1'Order by t. FIRST_TIME descInstance 1: Restore an archived log:Run {Allocate channel 'dev _ 0' type 'sbt _ tape'Parms 'sbt _ LIBRARY

1. Create a stored procedure1. Basic Syntax:Create procedure sp_name ()Begin.........End2. parameter transferIi. Call the Stored Procedure1. Basic Syntax: call sp_name ()Note: The stored procedure name must be enclosed in parentheses, even if the

When installing Oralce on Linux, you must first check whether one pair of rpm is installed. If you check them one by one each time, it will be very troublesome, so a script is simplified. This script takes only three steps: 1) Save the following

There are some differences between multi-master-slave mutual backup and master-slave replication, because the multi-master can have write permissions on the server, so it is designed to repeat the problem from self-growth. Problem (Multiple Primary