Database Administrator

Restore database backup in a new environment. An error occurs during data file restoration. Environment Description: Oracle 10.2.0.3 for solaris 10, the backup database is RAC, and the recovery is performed on a single instance. The operation

On the linux server running the Oracle database, the load per minute in a certain period of time will suddenly rise to more than 40, and kswapd0 appears in the process queue, resulting in no response to the database, lasting for several minutes.For

1. Oracle 11g asmPfile parameter file path $ ORACLE_HOME/dbs/init + ORACLE_SID.ora for example ORACLE_SID = + ASMPfile $ ORACLE_HOME/dbs/init + ASM. ora The content is as follows: *. Asm_diskstring = '/dev/sda2'*. Asm_diskgroups = 'dgasm1'*.

--- 1. Preparations for installing OracleContent of the oracle user. bash_profile FileUmask 022PATH =/bin:/usr/local/bin:/usr/X11R6/binLD_LIBRARY_PATH =/usr/lib:/usr/X11R6/libORACLE_BASE =/u01/appORACLE_HOME = $

OSWatcher Black Box (OSW for short) is a small but very useful tool provided by Oracle. It records some performance parameters of the operating system by calling the commands provided by the OS itself, for example, CPU/Memory/Swap/Network IO/Disk IO

Today, my colleague asked me to reduce the undo tablespace to the original 40 GB. Previously, the undo tablespace was extended to GB due to developers' needs, and now it needs to be reduced to 40 GB. Although the whole thing is a bit different from

Since the company does not have Oracle 11g, and has never used this version before, some new features are not very familiar. This export of the database of 11 GB encountered the problem that exp could not export an empty table. After a long time, I

1. error message Immediate Kill Session #: 1024, Serial #: 9855 Immediate Kill Session: sess: 7000001cc9bb9e8 OS pid: 799228 2. cause: This is caused by unpublished Bug 6955040 all the sessions lost connection after killing crsd. BIN. The problem is

In the morning, I received an alert text message on the way to work. An error occurred while archiving an alert library. The content of the alert. log file is as follows:Wed Jul 25 06:00:02 2012Errors in

The backup manager RMAN provides the configure retention policy command to set the backup storage POLICY, that is, how long the backup file is retained. RMAN identifies the backup files that have exceeded the time as obsolete (obsolete ). Command

Recently, I wrote a tutorial to implement automatic and timed backup for MySQL in Linux for later reference. I would like to share it with you. If you have any questions, please try again. The premise is set to 00:00 in the morning, so that the

I encountered the following error when I restarted data of a rac today, prompting that I could not find a disk group resource named FGDG: [Grid @ srcbdb1 ~] $ Srvctl start database-d dcdbPRCR-1079: Failed to start resource ora. dcdb. db CRS-2640:

Exp test/test file = test. dmp wner = test log = exp. logErrorEXP-00056: Oracle error 29275 encounteredORA-29275: partial multibyte character.EXP-00000: Export terminated unsuccessfully Cause: inconsistent character sets Oracle @ MDSWEBDB01:>

The mysqlcheck client tool can check and repair MyISAM tables, and optimize and analyze tables. In fact, it integrates the functions of check, repair, analyze, and optimize in mysql, There are three methods to call mysqlcheck: Shell> mysqlcheck

1. Environment Introduction Site Unique_db_name Primary 192.168.1.102 Stydb Physical standby 192.168.1.101 Ql SQL> select protection_level from v $

Incremental synchronization of data in two databases Oracle Database IP Address: 192.168.0.1 (source database), 192.168.0.2 (target database) 1. Create a TEST table in the source database Create table TEST ( Id number not null, NAME VARCHAR2 (20

1. Get the current dateSelect sysdate from dual;2. Get the date of 00:00:00 on the current day.Select trunc (sysdate) from dual;3. display the current date in Chinese on the day of the week:Select to_char (sysdate, 'day') from dual;4. The current

Therefore, the installation method uses Cmake, which is different from the configure version earlier than 5.5. The installation steps are as follows: 1. decompress the compressed file: Tar-zxvf mysql-5.6.4-m7.tar.gz 2. Go to the decompressed Folder:

Create or replace trigger emp-- Before indicates the trigger before the operation-- After indicates the trigger after the operation -- Up to 12 triggers can be created for each table-- Before inset-- Before insert for each row-- After insert-- After

Recently, I encountered a very bad BUG. I used the merge engine to copy data in row mode, which has a high probability of crash slave database. My test environment is 5.1 master database and 5.5 slave Database Test case: Create TableM1