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,

Sqlldr loads data into the database. The data in the External table is based on the operating system file, and the real data is not saved to the database, which is in the operating system file. Therefore, the data in the External table can only be

1. Explanation of imp Command Parameters [Oracle @ linux exp] $ imp help = y Import: Release 10.2.0.4.0-ProductionOnWednesday, September 16, October 5 15:48:13, 2011 Copyright (c) 1982,200 7, Oracle.AllRights reserved. By entering the

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

I. AWR usageSQL> @? /Rdbms/admin/awrrpt. SQL Specify the Report Type~~~~~~~~~~~~~~~~~~~~~~~Wocould you like an HTML report, or a plain text report?Enter 'html' for an html report, or 'text' for plain textUlts to 'html'Enter the value of

In Linux, Oracle installs the configuration of One listener for two instances: Listener. ora file, # LISTENER. ORA Network Configuration File:/opt/oracle/product/9.2/network/admin/listener. ora# Generated by Oracle configuration tools. LISTENER

One of the biggest challenges for developing multi-user database applications is to strive for the maximum concurrent access while ensuring that each user can read and modify data in a consistent manner. The maximum number of concurrent accesses

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

1. rm-f system01.dbf 2. Database disconnection Error SQL> shutdown immediateThe ORA-01116: error in opening database file 1ORA-01110: data file 1: '/u01/app/Oracle/oradata/demo/system01.dbf'ORA-27041: unable to open fileLinux Error: 2: No such

After installing mysql5.1.34 in the upgrade system, I have been too reluctant to install it. I directly downloaded a software package. Today, I took the time to compile and install this version. According to the official statement, several Versions

Create a connection >>> Import pymongo>>> Connection = pymongo. Connection ('localhost', 27017)Switch Database >>> Db = connection. test_databaseGet collection >>> Collection = db. test_collectionDb and collection are created in a delayed manner.

1. modify the configuration of remote linux machines The configuration in the vim/etc/sysconfig/i18n file is as follows:LANG = "zh_CN.GBK" SUPPORTED = "zh_CN.UTF-8: zh_CN: zh: zh_CN.GBK"SYSFONT = "latarcyrheb-sun16" 2. Modify the Oracle environment

In projects, serial numbers are often generated based on the year, month, and day rules. A simple stored procedure can be expanded as needed. I. Serial number Storage table -- Create tableCreate table SYS_GENKEY(DATESTR VARCHAR2 (50 ),Maxcount

2011.11.23 the ASM disk block of the Virtual Machine RAC results in DB ReconstructionWe just built a 10gr2 rac environment on a company's PC machine with vmware workstation8 and built it with bare equipment + ASM. After the installation is

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,

Since the level of developers is high and low, dba has limited energy, and it is impossible to solve the SQL statement problem in time! We plan to solve the slow database operation problem by imitating the methods of redo logs! 1. View

Rowid SQL statement explanation Select * from mytable2 s1 where rowid in (select rid from (select rownum r1, rid from (select rowid rid from mytable2) where rownum = 3 ); Select rowid rid from mytable2 indicates using rowid to identify mytable2

Oracle memory configuration file: % Oracle_HOME % \ ora92 \ database \ SPFILETIANCI. ORA File Actually: SPFILESID. ORA file SID is a database service Run cmd Input sqlplus/nolog Enter the conn user name/password as sysdba Copy the Oracle \

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 Hardware 8c65g About 74 I/O operations for database queries without lob The database has lob but does not query lob I/O operations about 146. The database has lob and query lob io operations

Oracle Database REAN recovery data file recovery is what we will introduce in this article. We know that apart from the system tablespace data file (mount, other data files can be restored in the open (mount) state. restoring data files in the open