PostgreSQL cluster solution hot standby preliminary test

After the cluster was last installed, I didn't have time to write a test article (see). Today I wrote an article on the preliminary test, if you still want to know how to handle the ipvs cluster in different situations, you can leave a message to me

Oracle Database mobile data files, log files, and control files

1. Shut down the databaseSQL> shutdown immediate;2. Move data files and log files to a new locationSQL> host mv/u01/olddata. dbf/u02/newdata. dbf;SQL> host mv/u01/oldredo. log/u02/newredo. log;3. Start the database in load modeSQL> startup mount;4.

Oracle scn details

I have previously written a basic article about scn, but it does not reflect the changes and existence of scn. Here I want to say that many situations of scn may change, rather than submitting or The scn exists in multiple places. Such as log files,

Oracle backup and recovery framework

BackupBackup is used as a means of redundancy to prevent errors or downtime.I. Oracle backup can be divided into two types: physical backup and logical backup.1. Physical backup: copy, copy files such as datafile and control file to other

Troubleshooting for ORA-01078 and LRM-00109

System Version: CentOS 5.5x64 Database Version: Oracle 11G R2 11.2.0 The following error is reported: [oracle@server253 ~]$ sqlplus  / as sysdba    SQL*Plus: Release 11.2.0.1.0 Production on 1 17:38:49 2012   

Solution to ora-01190 ora-01110

SQLPLUS> alter database datafile 2 ONLINE;Alter database datafile 2 ONLINE*ERROR is located in row 1st:ORA-01190: control file or data file 2 comes before the last RESETLOGSORA-01110: data file 2: 'e: \ Oracle9I \ ORA9I \ undotbs01.dbf'Next, because

Temporary tablespace 100% solution

After the Select statement, create index, and other sorting operations using the TEMP tablespace are completed, Oracle Automatically releases the temporary segment. However, if some temporary segments are not released, the TEMP tablespace is almost

Rman backup appears ORA-19625

Rman backup appears ORA-19625: The reason is that the archive log is deleted in the operating system and has not been backed up yet. When rman backs up the log, the archive fails to be found. You can solve this problem by using the following

Oracle backup-Concepts

Oracle backup: Backup is redundancy. In essence, it refers to copying a few copies of the current data to other places, so that when the original data file is damaged due to various reasons, we can use the backup file to restore the status of the

Oracle connection Query

Connection query is a frequently used query method in database query statements. The following describes how to query connections based on the official documents provided by Oracle: 1. Connection Type: 1) Unique oracle connection types: A.Equijoin

New Features of Oracle 11g-Compound Triggers)

We have previously introduced the virtual columns and read-only tables in the new Oracle 11g feature. Today we will introduce another new feature, the combined trigger. In earlier versions of Oracle, you can use the FOLLOWS keyword to control the

ORA-29701 when Oracle 11gR2 starts the ASM instance

[Grid @ vm11gr2]/home/grid>Sqlplus "/as sysasm"SQL * Plus: Release 11.2.0.1.0 Production on Sun Oct 25 10:16:21 2009Copyright (c) 1982,200 9, Oracle. All rights reserved.Connected to an idle instance.SQL>StartupORA-01078: failure in processing

Oracle SQL optimization: View Merging)

In a query statement using a view or nested view, Oracle merges these views to obtain the optimal execution plan and connects the tables in the view to the tables in the external query. -- Example: SQL>SelectE. first_name, e. last_name, dept_locs_

Install the BerkeleyDB database in Fedora

1. First download the source file of the Berkeley db database from the Oracle official website. Http://download.oracle.com/otn/berkeley-db/db-5.3.15.tar.gz 2. The downloaded file is a packaged file and needs to be decompressed using tar in the

Oracle 11g R2 single-instance Database Backup Recovery Based on GRID

1. application scenarios:Environment:Host Name ip vip sid DiskGroupDb1 1.1.1.1 1.1.1.11 bkjia DATA1Db2 1.1.1.2 1.1.1.12 bkjiadb DATA2 Expected results:Db1 and db2 can be backed up to each other. Here db1 is used as the master database, and db2 is

Diagnose blocked sessions in Oracle

Due to the lock mechanism, when execution of a DML or ddl SQL statement is blocked, you need to find out why the SQL statement is blocked. The following describes the common diagnostic methods: Suppose there is a table: table t (id int primary key,

MySQL migration in CentOS 5.6

This week, two sets of EMC storage are migrated, and several intranet database servers are attached to the storage space. You need to migrate the stored database to the server. The specific migration steps are as follows: I. Environment: 1. original

How to recover Oracle users who forget their usernames and passwords

First, cmd-sqlplusw Common User Logon: User name: scott (Common User Name) password: tiger (common user password) Administrator Logon: User name: system password: system (administrator password) Note the following when a super Administrator logs on:

Summary of common RMAN commands

RMAN is a required management tool for Oracle Database Backup management. There are many ways to operate it. I sorted out some common operation commands and summarized them to facilitate work. 1. database backup operation commands Simplified Version

Oracle DBLink access Lob field ORA-22992 Solution

This test shows how to access a table containing Blob fields through DBLink. I. Simulated Problems 1.1In the instance1Operation on: Create a test table containing blob: /* FormattedOn10:18:05 (QP5 v5.185.11230.41888 )*/ CREATE TABLELob1 ( Line

Total Pages: 1013 1 .... 398 399 400 401 402 .... 1013 Go to: GO

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.