oracle database patching strategy

\CONTROLFILES directory,But the file name is different, block_size (block size) 16384 BYTE = 16384*8 BITS =16384/1024 KB = kbFile_size_blks (Control file size) 462 BYTESql> SELECT group#, members, BYTES, STATUS, archived from V$log;There are 3 groups (group#) redo logs in the database, with only one member in each redo log group(members), the size of each redo log member is 536870912 BYTES =536870912/1024 KB = 536870912/1024/1024 mb = MB, 1th, 22 grou

Before you start a backup operation, you need to consider some compatibility issues. In an enterprise, different versions of Oracle may be running, so we must consider Rman compatibility issues when designing a backup strategy. Reasons can refer to: RMAN Architecture Overview The following table is a reference table for Oracle Compatibility: RMAN Target

1. Physical bad blocks and logical bad blocksThere is a concept in the database called data block consistency, Oracle's data block consistency includes two levels: physical consistency and logical consistency, if a data block at these two levels of inconsistency, it corresponds to the physical and logical bad blocks we want to say today.There is a checksum field at the head of each block, and Oracle recalcu

that is partitioned by a range to record sales history data, each month in a tablespace named after this month-for example, the January partition is named after a single, and is in a tablespace called a table space. This way you have a strategy to keep the information for 12 months. In January 2004, you will be able to archive the January 2003 data. The approximate operation process is similar to the following operations: Use ALTER table EXCHANGE PA

The steps to minimize Oracle downtime are discussed here. All forms of downtime-planned or unplanned-always occur, and a DBA should have the right backup strategy so that it can recover more quickly if there is a problem with the database. The following are the assumptions of the backup strategy and the operating cond

ping.Therefore, the purpose of Oracle Parallel server design is to make system transaction processing reasonably distributed between instance instances to minimize ping, while reasonably allocating PCM locks and reducing false ping. The key to design is to identify possible conflicts and determine the strategy for applying partitioning. There are four ways to apply the partition:1, according to the functio

Nub Backup Oracle can perform Oracle backup and recovery operations by invoking the Oracle RMAN utility through the NetBackup graphical interface or the Oracle command-line interface. In addition, Oracle Archiving and restore operations can be performed using NetBackup XML e

Tags: User proof use. com img Note ora ref optionWhat is Data redactionThe data redaction is a new feature of Oracle Database 12c's Advanced security options, and Oracle China translates it as a "compilation" When it comes to this feature, and in the Chinese interface of em12c R3, this function is translated into "data writing", I think the latter translation is

Tags: database concurrent access Lock1. DemandThe application scenario is this: Use Oracle data to save the to-do task, using the status field to differentiate whether the task has been executed. When multiple worker threads perform a task concurrently, the value of the status field is modified after the execution succeeds or fails. Suppose the database table str

I haven't seen much of Oracle's technical documentation for a long time, and today I read an Oracle Response time optimization and method R. This is the classic book of Optimizing Oracle Performance Classics. The main idea. R represents response time (response times). The specific definition is as follows: 1. Target the tasks this are critical to the business.2. Collect properly scoped, un-aggregated profil

Tags: Bring developer partition index MySQL LIN supports Windows database service Inadvertently seen on the internet, I see is reproduced by others, the author is unknown. First, openness1. SQL Serveronly running on Windows , without the slightest openness, the stability of the operating system is very important to the database. The Windows9x series is focused on desktop applications, and NT server is only

strategy At the operating system level, with a large-capacity disk array, each database file is automatically distributed to each physical disk by disk image technology. In this way, when a disk is physically damaged, the operating system automatically raises the image disk to replace the failed disk, ensuring that the database is running properly. Maintain mu

Guide: I haven't seen much of Oracle's technical documentation for a long time, and today I read an Oracle Response time optimization and method R. This is the classic book of Optimizing Oracle Performance Classics. The main idea. R represents response time (response times). The specific definition is as follows: 1. Target the tasks this are critical to the business. 2. Collect properly scoped, un-aggregate

At the stage of the development project, when the database table for the project has been designed, the next step is to develop it. But there are a lot of tables in a project, and the first step in development is to create the entity classes for the corresponding database tables in the project, which is a manual work, and it needs to be very careful, and it's a waste of time. However, the use of myeclipse r

Plan tables and storage spaces to prevent space shortages or wasted space Plan for a quick recovery zone, define the fast recovery zone in a different storage area from the data file, reducing IO contention Name of the planning database, Db_name,db_main,sid Planning parameters within the SPFile Planning for character sets, character sets cannot be changed after creating a good database