Oracle

Case 4--Delete tablespace (with backup) Recover the Tablespace-related information by backing up the control file because there is no information about the tablespace in the new control file. In fact, the archive log is used for recovery throughout

Case 3--A partial archive log was lost while doing a full recovery (recover database until cancel;) 1. Incomplete recovery based on cancel --Simulation environment Sql> Col table_name for A20 Sql> Col Tablespace_name for A10 Sql> select

As mentioned in introducing add values and drop values statements, add values and drop values are just changes in the data dictionary and do not involve changes in the data. Therefore, if the add values or drop values statements are executed, the

Yesterday, the installation and commissioning of Oracle 11G R2 RAC on the VirtualBox virtual machine was done with reference to documents on Oracle base, and the installation documentation was detailed, but it was the first time that the RAC was

If an online e-commerce system, we now need to be based on the order form reflected in the consumption of the customer simply divided into three categories of large and small and inserted into three tables. Order Form orders (order_id number,

Prior to Oracle 11g, the database needed to be in the Mount state when the physical repository (physical Standby) applied Redo. Starting from 11g, when applying redo, physical repositories can be in read-only mode, which is called Active Data Guard,

The portable tablespace is defined to move data from one db to another. The basic concept of migration is to remove the definition of table and table space from the data dictionary, copy the data files under the table space to the directory of the

The internal management of the log buffer is divided into two parts, one being the build redo record and the other being the redo record writing to the online log file. These two parts are not isolated and unrelated. During the process of generating

Oracle User Management First, the concept of the user Users, or user, is a popular way to access Oracle database "people." In Oracle, the user's various security parameters can be controlled to maintain the security of the database, these concepts

Sga_max_size Sga_max_size This parameter, as the name suggests, is used to control the maximum size of the SGA using virtual memory, where the meaning of virtual memory may be blurred, so that the maximum size that Oracle can allocate to the SGA in

After we have a datapump job, we can view the current progress through v$session_longops. Username-job owner opname-job name target_desc-job operation Sofar-megabytes transferred thus far Duri ng the job totalwork-estimated number of

A multiple-table query means getting the appropriate data from multiple tables. (1) Cartesian product "The join condition is invalid or omitted, all rows of the two tables are connected, and the combination of all rows is returned (N*M)" Sql>

To_char ();--Convert to String To_number ();--Convert to numeric type To_date ();--Convert to date type 1. Common Mathematical operation function ABS (Value): Returns the absolute value of Ceil (value): Returns the smallest integer greater than

[Grid@rac1 ~]$ cd/oracle/app/grid/product/11.2.0/deinstall/ [Grid@rac1 deinstall]$./deinstall Checking for required files and bootstrapping ... Please wait ... Location of logs/tmp/deinstall2010-08-02_12-50-24-pm/logs/ ############ ORACLE

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,

I. Classification of authority: System permissions: The system requires users to use the database permissions. (System permissions are for users). Entity permissions: The access rights of a user to a table or view of another user. (For a table or

2.1 Operational Requirements 1. Process and memory requirements The need for more processes Allocation of large pools 2. Basic Environment variable Demand Oracle_sid, Oracle_home, PATH, Nls_lang, if you use a time based backup and restore

Case 4: --Recover tablespace (open state) 1) test environment 07:47:00 sql> INSERT INTO EMP1 SELECT * from emp where rownum 2 rows created. 07:47:14 sql> commit; Commit complete. 07:47:17 sql> SELECT * from EMP1; EMPNO ename JOB MGR

(1) Write hot backup script (double spool) Set feedback off pagesize 0 heading off verify off Linesize-Trimspool on echo off Define bakdir= '/disk1/backup/anny/hot_bak ' Define bakscp= '/disk1/backup/anny/hot_cmd.sql ' Define spo= '

ORA-00922 Missing or invalid option 0ra-00922: Missing or invalid option Cause an invalid option is specified in defining a column or storage clause. The valid option in specifying a, NOT NULL to specify, the column cannot contain any NULL values.