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

1. Create a sequence -- Create sequence create sequence INNERID minvalue 1 maxvalue 99999999999999 start with 1 increment by 1 cache 20 order; 2.--innerid.currval refers to the current sequence --INNERID.nextval 指下一个序列 insert into admin values

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

Here, without talking about the big things, like knowing the whole IT environment, assuming you already know that, then you have to deal with these living database. Here is a summary of some general ideas to face a full first database, so that you

Password complexity is an important aspect of it auditing staff to check whether a system is secure. It policies often indicate that passwords should have a minimum length and should contain a mix of uppercase letters, small letters, numbers, and

First, the demand background: Table A: CREATE TABLE T_SMCOMMONMSG （ FXH NUMBER， FTYPE NUMBER， FMSG_CONTENT VARCHAR2（1024 BYTE） ） Table B: CREATE TABLE T_SMYL_COMMONSND （ FXH NUMBER， FMSG_CONTENT1 VARCHAR2（1024 BYTE）， FMSG_CONTENT2 VARCHAR2（1024

-- 如果undo表空间undotbs不能释放空间,重建之 -- 创建备用undo表空间 create undo tablespace newundotbs datafile '$ORA_DATA/newundotbs01.dbf' size 1000m / -- 切换undo表空间 alter system set undo_tablespace=newundotbs scope=spfile / shutdown immediate / startup / -- drop原表空间

The author encountered the following problems in the process of doing the project, the database backup files provided by the customer need to be imported into the database, in order to use, the database is Oracle 9.1.1, installed in the Windows

Starting with Oracle 10g, physical standby can also be temporarily placed in the Read/write state for development, testing, and reporting, and then continue to apply the main library archive through flashback to the previous point in time. The

--Insert Bfile Create or Replace procedure Insert_book (filename varchar2) asBook_file bfile: = NULL;Bookexists Boolean: = false;BeginBook_file: = Bfilename (' book_text ', filename);Bookexists: = dbms_lob.fileexists (Book_file) = 1; If Bookexists

We know from the beginning of oracle9i that Oracle introduced the characteristics of the peeking of user-defined Bind variables, which can be used to rectify the execution plan when there is data skew.However, this feature may also have some side

1. Implement select Top N in Oracle because Oracle does not support select top statements, it is often used in Oracle to implement a SELECT top N query using the combination of order by and RowNum. Simply put, the implementation method looks like

In 9i, initialization parameters Audit_trail only the None, DB, and OS three optional values, while in 10g Oracle added several new options. This article describes the XML options. Database version and default audit_trail parameter settings: Sql>

The Rman List command is a way to query the historical information of a backup in a database control file or recovery directory. The list provides a set of information, including all the information from the list of database counterparts to the

Briefly describe the Rman configure EXCLUDE for tablespace command. Rman can use configure EXCLUDE for tablespace to set up a full library to skip some tablespaces. In general, you can use this command to skip the read-only or offline table space

The test found that 10g awr significantly decreased performance when importing snap data of large data volumes. A less than 2G awr export file, using AWR to import into the target database, was more than 5 hours. bash-2.03$ Sqlplus/as SYSDBA

Today, a brief introduction to the target= "_self" >sga setting method 1.sga_target parameters alter system Set Sga_target = 40000m Scope=both; Characteristics: 1). ASMM Automatic shared memory management A: Sga_target parameter control ASMM

The previous article briefly describes the method for restoring statistics, which describes the relevant views and functions. In the previous article, it was mentioned that if you want to restore statistics, you must provide the timestamp of the

From 10g, Oracle can recover the wrong statistics. This article briefly describes the statistical information recovery feature. Inaccurate statistical information may lead to the inability to produce optimal execution plans, and for the most part,

In 11g, Oracle has made further enhancements in statistics. This article introduces pending statistics. In 10g, Oracle provides a way to restore statistics, which causes problems that can be solved quickly by restoring the original statistics. In