Database Administrator

Oracle Data replication is a technology that implements a distributed data environment. It creates a distributed data environment by copying data on different physical sites. It is different from distributed databases. In distributed databases,

I. Oracle10g provides the ADDM function. It is naturally easy to use em to view the ADDM report. The following two methods are available if you use SQL: 1. The following SQL statement can be used to obtain the latest report. Set long 1000000

Synchronize and copy data from a remote Oracle Server to a local backup database Create or replace PROCEDURE "SYNC_DATA_FROM_DBLINK_DB"BEGINDECLARECURSOR c_TabNames ISSelect tname from tab;V_TabName c_TabNames % ROWTYPE;V_ SQL VARCHAR2 (500

The following error occurs when rman backs up archivelog: RMAN> backup archivelog all delete input; Starting backup at 14-APR-14 Current log archived Using channel ORA_DISK_1 Using channel ORA_DISK_2 RMAN-00571: ======================================

I. Description Starting from Oracle 10 Gb, oracle introduced Segment Advisor to check whether there are bucket-related recommendations in the database, and starting from 10gR2, oracle automatically schedules and runs a segment advisor job, regularly

System Environment: Operating System: RedHat EL55 Oracle: Oracle 11.2.0.1.0 Case: The archive log space of the client database server is full and not found. After the DBA finds that the log switch is hang, the database is forcibly shut down, causing

Sqlldr is a recommended method for processing large data volumes. It has many performance switches to minimize redo and undo generation, control Data Processing Methods (insert, append, replace, truncate) Because the project needs to compare the

System Environment: OS: Linux EL5 CRS: CRS 10.2.0.1 Oracle: Oracle 10.2.0.1 1. crs startup failed [Root @ node2 ~] # Crsctl check crsFailure 1 contacting CSS daemonCannot communicate with CRSCannot communicate with EVM 2. view system logs [Root @

I. Features of ASM1. automatically adjust the I/O LoadASM can automatically adjust the I/O load in all available disks, which not only avoids manual I/O adjustment, but also optimizes the performance, with ASM, you can increase the database size

Since MySQL5.1.0, an Event sched (Event sched) feature has been added, which can be used to regularly execute certain tasks (for example: delete records, summarize data, and so on) to replace jobs that can only be executed by scheduled tasks of the

The concept of DBLINK is not described in this article. This article mainly introduces the creation of DBLINK. 1. Create an environment descriptionThis article will create and test DBLINK on two virtual machines with a red hat 5.5 operating system

The number and type of BUFFER headers in the buffer cache can be viewed through the preceding table, and you can see the SQL query results you have previously understood: ZN @ PROD> select * from t8; X Y--------------------1 2 ZN @ PROD> select

Symptom:An error is reported in the alert Log when the Oracle database is started:SUCCESS: diskgroup DATADG was mountedErrors in file/oracle/app/11gR1/diag/rdbms/rac/rac2/trace/rac2_mmon_1_6.trc (incident = 240612 ):ORA-00600: internal error code,

Preface Today we will share with you the technology on Oracle control files. Without a long journey or even a thousand miles, without a small flow, it cannot become a sea of rivers. Oracle technology is profound and profound. With the power of my

This is just a simple MySQL setting. However, many images are simple, but security is ignored. Therefore, you must be clear about the details and meanings of the settings. MySQL remote connection settings The steps are as follows: 1. log on to the

There is no way in the world, and when there are more people, the road will become. Why can't I create a MongoDB on ipvs? After taking a series of actions in NoSQL, The Postgres community is not waiting. Postgres has been making progress:

Login connection errors are the most common problems we encounter during Environment configuration, changes, and new Client installation. The logon process involves the client network, operating system, TNS configuration, listener working status,

With the continuous development and increase of the technical environment, the O & M department is facing two trends: large-scale and complex. One or two O & M personnel can manage hundreds of servers in the company in the future. At this time, the

Complete steps to manually create a database in Oracle 1. Create a directory for storing database files and log-Related Files Create the NEWDB directory in the $ ORACLE_BASE \ oradata and $ ORACLE_BASE \ admin directories respectively. Use commands

Generally, DBA and SA must maintain a correspondence between the OS disk and the disk in the Oracle database ASM Group when managing the disk.If SA is uncertain or DBA cannot be found, use the following method to find the corresponding relationship.