[vbox] 11g rac to simulate ocr damage recovery

Both the voice and ocr in 11gR2 are under the same disk group, so recovery is integrated View normal backups [grid@rac1 admin]$    [grid@rac1 admin]$ ocrconfig -showbackup  rac1     2019/05/08 12:27:51     /u01/app/11.2.0/grid/cdata/rac-cluster/backup00.ocr rac1     2019/05/07 15:32:37     /u01/app/11.2.0/grid/cdata/rac-clu ...

Posted on Fri, 15 Nov 2019 12:23:45 -0500 by egmax

oracle basically uses [7] single line function and group function

This article describes the functions in linux. In linux, functions are divided into single line functions and group functions. Single line functions are divided into string functions, number functions, date functions and other functions. Group functions are divided into max, min, avg, sum and count. 1 system, environment and preco ...

Posted on Wed, 06 Nov 2019 17:01:32 -0500 by TheDeadPool

Oracle create user and tablespace and authorization

Create users and tablespaces: 1. Log in to linux and log in as oracle user (if root is logged in, switch to oracle user with Su oracle command after login) 2. Open sqlplus in sysdba mode. The command is as follows: sqlplus / as sysdba 3. Create a temporary table space: --Queries the absolute path of the temporary tablespace file. If necessary, ...

Posted on Tue, 29 Oct 2019 10:42:38 -0400 by parawizard

ORACLE import and export

ORACLE import and export 1. Introduction EXP and IMP are client-side tools that can be used either on the client side or on the server side. EXPDP and IMPDP are tool programs on the server side. They can only be used on the ORACLE server side, but not on the client side. IMP only applies to EXP expo ...

Posted on Tue, 23 Jul 2019 00:57:41 -0400 by malam

oracle traditional export import and data pump export import

Oracle Table Space and Guide Library Summary I. Questions of Table Space 1.1 Table Space Creation 1.1 Path to your native environment: C: oracle product 10.2.0 oradata orcl create tablespace LTSYSDATA01 datafile 'C:\oracle\product\10.2.0\oradata\orcl\LTSYSDATA01A.DBF' size 1024M autoextend on next 50M maxsize unlimited logging extent mana ...

Posted on Mon, 10 Jun 2019 14:45:03 -0400 by rj2kix

Summary of the usage of oracle binding variables

In Oracle, there are two optional parsing processes for a submitted sql statement, hard parsing and soft parsing. A hard parsing needs to be parsed, execution path formulated, access plan optimized and other steps. Hard parsing not only consumes a lot of CPUs, but also occupies important latch resources. The only way th ...

Posted on Sun, 19 May 2019 13:45:53 -0400 by busterbry

Use and Management of Oracle-29-ASM

ASM (Automatic Storage Management) is a storage method introduced after oracle 10g. It is a volume manager developed by oracle itself, which can organize multiple bare devices in volume groups, and achieve system-level vg management using oracle process management.Using ASM allows us to use bare devices more flexibly. We view ...

Posted on Tue, 14 May 2019 23:20:24 -0400 by hughesa

2017-09-14 DBA Diary, an example of oracle not collecting awr information

Case Description The content of the awr report generated in oracle 11g standard edition is empty. Check dba_hist_sqlstat, dba_hist_time_model has no content. Definition of Problems Why didn't you collect the information needed by awr report in oracle 11g standard? Three. Diagnosis collecting data Reasons for parameters: We ...

Posted on Fri, 08 Feb 2019 21:51:17 -0500 by sosha

25. Setting up a GoldenGate replication with mapping between different columns

Brief description: The source and target tables of this blog experiment list OGG replication in different environments In the blog article "19. Setting up a Golden Gate replication between tables with different structures using defgen" This experiment is a supplement to the experiment in which the structure of targ ...

Posted on Mon, 04 Feb 2019 19:57:16 -0500 by system

Oracle quickly generates a large number of test data

Recently, there is a small module that copies backup data between disaster preparers and copies related data tables to the target system. Here's a question: What happens when Oracle tablespace reaches the upper limit? Generally speaking, setting table space to self-increment can satisfy most of the requirements without limiti ...

Posted on Fri, 01 Feb 2019 15:06:15 -0500 by x_maras