Database Administrator

1. Set the storage location of the backup file, and automatically backup the control file during Backup C: \ Documents ents and Settings \ wwang> rman target/-- backup on the target database Recovery MANAGER: Release 11.2.0.1.0-Production on Monday

1,Control File(Controlfile)Loss recovery Based on the control file's compound multi-path nature, there are two types of loss: one is the damage or loss of a control file, and the other is the loss of all control files. In the first case, you only

Control the SQL * Plus environment and Data Dictionary 1. Control the SQL * Plus Environment A) SET environment variable value B) SHOW environment variable | ALL   SQL> show all Appinfo is OFF and set to "SQL * Plus" Arraysize 15 Autocommit

InnoDB in mysql 5.5 serves as the default database storage engine, and after the mysql-5.1 upgrades mysql to the mysql-5.5, the following programs need to recompile and install the upgrade:PHP 5.3.6Cacti spinePureftp InstallWget http://dev.mysql.com/

This error occurs 1st times. During the process of installing soft on node1, When you copy file to remote node2, you can view the following logs: INFO: List of files to be excluded from: install/excludeFileList.txt INFO: Exclude file

Today, when I am developing a project about **, I am using PLSQL to connect to Oracle. However, in Myeclipse DB's attempt, the url I have been using is the following code: Jdbc: oracle: thin:127. 0.0.1:1521: Jdbh The following error message

Mysql is indeed the most popular database. Since mysql5.5.8, mysql's source code package compilation and installation have to be compiled using cmake. There is no essential difference in the compilation process, but it is much more intuitive. Mysql

ORA-06413 Connection not open. Cause: Unable to establish connection. Action: Use diagnostic procedures to ascertain exact problem Error Description: it can be connected using the Oracle connection tool, and sqlplus can be connected on the

When checking a set of DG databases a few days ago, when read only opens the stanby database, the following error log is found in alert. log: ........Wed Dec 14 15:45:19 2011Completed: alter database recover managed standby database cancelWed Dec 14

Oracle function INSTR usage: (Source string, target string, start position, matching serial number) In Oracle/PLSQL, The instr function returns the position of the string to be truncated in the source string. Only retrieval once, that is, starting

I deleted the database by mistake. The boss was very upset. I had to recover the database within 30 minutes. In a hurry, I wrote a stored procedure, which is suitable for deleting the table on the day of recovery without remembering the table

Oracle's Optimal Flexible Architecture (OFA) refers to the naming conventions and storage location rules for Oracle software and database files and folders. It can be used as a group of good habits, so that users can easily find the file structure

In the following example, two shared services, one Configuration Service and one mongos service are enabled. All these services are tested on the same server. Of course, they can also be deployed on different servers.1. Create a Shards

For RAC, the most important thing is to understand the internal principles and architecture. Installation is not very difficult. Both troubleshooting and maintenance are inseparable from the architecture and Internal principles. Cluster category 1.

121. you want to create a new optimized database for your transactional production environment to be used by a financial application. while creating the database, you want the Oracle software to take care of all basic settings to optimize the

Try installing MongoDB on Ubuntu. Fortunately, you can use apt-get on Ubuntu. However, it is not the latest version! Sudo apt-get update Sudo apt-get install mongodb After the installation is complete, the Mongodb configuration file is placed

1. Use the Oracle method to_date (); String DateStr = "1985-07-11 10:30:00. 0 "; Pstmt = conn. prepareStatement ("insert into t (d) VALUES (to_date (?, 'Yyyy-MM-DD HH24: MI: ss ')"); Pstmt. setString (1, DateStr) 2. java. SQL. Date is different

You can change a common table to a partition table in the following ways:1. Create a partition table A_NEW, which is the same as the original table;Insert A_NEW SELECT * from;Name Table A A_OLD and name A_NEW;2. Use the previously redefined method!

The restrictions on Oracle histograms often lead to headaches for many beginners-not displaying more than 32 bytes, and generating the same errors as the first 32 bytes. Since the number of DISTINCT values in the OBJECT_TYPE column is less than 254,

Error: [Oracle@www.bkjia.com data] $ exp "sys/oracle@www.bkjia.com as sysdba" file =/data/sys. dmp log =/data/sys. log full = y;LRM-00108: invalid positional parameter value 'as' EXP-00019: failed to process parameters, type 'exp HELP = y' for