Configure RMAN to delete archive logs that have been applied to the standby Database

Configure RMAN to delete archive logs that have been applied to the standby Database In DataGuard configuration, sometimes we need to use RMAN to automatically delete archive logs that have been applied to the slave database from FRA. When the

Start notes for Flashback database

Start notes for Flashback database To build an Oracle database for the testing department, you must meet the requirements that can often roll back the entire database to a certain time point. A simple method is to use one of Oracle's flash back

Oracle Database faults

Oracle Database faults Common Oracle Database faults: 1. system faults: sudden power outages and system restarts caused by operating system errors during server operation. Problems: memory data loss and database data inconsistency. Database data

GoldenGate supports the lowest MySQL version 5.1.5

GoldenGate supports the lowest MySQL version 5.1.5 GoldenGate's official documentation clearly states that GoldenGate needs to set the MySQL Log format (binlog_format) to ROW, and the other two formats (MIXED or STATEMENT) are not supported. ########

Oracle dynamic server parameter file

Oracle dynamic server parameter fileThe Oracle dynamic server parameter file (SPFILE) SPFILE is a binary file that is automatically maintained by the Oralce server process. This file cannot be manually modified. Once it is manually modified, it

Oracle static parameter file

Oracle static parameter file Oracle static parameter file) A static parameter file is a text file. The Oralce instance reads the content of this file at startup, So if you modify the content of this file, you must restart the Oracle instance to

Oracle Error: ORA-00119/ORA-00130

Oracle Error: ORA-00119/ORA-00130 When Oracle is started after the Server IP address and host name are changed, the following error occurs: SQL*Plus: Release 11.2.0.2.0 Production on Wed Nov 14 13:51:39 2012  Copyright (c) 1982, 2010, Oracle. 

Quickly build a Linux operating system + Oracle database environment

Quickly build a Linux operating system + Oracle database environmentI always wanted to learn about the O & M of Oracle databases in Linux, but the process of installing the Linux operating system from the beginning and then installing the Oracle

MySQL enables audit for common users (without super)

MySQL enables audit for common users (without super) Recently, it was found that the bad guy deleted the data and could not find the user and host. It was found that mysql was able to enable the audit function for users without the super permission,

Oracle Error: ORA-12514

Oracle Error: ORA-12514 This should be a series of ORA-00119 (TNS: the listener cannot identify the Service requested in the connection descriptor. After investigation, it was found that the dynamic registration of Oracle instances to Listener was

Add or delete a log group at 10 Gb in Oracle

Add or delete a log group at 10 Gb in Oracle This error was found in the alert Log during routine inspection. Thread 1 cannot allocate new log, sequence 319708 Checkpoint not complete This is actually a common error. Generally, it is because when

MySQL replication on Ubuntu12.04

MySQL replication on Ubuntu12.04 I. Introduction MySQL Replication is based on the binnary logging mechanism to synchronize data between the master and slave. Both mechanism, configuration, and operation and maintenance are much simpler and more

Oracle random generation date

Oracle random generation date When developing an Oracle testing environment, companies sometimes need fake data to test the functions and performance of applications. It is really troublesome to manually enter a bunch of SQL statements every time.

Full and incomplete Oracle database recovery and user management Backup Recovery

Full and incomplete Oracle database recovery and user management Backup Recovery Comparison between full recovery and Incomplete recovery: 1. Full recovery: restores the database to the latest status, including all submitted data changes until the

About the three date types in MySQL

About the three date types in MySQL After two insert date types recently, the value is 0000-00-00 00:00:00, so I checked the official documentation and found the reason. In Mysql, we often use three data types to store dates: Date, Datetime, and

ORA-27102: out of memory

ORA-27102: out of memory 64bit RedHat Linux, [Oracle @ DB ~] $ Uname-Linux DB 2.6.32-279. el6.x86 _ 64 #1 SMP Wed Jun 13 18:24:36 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux The physical memory is 16 GB. When the SGA allocates 4 GB memory, the instance

How to calculate the automatically managed UNDO tablespace size

How to calculate the automatically managed UNDO tablespace size AUTO UNDO Automatic undo Management (AUM) requires almost no configuration. Basically, you only need to define the time needed to keep the previous image available. This is controlled

Performance impact of Delete on table data deletion

Performance impact of Delete on table data deletionAs mentioned in the previous article (), when we use delete to delete data, because the high water level cannot be lowered, a full table scan will cause database performance problems, the truncate

Best practices for MySQL upgrade

Best practices for MySQL upgrade MySQL upgrade is very necessary. We listed a variety of questions about MySQL upgrade best practices on Percona Support. This article recommends some methods to upgrade MySQL in different situations. Why is MySQL

Oracle RAC 10.2.0.5 Install For redhat 5.8 (use raw device)

Oracle RAC 10.2.0.5 Install For redhat 5.8 (use raw device) Because the customer's database needs to be patched, similar test environments are installed. You must first install Oracle RAC 10.2.0.1 and then upgrade it to 10.2.0.5. Because I have many

Total Pages: 1013 1 .... 387 388 389 390 391 .... 1013 Go to: GO

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.