Oracle

Since Oracle database backups are available in three ways, each with different recovery characteristics, you should integrate database and file system backups, integrate logical and physical backups. First, backup strategy 1. At the operating

I. Data Control statement (DML) section 1.INSERT (Insert the statement into the data sheet) INSERT INTO 表名(字段名1, 字段名2, ……) VALUES ( 值1, 值2, ……); INSERT INTO 表名(字段名1, 字段名2, ……) SELECT 字段名1, 字段名2, …… FROM 另外的表名; field values for string types must

1. Set up Database automatic backup control files, spfile files 2. Every Sunday to do Rman 0-level full-Library backup 3. Daily (excluding Sunday) do Rman 1-level incremental backup 4. Keep a full library backup, incremental backup within one

The highly available systems of 24*7 (some of which are also called 24*7*365) are becoming more and more widely valued and applied because, in the real world, uninterrupted systems represent uninterrupted, voluntary revenue. But How to build and

In the database, the functions of Redo are mainly implemented through 3 components: Redo log Buffer, LGWR background process, and Redo log file (in archive mode, Redo log files will eventually be written as archive logs). In Oracle's SGA, there is

The concept of a sequence: A sequence is a database object that can be used to generate a unique integer. The main code value is generated automatically by using a sequence. The value of a sequence is automatically generated by a special Oracle

1, monitoring channels: summed up mainly through two aspects to carry out: 2, monitor the progress of recovery (1) View the active state of the process The V$managed_standby view is dedicated to displaying the current state of a physical

Application Scenario: Large data --1), create a partition table CREATE Table A (Statis_date varchar2 (8), ID number, Name VARCHAR2 (50), Salary number ) Partition by list (statis_date) (Partition day_20121130 values (' 20121130 '),

1. RAID definition RAID, full name Redundant array of inexpensive disks, Chinese name is redundant array of inexpensive disks. RAID can be divided into soft raid and hard raid, soft raid is the software to achieve multiple hard disk redundancy.

List of common commands summary memo The list command lists the control files and the backup information in the Rman recovery directory, which is one of the most intuitive ways to understand all of the visible database backup files. List

One, the source side Add extract Extl,tranlog,begin Now ADD EXTTRAIL/U01/OGG/DIRDAT/LR, EXTRACT EXTL ADD Trandata chf.objce_t Edit params EXTL Extract EXTL UserID Ogg,password Xifenfei Exttrail/u01/ogg/dirdat/lr Dynamicresolution

1, the installation of Oracle transparent gateway transparent gateways.Install Oracle Select Custom Install, then select Install transparent gateway, then go in to choose the component that installs for SQL Server.2. Modify

It is time-consuming to perform data manipulation language (DML) in a pl/sql loop because each loop is diverted from the Pl/sql engine to the SQL engine. Applying ForAll is a better way to submit a set of temporary values to a SQL statement at a one-

Oracle provides a variety of diagnostic tools for the RDBMS, and diagnostic events (event) is one of the common, easy-to-use methods that enable DBAs to easily dump database structures and track specific occurrences. The usual format and

In a RAC environment, logging into an instance can result in a GC global wait generation when the data being processed is completely unrelated to the data in the other instance's memory. This article describes the performance impact. The previous

Oracle provides the Wrap tool to encrypt stored procedures, and in 10g this operation can already be done in the database. Oracle's DBMS_DDL adds a wrap function that allows you to return the encrypted process: Sql> Select Dbms_ddl.wrap (' CREATE

ASM supports not only the RAC environment, but also the single node environment. It has always been thought that a single node ASM also needs Clusterware support, and that in this case, starting ASM needs to be configured as a RAC one node approach.

The Rman Page command allows users to determine the current recoverable state of the database and to provide specific information about the database backup. 1. Specify data files that have not been backed up recently The query does not have a

AWR snap generation, not necessarily to generate reports on the original database, you can use AWR provided by the export, import functions, the AWR data migration to the test database for further analysis. AWR's export is not complicated, and

An attempt to import awr data on the test database caused a ORA-4031 error. The error message is: Sql> @?/rdbms/admin/awrload ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~