Oracle uses shell to test historical data samples
Shell has been used to analyze some data for some time, and the data analysis is based on historical data. Today, I wrote a script to perform a simple analysis of historical data,
Oracle data comparison (DBMS_COMPARISON)
A data comparison package (DBMS_COMPARISON), but this package is less than used. So let's talk about the use of this Toolkit today.
For friends who often finish data migration, after data migration, the most important and important qu
Data synchronization between Oracle GoldenGate databases on Heterogeneous OS
Oracle GoldenGate (hereinafter referred to as OGG) synchronizes data between databases of the same type on Heterogeneous OS.
Functions implemented by ogg:It can be refined to single-Table synchronization, rows synchronization that meets specif
' Secure_register_listener_name = ' I n Stand alone database installations.
1) restricting registration to the TCP protocol (Requires The fix for bug:12880299)
-or-
2 restricting Registra tion to the IPC protocol (the patch for bug:12880299 are not required for the "IPC method")
either method accomplishes th E same goal but it is your choice which type to implement subject to the restriction* noted. Both methods would be discussed.
the second method (using IPC) cannot was used if the database
GoldenGate synchronizes Oracle Data to GreenPlum
Source endOracle 11.2.0.4 RAC 2-NodesOracle Linux 5.8 x86_64Oracle GoldenGate V11.1.1.0.0 for Oracle 11g on Linux x86-64.zip
Oracle GoldenGate V11.1.1.0.0 For FlatFile on Linux 64-bit for OGG v11.1.1.0.0.zip
Target endGreenplum Database 4.2.6.1 4-NodesCentOS 5.7 x86_64
#if your database isn’t in archivelog mode,you must specify ALTER DATAFILE ... OFFLINE FOR DROP when taking a data file offline.When you use the OFFLINE FOR DROP clause, no checkpiont is taken on the data file, this means you need to perform media recovery on the data file before bringing it online.3 SQL> recovery datafile 4;
13. renaming or relocating a
time of undo data?
Method: Use the retention grarantee clause to ensure that the database is retained according to the undo_retention time;
2.1 start-up guarantee retained
Alter database UNDOTBS01 RETENTION GUARANTEE
2.2 disable guarantee of Information Revocation
Alter database UNDOTBS01 RETENTION NOGUARANTEE
3. disadvantages of enabling RETENTION GRARANTEE
When this parameter is enabled, when the business is busy, when the undo tablespace usage is
Data replication between Oracle databases-the COPY command in SQLPlus can replicate data between different Oracle databases and replicate data in the same database, its performance is the same as that of import/export. Schematic diagram: According to 9i, the Copy command wil
) backup-based tablespace migration
(4) dataguard
1.2.1 transportable tablespace
Transporttabletablespace can be implemented using expdp/impdp, or RMAN. Note that the tablespace needs to be set to read only for transmission of tablespaces, but it is generally not allowed by the production database, therefore, the backup-based RMAN table space can be used here.
One of the biggest advantages of table space migration based on backup is zero downtime, and supports heterogeneous platforms and cross
Tags: Oracle move datafileTo rename a data file or move a data file before Oracle12.1, you need to close the database or set the tablespace/data file to the offline state before referencing the Oracle modified data file name/Mobil
set conversion occurs, This type can also be affected;20, BFILE:This data type can store an Oracle directory object and a file name in the database column, which we can use to read the file;21, rowID :rowID is actually the address of a row in a database table, which is 10 bytes long. The information encoded in the ROWID is not only sufficient to locate each row on the disk, but also to identify the object
The most important task for a database administrator is to ensure that the database does not lose data. The redo and revoke mechanisms ensure that the database will never have a commit error no matter what operations the DBA has performed. However, if DBA does not take any preventive measures, the Oracle database may still lose data. Therefore, we must configure
In DataGuard, the data protection mode should be set as needed
In all configurations, performance is used for data security, or the data security level is used for performance.
1. Data protection modeFirst: Maximize Data ProtectionMaximum availability: This protection mode p
DBA's goal is to reduce MTTR (the average recovery time is the downtime after the database fails. The solution is practice, practice, and practice! Continuous simulation experiments) and Data
DBA's goal is to reduce MTTR (the average recovery time is the downtime after the database fails. The solution is practice, practice, and practice! Continuous simulation experiments) and Data
The most important ta
Data Guard offers two main services:
1 Redo Transport Service: The Primay end of the redo log transmission to one or more standby destinations.
2 Redo Application Service: The redo log which is transmitted from the Primay end is applied to the standby end.
This article first discusses the redo transport services.
1, the use of ARCN transmission redo log
By default, the ARCN transport redo log, but only
:@10.19.100.19:1521/aegisdb src_db_user=aegisdbsrc_db_password=123456 target_db_url=jdbc :p Ostgresql://localhost:5432/aegistarget_db_user=postgrestarget_db_password= 123456The configuration file uses JDBC to configure the connection string for the target library (PG) and Source Library (Oracle), where Oracle is a PDB for 12c, so the service name cannot be used
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.