XX Hospital store suddenly dropped the line, resulting in database anomalies, on-site engineers toss a day, the problem is still unresolved, helpless to find us, I hope we can help restore the database.
Start report ora-00600[2131] ErrorFri Nov 06 1
A friend came to me and said they couldn't start the database, the database started Ora-600[k2vcbk_2] Error, the database version is 11.2.0.2 RAC, the operating system is AIX 6.1sql> Recover database;Media recovery complete.sql> ALTER DATABASE
In the process of database open, select CTime, Mtime, stime from obj$ where obj# =: 1 Statement report ORA-01555 error, database not normal open
In general, a rollback segment is reported, but here Ora-01555:snapshot too old:rollback segment number
The grid infrastructure shared components grid infrastructure uses two types of shared devices to manage cluster resources and nodes: OCR (Oracle Cluster Registry) and voting disks. Oracle 11.2 introduces a new file called Oracle local Registry (OLR)
NFS mount points that are disconnected on AIX cause Oracle instance HangTranslated from MoS article: Disconnected NFS Mount point causes Instance to hang on AIX (document ID 1445600.1)Suitable for:Oracle server-enterprise edition-version:10.2.0.1
QUESTION 6You want to check the details of few errors, which users have reported. You search for the alert log file and execute few commands to find the location of the alert log file.
View the Exhibit and check the commands executed.650)
--==========================================--oracle Instances and Oracle Databases (Oracle architecture)--==========================================/*For the first contact with Oracle database, two concepts that are easily confused are Oracle
To the company found that there is a report not received, after viewing the original is an Oracle data source exception. select to_char (sysdate - interval " Span style= "color: #ff0000;" > ' 1 " , yyyymmdd " ) as Fromdata, To_char (sysdate -
Reprint Please specify source: http://blog.csdn.net/anxpp/article/details/51345074, thank you!This article is for the most basic operations of students who have not used Oracle (whether they have used other databases or not).1. DownloadAddress: http:
I. Data definition language DDL1. Create tablespace : creat tablespace lyy datafile ' c:/app/lyy.dbf ' SIZE 10M; (Create a 10M tablespace and store it in the C-drive app folder)Delete Table space: Drop tablespace lyy;2. Create User and empower:
Explain the environment: operating system: AIX 7.1Oracle version: Oracle RAC 11.2.0.3 before the 11.2.0.3.9 patch set, the RAC is not formally used, so you can simply hit the latest 11.2.0.3.11 patch set.The two sets of RAC that were newly installed
Manually connecting to the Oracle Linux Yum Server
Download and Install Oracle LinuxNote: The Oracle Linux Yum Server is already configured on Oracle Linux 5 update 7 and Oracle Linux 6 Update 3 and higher. No further configuration is
SQL Introduction SQL supports the following categories of commands: 1. Data definition Language (DDL) 2. Data Manipulation Language (DML) 3. Transaction Control Language (TCL) 4. Data Control Language (DCL) Here are the detailed notes for these four
Using the Support Workbench
Using the Enterprise Manager Support Workbench with the Support Workbench, you can investigate, report, and (some cases) to resolve the issue:1. On the Database home page of Enterprise Manager, review critical Error
Database Storage Architecture
The files that make up Oracle DB can be categorized into the following categories:?Control Files:Contains data related to the database itself, which is the physical database structure information. These files are
Http://www.askoracle.org/oracle/HighAvailability/20140109953.html#6545406-tsina-1-3386-14a237f3587652368b695b00507b1475
Introduction to GoldenGate OracleGolden Gate is a log-based copy and backup software for structured data. It parses Source
The Blob field in Oracle is special. It has much better performance than the long field and can be used to save binary data such as sample slices.Writing Blob fields is very different from writing other types of fields. Because Blob itself has a
The error RMAN-06571: datafile 78 does not have recoverable copy is reported in the migration script log. It is found that file 78 was dropped by offline. So re-build the control file, in the control file to remove the 78 File, re-control, the
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service