Oracle

Tuning system time is not a trivial thing for a RAC environment, and Oracle is likely to reboot one of the nodes to ensure consistency between nodes. The test found that if the system time is adjusted forward, no matter how long the adjustment will

Second, create a replication environment The creation is very simple, you only need to perform the following procedure on the target side (if there is more than one table space to replicate, just add t_names (2), T_names (3) ... t_names (n)):

Flashback Version Query, introduced by Oracle 10g, can see how records have changed over a period of time, relative to flashback query can see only a certain point of object state. Based on this history, DBAs can quickly determine at what point in

I. Several types of log files in Oracle Redo log files--> online redo logs Archive log files--> archive log Alert log files--> alarm logs Trace files--> tracking log User_dump_dest--> User tracking log Backupground_dump_dest--> Process trace

Sqlloader export Excel data to Oracle 1. Create Sql*loader input data required by the file, are saved to C:\, edited in Notepad: Control file: Input.ctl, the contents are as follows: Load data--1, control file identification InFile ' Test.txt '--

L1, L2, L3 block function:--easy to find data blocks. There is a pointer to the L3 in the L1, L2 has a pointer to L3, and a pointer and state for multiple blocks of data in the L3. 1. In each L3, there are multiple L2 addresses (the first L3 is a

Objective: To clone the library with Rman on the same machine Environment: RedHat 4 + Oracle 10g Master Library Name: DB01 Clone Library Name: Clonedb 1, the main library db01, with Rman for backup (datafile, controlfile, Archivelog file) 08:49:

Only one DG can be designated for storage during the 11g installation: CRS, voting But Oracle's official recommendation is to configure this: 1, when OCR does not configure the mirror, or redundant storage of at least 3 OCR. If the underlying

DCBA a new discovery last week that, in oracle10g, Oracle behaves differently than before when rebuilding a stored procedure. In Oracle9i, Oracle also needs to recompile the process even if a completely identical process is rebuilt, as can be seen

Recently encountered a number of ASM data header problems caused disk GROUP can not be normal mount, the database is not working properly, has brought endless trouble, this time thinking, if I did the ASM data header backup How good ah,

Today, there are users of the ASM in the disk to do Fdisk, resulting in ASM disc exception, through the manual repair ASM disk HEADER To solve the problem, here through the experiment reproduced, reminding you to operate the ASM hard disk partitions

I had an interesting question today. Oracle users can tnsping, ordinary users tnsping error When you tnsping a database with a regular user tns-03505:failed to resolve name and tnsping the database with an Oracle user, you can ping it. tnsping

A partitioned index is a separate index on all of the zones, which is automatically maintained, which does not affect the use of other partitioned indexes of the index when a drop or truncate a partition, that is, the index does not fail, is easier

Relative to physical standby, the management of logical standby is a little more complicated. This is the difference between managing a half database and managing two of databases (assuming that the data guard environment is a master standby

Crystal Report version is 8.5 Stored procedures are: create or replace package pkg_test4astype v_cursor is ref cursor;end pkg_test4;/create or replace procedure pro_test4(P_CURSOR in out pkg_test4.v_cursor)assqlstr varchar2(3000);beginsqlstr

There is a connection problem with the database you can use the Tnsping service name at the command line to check the cause of the error. Common errors are: Ora-12535:tns: Operation timeout Turn off the firewall first, which is the most common

Oracle shutdown suddenly power off, resulting in the use of Sql/plus startup can not connect to the database, specifically described as: Connection can not be permitted, shut in progress. To the DOS prompt, type: C:\> Sqlplus/nolog Show:

Oracle Trace Files Oracle trace files are grouped into three types, one is the background alarm log file, which records the activity of the background process during startup, shutdown, and running of the database, such as table space creation,

For local Users, insert permission is required only for INSERT permission, which is not sufficient for insert operations through the database chain. Looking at Oracle's admin manual is a problem that has not been noticed before. To see a specific

Think twice about asking me today: Rman backs up the meaning of%a in format formats. In fact, Oracle's documentation has this statement: %a Specifies the activation ID of the database. But the description is not clear. In fact, junsansi means