Database Administrator

In work, we need to use Datastage to import Oracle Data to DB2. We found that IBM's documents are not comprehensive,I asked a lot of people, including my colleagues, such as Lao du, Bryan Zhang, and Robert, to finally connect to Oralce. I just made

Environment:OS: Red Hat Linux As 5DB: Oracle 10.2.0.4 Today, a developer deleted all the data in a table, because it was not a long time before the undo space was overwritten, And the undo space was restored. the recovery process is simulated as

Oracle is installed on Linux in the Virtual Machine. Since PL/SQL Developer is used on Windows physical machines to connect to Oracle in the virtual machine,But I don't want to reinstall Oracle on the Physical Machine (too big, no more =. = ).

SCN-based recovery, article 2   1. Check the current SCN to facilitate data loss in the future for restoration: SQL> select current_scn from v $ database;   CURRENT_SCN ----------- 1511297   SQL> select file #, checkpoint_change # from v $ datafile;

Enterprise-levelDatabaseMost applications are deployed inRAIDThe disk array server can improve the disk access performance and implement fault tolerance/disaster tolerance.RAID (redundant disk array) is simply an array made of cheap hard disks. The

Today, a student found a problem when building a master-slave environment. Thanks @ 80 s. Symptom: Slave_IO_Running stops on the slave database. Last_Error is shown as follows: Bin/mysqlbinlog: Character set '# 45' is not a compiled character set

1. Error 1: the RBS and TEMP tablespaces cannot be created. IMP-00017: following statement failed with Oracle error 1119:"Create tablespace" RBS "DATAFILE 'd: \ ORACLE \ ORADATA \ ORCL \ RBS01.DBF 'size 5""45259520 autoextend on next 5242880 MAXSIZE

How can we evaluate the performance of the database to be launched soon? swingbench is the best choice except Benchmark Factory for Databases, which can be described as short and concise and completely free of charge, you don't need to get your

In brief, writing this article is a summary of your recent work. I hope it will be helpful and a little bit of accumulation. I. Why redis? Redis is used as the cache in the project and memcache is not yet used. There are two main considerations: 1.

Oracle creates a user-managed copy database on the same host The following are some steps:1. Back up all data files in the primary database (rau), and back up the control files to the tracking files. (Rau is the primary database ).[Oracle @ source ~]

ORA-28001: the password has expired scott/tiger When Oracle 11 is used today, scott, the default account in sqlplus, is used to log on. An error is reported and cannot be logged on. Solve these problems: 1. The account scott is in the unlocked

SHELL scripts have been studied in recent days. To facilitate Oracle O & M and simplify management, it is very necessary to learn some SHELL scripts. Through books and some online materials, I have compiled some excellent scripts, which are all

T_sys_client1. Create a temporary table first[SQL] Create TableTmpAsSelect*FromT_sys_clientWhere1 = 0; 2. Insert the queried records into the temporary table [SQL] Insert IntoTmpSelect*FromT_sys_clientAs Of TimestampSysdate-10/1440;-- Data

The following is a simulation process in Linux1. Simulate high CPU usage in a session, as shown below:DeclareNum int: = 0;BeginLoopNum: = num + 1;End loop;End;/ 2. Run the top command in the shell window to view CPU usage:Pid user pri ni size rss

The output of this command shows that the duplicate command of Oracle RMAN is executed internally and has a deeper understanding of cloning.For demonstration of the previous steps, see: C: \ oracle \ product \ 10.2.0 \ client_1 \ BIN> rman target

Flashback is a feature provided by Oracle since 9i. In 9i, we use oracle to query data that has been operated in a table for a certain period of time, this feature is also called Flashback Query. In 10 Gb, Flashback has been greatly enhanced. Using

Preparations Install a Virtual Machine (VMware Workstation version 8. x or VMware Server Version 1. x) Install the Operating System (CentOS 5.x or CentOS 4.x) on the Virtual Machine) Create an Oracle user and copy the Oracle software to a directory

The following error is reported during database Logon:ERROR: ORA-28002: the password will expire within 7 daysThe default profile of Oracle before 11g has no restrictions on password expiration. in Oracle 11g, the default profile enables the

I always wanted to make some contributions to PostgreSQL. Today I am free, so I wrote a tutorial on getting started with PostgreSQL 9.13... On deployment, you can move here...PHP 5.4.10 + Nginx 1.0.12 + PostgreSQL 9.1.3 source code compilation

Content Data Pump provides different export modes to detach different parts of the database. Specify the mode by entering appropriate parameters in the command line. The following are available export modes: Full Export Mode Schema mode Table