Database Administrator

I. Site Information: Oracle dual-host Hot Standby using RoseHa. The database version is 11.2.0.1.0 (64-bit) and the operating system is 64-bit windows2008. In the company's test environment, you have retained the archived logs for the last month

First: Create a new sequence and define the starting value, value-added size, and maximum value. Generally, auto-increment is used to increase from 1 to 1. Assume that the new sequence is named MY_SEQ. Second: Create a trigger Create or replace

SQL Server cannot restart the Server to find the following error in the error log: Operating system error 1117 (unable to run this request due to an I/O device error .) On file "C: \ Program Files \ Microsoft SQLServer \ MSSQL10.MSSQLSERVER \ MSSQL \

DDL operations are very cautious when running a system online. To prevent unnecessary misoperation, you can use DDL triggers to disable DDL operations on some tables. You can use the raise_application_error function to disable the operation on the

1. Execution per minute Interval => TRUNC (sysdate, 'mi') + 1/(24*60) Or Interval = & gt; sysdate + 1/1440 2. daily scheduled execution Example: Execute at every day Interval => TRUNC (sysdate) + 1 + 5/(24) 3. scheduled weekly execution For

Starting from Oracle 9i, Oracle uses spfile by default to start the database. spfile must be created by pfile. The new spfile will take effect the next time the database is started. Pfile is the Initialization parameter file (Initialization

Instance and database startupShows the statuses from the last full shutdown to the startup of the database. When the database is started, it goes through three statuses: 1. Enable the instance (nomount)The instance is started but not associated

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> Allocated channel: t11 Channel t11: sid = 824 instance = ncdb1 devtype = DISK   Allocated channel: t12 Channel t12: sid = 838 instance = ncdb1 devtype = DISK   Allocated

I. Hardware requirements 1. Memory & swap Minimum: 1 GB of RAMRecommended: 2 GB of RAM or more Check memory # grep MemTotal/proc/meminfo # grep SwapTotal/proc/meminfo 2. Hard Disk Since CentOS is installed almost 4 ~ 5 GB, plus Oracle and so on, so

When writing code, if you need to understand the transfer relationship between Oracle's role, that is, if role A exists, you can grant A to B through grant B to C. then I want to know which role has the permission in all role. I found a recursive

Recently, the company's MySQL architecture has been upgraded, from the original one-master-many slave to the DRBD + Heartbeat dual-master-many slave, and a new e-commerce website project is coming soon, DRBD + Heartbeat dual master and one slave are

When developing Oracle SQL or PL/SQL programs, we often encounter the need to convert the string type to the DATE type. We will use to_date to implement this conversion requirement. But sometimes this conversion will go wrong and the ORA-01843: not

Mongo is a high-performance, open-source, and non-pattern document-based database. It can be used in many scenarios to replace traditional relational databases or key/value storage methods. Mongo is developed using C ++ and provides the following

Data transfer is a common problem in system deployment. How can we achieve efficient transfer and transmission of massive Oracle Data? The following describes how to deploy the postal resource visualization system. I. Use a tablespace for

Objective: To clone the database from the production database PROD to the TEST Database Environment: the PROD/TEST database already exists, and the PROD data file is on the tape; 1. Edit the pfile file of the TEST database; Delete all data files in

You can use the package dbms_metadata.get_ddl to view a table or table space DDL. Detailed parameters of the get_ddl function in the dbms_metadata PackageThe GET_DDL function returns the DDL statement of the original data of the created object. The

Stored Procedure with returned values (list result set)Case: Write a process, enter the Department number, and return the information of all employees of the Department. The analysis of this question is as follows:Since Oracle stored procedures do

The customer database encountered a ORA-600 (504) error where 5th of the error parameters were row cache objects. Previously I encountered a related latch for a shared pool: Error message: Wed Apr 18 06:03:41 2012 Errors in

1. Add the JNDI configuration file to the Project Xmlns: xsi = "http://www.w3.org/2001/XMLSchema-instance" xmlns: aop = "http://www.springframework.org/schema/aop"Xmlns: tx = "http://www.springframework.org/schema/tx" xmlns: jdbc =

1. View MySQL database Character Set Mysql> show variables like "% char % ";----------------------------------------------------| Variable_name | Value |----------------------------------------------------| Character_set_client | utf8 ||