Oracle creates instances manually
Preface
$ORACLE_BASE/admin
Location of audit and other documents
$ORACLE_HOME/rdbms/admin
Some sql statements for building packages and stored procedures
<ORACLE_BASE>/admin/newdb/adump
<ORACLE_BASE>/flash_recovery_area
<ORACLE_BASE>/oradata/newdb
step
(0) specify environment variable
expor ...
Posted on Sun, 03 May 2020 23:24:15 -0400 by MasterHernan
Specific steps of oracle rman recovery
rman uses level 0 backup set for different recovery
$ rman target /
/*
It is used for testing. It is found that the test fails. It is very useful if you need to restore spfile
There is no parameter file. An instance of DUMMY will be generated under the command of RMAN
RMAN> set dbid=1234567890;
*/
Start datab ...
Posted on Sat, 02 May 2020 14:32:50 -0400 by dalecosp
SQL statements related to oracle database migration
I use PLSQL tool to do database migration. The example is to migrate the data of apps users of the same database to sccsrm users, which are all in the same database.
A common way of database migration is to use the command to export all data of a user and then import it into a new user.
DBA permissions are required to create users.
sqlplus / ...
Posted on Wed, 29 Apr 2020 11:59:36 -0400 by cheikhbouchihda
Extend group by statement
Learn from Chapter 5 of Oracle development art of breaking through the iceberg GROUP BY
For simple group by statements, it is difficult to analyze the complex dimensions, and it is difficult to meet the requirements of the actual production of complex reports. The extension feature of group by is needed. The union statement can also meet the r ...
Posted on Mon, 23 Mar 2020 05:00:57 -0400 by shrimp
Oracle single instance migration to Oracle single instance
Catalog
1. Environment deployment 2
1. 1. Modify the database to archive mode. 2
1. 2 create test table 2
2. Backup preparation 2
2. 1 full database backup 2
2. 2 copy parameter file 2
2. 2. 1 view parameter file path 2
2. 2.2 copy parameter file 3
2. 2.4 creating dynamic files 3
2. 5 copying archives 3 ...
Posted on Fri, 13 Mar 2020 05:50:20 -0400 by lin
linux Installation of OCI client and php installation of oci8 extension
linux Installation of OCI client and php installation of oci8 extension
oci client installation
Install oci8 extension
oci client installation
Download packageoracle-instantclient18.3-basic-18.3.0.0.0-1.x86_64.rpmoracle-instantclient18.3-devel-18.3.0.0.0-1.x86_64.rpmoracle-instantclient18.3-sqlplus-18.3.0.0.0-1.x86_64.r ...
Posted on Sat, 28 Dec 2019 11:08:50 -0500 by zfred09
[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