disk. Split-brain has obvious harm to clusters. Cluster software vendors must provide solutions to solve this problem. Oracle cluster software (grid infrastructure in 11g) uses a quorum device ), it is called voting disk to determine the members in the cluster. All nodes in the cluster share a voting disk. When a node cannot send heartbeat to the internal network or voting disk, It is evicted from the clus
Oracle 11g, when backing up a database with the exp command, if the table does not have a datagram EXP-00011 error, the corresponding table does not exist. As a result, the corresponding empty table cannot be backed up.
Cause: by default, a segment is not allocated when a table is created at 11g, which is generated only when
/PROD1_db01/diag/rdbms/prod/PROD1/trace/PROD1_diag_26656.trc. There is no detailed information.
Later, we used the 10046 event to track the mount process and then saw a detailed prompt,
Alter session set events = '10046 trace name context forever, level 12 ';Trace file/d01/oracle/11.2.0/admin/PROD1_db01/diag/rdbms/prod/PROD1/trace/PROD1_ora_7764.trcOracle Database 11g Enterprise Edition Release 11.2.0.2.0-6
defined above, a new partition is created every month as long as there is data.INTERVAL (NUMTOYMINTERVAL (1, 'month') by MONTHINTERVAL (NUMTODSINTERVAL (1, 'day') by dayINTERVAL (NUMTOYMINTERVAL (1, 'Year') by YEARWhat is virtual column in oracle?
New Features of Oracle 11g-virtual ColumnsIn the old Oracle version, wh
Lab environment, Oracle 11gR2 standalone test data software and database upgrade, operating system Linux6.3Oracle version 11.2.0.1 upgrade package 11.2.0.3After the database software and database are upgraded successfully, the following error is always prompted when you test the export full database experiment of expdp:
[Oracle @ linuxtest ~] $ Expdp
Oracle 11g Active standby uard
Log applications and database read-only queries in log uard are mutually exclusive. If logs need to be applied, the database can only use the recover managed standby database disconnect from session in the Mount state to continuously apply logs from the background.To view the data in the standby database, you can only use recover ma
Prospect:1. Install the x86_64 version of the CentOS 7 system (or the corresponding version of Red Hat, etc.) to the GNOME Desktop edition.2. Download and install and activate Xmanager Enterprise 5 for connection access to Linux systems, data transfer, etc.3. Download the unpacked Oracle 11g R2 for Linux package and place the [Database/stage/components/oracle.jdk
11g use one parameter to set the password case sensitivity, below to do an experiment:C:\Documents and Settings\guogang>sqlplus Gg_test/[email Protected]_ggSql*plus:release 10.2.0.1.0-production on Monday August 4 17:54:19 2014Copyright (c) 1982, 2005, Oracle. All rights reserved.Connect to:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Productio
Oracle 11g real-time SQL monitoring
Oracle,In-depth analysis of Oracle,Reading Notes April 9 th, 2010Author: dbtan | [indicate the source and author information in hyperlink form during reprinting]
Link: http://www.dbtan.com/2010/04/real-time-sql-monitoring-in-oracle11g.html
Orac
ModeAutomatic archival EnabledArchive destination/data/oracle/oradgdata/standby_archiveOldest online log sequence 20869Next log sequence to archive 0Current log sequence 20871SQL>The Current log sequence of the master database and slave database is 20871, and the latest archive log applied on the slave database is YES, which indicates that the data synchronizati
Startup Mount Tip: Oracle routines are startedTotal System Global area 118255568 bytesFixed Size 282576 bytesVariable Size 82886080 bytesDatabase buffers 33554432 bytesRedo buffers 532480 bytesDatabase loading complete ALTER DATABASE open;Tips:An error occurred on line 1th:ORA-01157: Unable to identify/lock data file 19-see DBWR trace fileORA-01110: Data file:
overwritten, the archive process reads the log information of the log file that is about to be overwritten, and then writes these "read log messages" to the archive log file.When the system is busy, it may cause LGWR to wait for the arch process, you can modify the Log_archive_max_process parameter to start multiple archive processes, thereby increasing the speed of the archive write disk.System monitoring Process (Smon)A mandatory process to perform recovery work when the database system is st
advance). This is a dynamic parameter that can be changed in the database run:ALTER SYSTEM SET log_archive_max_processes=10;ASM-related processes: You must create an ASM instance (rebalance (Rbal), ASM rebalance (ARBN), ASM background) when using ASMManageability Monitor (Mmon): Collects centralized statistics, such as awr snapshot information, and warns you about the various dimensions of a database that violate thresholds.Manageability Monitor Lights (MMNL): Flushes ash
Tags: http using ar file data div sp on CUsing the Oracle Odp.net 11g. NET Program Publishing methodContent Summary: Odp.net 11g is an ADO released by Oracle for. NET programs to access the Oracle database, with better performance
Oracle 11g + RAC + RHEL6.5 + udev + ASM + PSU Installation Summary
1. Preparations before installation:
Operating System: RHEL6.5
Storage: Huawei, multi-path configured
Bind the business network card and heartbeat network card and pass the redundancy test.
YUM source configuration
BASH/SSL vulnerability patches
2. Check System Requirements
A. LINUX version
Cat/etc/issue
B. Memory (at least 1 GB)
Grep
?url= 43vmbt9oxnjylzky7j9n0orte6-erakxe-sqvj3r57lwpoiuas1gppbapxp2casp4b-ttxgi3f3fg63zcfxvvnipji5zaj8kncz1up4e4tu qq-pf-to=pcqq.c2chttp://blog.csdn.net/gaofeng2009123/article/details/8021150Http://www.linuxidc.com/Linux/2015-02/113222p8.htmLoginSimple inspection[Email protected] ~]$ sqlplus "/As SYSDBA"Sql*plus:release 11.2.0.1.0 Production on Sat Jan 24 14:51:10 2015Copyright (c) 1982, Oracle. All rights reserved.Connected to:Oracle Database
, can also be dynamically adjusted according to their needs, the character set to UTF-8:650) this.width=650; "src=" https://s2.51cto.com/oss/201711/02/31f64b1ab9791f2e8668217a961d0dd4.jpg "title=" 11.jpg "alt=" 31f64b1ab9791f2e8668217a961d0dd4.jpg "/>The default configuration is then done until the installation is complete:650) this.width=650; "src=" https://s5.51cto.com/oss/201711/02/21c9744ee49f3045c93fb1aca94f56c5.jpg "title=" 11.jpg "alt=" 21c9744ee49f3045c93fb1aca94f56c5.jpg "/>In the final
Databases are mainly used to partition different types of databases. In actual applications, most Oracle databases use the Partition Function to improve query performance. The Oracle 11g partition function can simplify the daily management and maintenance of databases, this greatly reduces the workload of DBAs (Database Design and Management Engineers.
The new fe
ORACLE 11G manual database creation, oracle11g manual database creation
Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for copyright.
Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/43926437
Step 1: Directory
-- Database file directory
$ Cd $ ORACLE_BASE
standby logfile thread 2 group size 50M, group size 50M, group size 50M;
--DG related configuration (fal_client 11G has been deprecated, file_name_convert after testing only RMAN replication data used to convert paths, standby settings can) alter system set fal_server= standby sid= '*'; Alter system set Standby_file_management=auto sid= ' * '; Alter system set log_archive_config= ' dg_config= (ORCL, Orclba
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.