Database Administrator

1 PrefaceStarting from the basic principles of Oracle databases, this article discusses in depth the basic principles of online ORACLE database backup and provides a method for remote replication of ORACLE databases, that is, the implementation of

Shutdown database (do not use shutdown abort to force shutdown), implement a file-level backup, back up all Oracle related files, including Windows system files, system status and Oracle program files and data files. This cold backup is critical for

Today, we will learn how to operate on the MYSQL installed by default in Red Hat LINUX9.Let's start from the start.Start MYSQL:#> Service mysqld startLog on to MYSQL:#> Mysql-u root-pNote: Here-u represents the user name, while root represents the

Note: To install the linux component, select the everything swap partition to be greater than 4 GB. Otherwise, the installation may be inexplicable.When the installation prompts that two. sh scripts are run. Be sure to open a single window and run

++ Creates user hillary with the password window. The default tablespace is users and the temporary tablespace is temp.Create user hillary identified by window default tablespace users temporary tablespace temp;++ Delete a userDrop user user_name

About Oracle 10 Gb performance, the most talked about is the new automatic workload repository (AWR) features and proactive performance monitoring through automatic database Diagnostic Monitoring (ADDM. They are widely reported as an alternative to

1. Add a login user and group for 'mysqld 'to run as: Add a login user and group for 'mysqld'Shell> groupadd mysqlShell> useradd-g mysql2. ExtractShell> gunzip | mysql-5.0.15.tar.gz | tar-xvf-Shell> cd mysql-5.0.153. Configure the release and

1) The so-called zys font, is-misc-ZYSong18030-, the so-called tlc font, is-tlc-song -. Zys comes with RedHat AS3_U6. You need to download the Turbo Linux font from the Internet, install it, and search for it. The common versions are 1.4-13 and 1.5-1

After the server is created, create a database and run dbca to start the creation interface. The content is similar to the previous one. If you are familiar with the Oracle structure, we recommend that you customize all the options by yourself. This

In Oracle, how does one add time? Today, due to project requirements, I am responsible for writing the stored procedures in Oracle. I have never touched on it before. This is a very good learning opportunity and a good grasp! However, you may

Q: How is the current_scn of Oracle10g calculated?A: We know that Oracle10g introduces current_scn in the v $ database view. This SCN comes from the underlying table and represents the current SCN. in Oracle9i, we can use

I am not using mysqldump for backup, because it is used to back up the MYSQL database on the server, as long as all files under DATA are copied directly. Install MYSQL in E: \ PHPsetup \ mysql \ data, and store the backup file D: \ beifen \ 1; D: \

I. Overview Object statistics describe how data is stored in the database. For example, how many rows of data exist in a table and the maximum value of a column. This information helps the query optimizer find the correct and efficient execution

Idea: PLSQL depends on OCI. DLL and some other Client files. Therefore, you must provide the. Environment Variable TNS_ADMIN to find LISTENER. ORA and tnsnames. oRA to establish a connection. Steps: 1. Install Oracle_client 2. Go to PLSQL to set the

System: AIXDatabase Version: 10.2.0.3 The following error is reported:Tue Jan 15 04:08:18 2013Errors in file/Oracle/admin/RASDB/udump/rasdb_ora_766202.trc:ORA-00600: internal error code, arguments: [kcbnew_3], [0], [8], [1639086], [], [], [], [], []

1. Create the original dblink statement: Create public database link db_lsxy Connect to lsxy identified by lsxyUsing '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192. xxx. xxx. xxx) (PORT = 2261) (CONNECT_DATA = (SERVICE_NAME =

Method 1: sqlplus "User/password as sysdba" sqlplus "sys/sys as sysdba"Method 2: sqlplus/nolog SQL> conn/as sysdbaSQL> shutdown immediate;SQL> startup mountSQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES =

1. view the basic attributes of the database:SELECT dbid database number, name database name, db_unique_name global name, created creation time, log_mode archive mode, open_mode access mode, platform_name version type FROM v $ database; 2. view the

In Oracle, four lobs types are available: blob, clob, bfile, and nclob. The following is a brief introduction to the lob data type. Blob: Binary lob, Which is binary data. It can be up to 4 GB and stored in the database. Clob: character lob,

The default number of connections in Oracle XE seems to be 40. If the process exceeds this number, the request for a connection again will be rejected. 1. Log On with the system user: Sqlplus system/password @ xe 2. Run the following command: