unhealthy state and you cannot close the database using the SHUTDOWN normal or SHUTDOWN immediate command.2. Need to close the database immediately3. A problem occurred while restarting the DB instanceAll running SQL statements will be terminated immediately, all uncommitted things will not be rolled, all users will be disconnected directly, and the next time the database is started, the instance recovery is required.·Friendly TipsIt is best to use the shutdown immediate method when you close t
Received the first recovery rescue using Oracle 12C as a production library. There are two business data file file headers damaged, other data files are all a September backup, under current conditions, hope we can help them recover the data in the business documentDatabase
Build Environment:
Red Hat Linux Enterprise 5.4
Oracle 10g R2
The host operating system information is 192.168.199.128.
Preparation:
The master database (production database) DB_NAME = mustang SID = l already exists.
Start building Data Guard
First, you need to prepare the parameter file and set some necessary parameters. In the master database, the pfile file is
of existing IT investments and assets, regardless of the environment (operating system, application server, and so on) in which these assets are built and what technologies are used. Oracle SOA Suite focuses on ease-of-use and reuse, unified application development tools, and end-to-end lifecycle management to further help users reduce the cost and complexity of future development and maintenance.Features and benefits
Support for mobile apps
Data Guard log transmission optimization ------ network transmission optimization practices (I) adequate network bandwidth is the basis for log transmission optimization www.2cto.com experience value budget formula: bandwidth demand = log generation/0.7X8 Note: oracle logs are generated in large bytes (8 bits), while the network bandwidth is small bit (1 bits) th
Create a temporary table spaceCreate temporary tablespace test_tempTempfile ' D:\app\orcl\oradata\temproryTestUserSpace\test_temp1.dbf 'Size 10m autoextendOn next 10m maxsize 50m extent management local;Create a data table spaceCreate tablespace test_data LoggingDataFile ' D:\app\orcl\oradata\temproryTestUserSpace\test_data1.dbf 'Size 10m autoextend on next 10m maxsize 50m extent management local;Create User Settings user passwordCreate User C # #XSCJ
Tags: bpm OracleProduct Overview Today's businesses are increasingly under pressure, such as globalisation, competitor changes, tougher market rules, faster innovation, better customer service needs, and more. and trends such as mobile, social, cloud computing, and business analytics have far-reaching implications for business and core processes. Businesses need business-driven processes to quickly achieve seamless collaboration with all business participants, and leverage deep insights to bette
Data Guard configures Standby Redo Log Data Guard in maximum protection and maximum availability mode, for real-time use of the maximum performance mode, the Standby database must be configured with the Standby Redo Log www.2cto.com slave database to create and configure the Standby Redo Log to receive logs transmitted
Data Guard wonderful ORA-16191: Primary log shipping client not logged on standby problem engaged in a Data Gurad, switchover, check the Configuration:
SQL> select dest_name,status,error from v$archive_dest where rownum
ORA-16191 error reported. The alert log information is as follows:
------------------------------------------------------------PING[ARC2]: Heartb
The 11g active data guard implements rman backup for the standby database, so that the database can be backed up without affecting the external services of the primary database.
The test is as follows:
SQL> select OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, DATABASE_ROLE from v $ database;
OPEN_MODE PROTECTION_MODE PROTECTION_LEVEL DATABASE_ROLE-------------------------------------------------------------
This article describes how to build a Acfs file system on a virtual machine that already has 12c RAC installed, and use the ACFS snapshot to brush a cow (Copy-On-Write) library to do the test library.
Highlight Step:
Add ASM disk to virtual machine to build Acfs file systemSecond, create Acfs file systemThird, create the database on the Acfs file system in Node 1. (12c supports
How to Use RMAN Incremental backup to restore data guard log gap (log disconnection), rmangapThe minimum scn information of the master database:SQL> col current_scn for 999999999999999SQL> SELECT CURRENT_SCN FROM V $ DATABASE;Select min (fhscn) from x $ kcvfh;Select min (f. fhscn) from x $ kcvfh f, v $ datafile dWhere f. hxfil = d. file #And d. enabled! = 'Read only ';CURRENT_SCN----------------126142052266
In Oracle Data Guard, the Redo Gap is generated because of some network or other problems, resulting in the interruption of the redo transmission. After the fault is eliminated, these redo files that have not been transferred will be discovered by some processes and transmitted to the slave database.Terms:ARC: archiving processMRP: Media Recovery Process, respons
RAC is designed to solve single point of failure (spof) and load balancing. However, only one copy of data exists in the RAC solution. The data itself is not redundant and is easy to form a single point of failure (spof ).
Data Guard provides data protection through redundan
switchover into the master database
SQL> alter database commit to switchover to primary with session shutdown;
Database altered.
8. Verify Role Changes
101 machines:SQL> select database_role from v $ database;
DATABASE_ROLE----------------PRIMARY
102 machines:SQL> select database_role from v $ database;
DATABASE_ROLE----------------PHYSICAL STANDBY
9. View or modify log_archive_dest_2
SQL> alter system set log_archive_dest_2 = 'service = stydb ';
System altered.
10. Restart the primary standby
.
Apparently, throw the ORA-01031: insufficient privilegesWhen you use dbca to create a database, the key file is automatically created under $ ORACLE_HOME/DBS.If not, you can use the orapwd command line tool. Its file and password are required parameters,For example (assume that the current directory is $ ORACLE_HOME/DBS ):Orapwd file = orapworcl Password = Oracle entries = 30 (Linux/Unix naming rules: orapw [Sid])
⑤ Set initialization parametersLis
Applies To: Enterprise Edition database-version 12.1.0.1 (12.1) The knowledge in this document applies to all platforms. Document purpose documents describe many aspects and usages of a pluggable database to better understand the product, and the document can also be used as a quick reference manual. Q-cdb/pdb conceptual knowledge in the 12c multi-tenancy architecture. What does pluggable database (PDB) mean in a multitenant architecture? The pluggabl
Data Guard has a gap sequence problem.
I. Problem Description
This afternoon, when the customer had a power failure, one of the standby database databases could not be started and the following error was reported.
Media Recovery Waiting for thread 1 sequence 12364Fetching gap sequence in thread 1, gap sequence 12364-12364Wed Jan 17 15:20:57 2018FAL[client]: Failed to request gap sequence GAP - thread 1 sequ
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.