Tags: des style blog http color io os using ARThis series of articles is a summary of some of the new features of Oracle database 12c, including database management, RMAN, high availability, and performance tuning, Syed Jaffer Hussain.1. Online renaming and repositioning of active data filesUnlike previous versions, the migration or renaming of
area storage, default path, then click Next23 Here I choose to use the same password for all accounts Wangfeiyu123, can also be for different usersSet a different password, then click Next24. Set DBA, Database Operations Group Oinstall, then click Next25, if the error is prompted, because the version of the installation package is different or the kernel parameters have a problem or less dependentSoftware, you need to resolve the error, and then click Next (if it does not match the next two fig
There are two types of Standby databases:1, Physical standby databaseBlock-for-block basisThe physically identical with the primary databaseUser recovery technology2. Logical standby databaseShares the same schema definition withe the primary databaseExecuting SQL statements on the standby databaseUse logMiner technology
There are three types of services provided with Data Guard:1. redo transport services2.
customizing local data definitions. Use this tool to view the creation language, character set, and so on. Key features include language settings, geography settings, character set settings, and syntax settings. Net configuration Assistant: typically configured for network connections, this tool can be installed if a listener installation fails during installation because of some problems. Net Manager: Above is the configuration, this is the manageme
settings, character set settings, and syntax settings. Net configuration Assistant: typically configured for network connections, this tool can be installed if a listener installation fails during installation because of some problems. Net Manager: Above is the configuration, this is the management.5. Extended Reading5.1, Oracle 12c simple jdbc Use 5.2. Configuration and use of
databases. Unless explicitly stated, these apply to both capture modes.
If you are using Dbms_lob. The LoadFromFile process updates only the LOB columns, and your supplemental log is on all columns, integrated extract captures the key columns and the lob that improves performance. Classic extract captures all columns by default. These behaviors does not affect like to like replications. However, by copying to the Data warehouse, all columns
Error:
ORA-01194: File 1 requires more recovery to maintain consistency
ORA-01110: Data file 1: ' E:\APP\XIFENFEI\ORADATA\XIFENFEI\SYSTEM01. DBF '
Idle> alter system set "_allow_resetlogs_corruption" =true scope=spfile;
The system has changed.
idle> shutdown Immediate
ORA-01109: Database not open
The database has been unloaded.
The ORACLE routine has been closed.
idle> s
New Features of Oracle DB 12c: raw device bare devices are no longer supported, oracle12c
New Feature of Oracle DB 12c: raw device is no longer supported.
Reference:Announcement of De-Support of using RAW devices in Oracle Database Version 12.1 (Doc ID 578455.1)
Details:De-S
Tags:control1.0targedbf table spaces archappend backup strategy home Oracle 12c Backup and recovery strategy (Rman Backup [Open Archive/control file/data File/Archive log]): Backup strategy: * Make a full backup of the database (including all data and read-only tablespace) every six months * once a week level 0 backu
Adding columns with default values to tables in Oracle (including new 12C features)
This is a problem that I have been paying attention.
11G has been improved on this issue, and 12C has some new features.
12C adds the new 11g feature in this regard.
Add a column in 11G and set the default value. Instead of changing
Add columns with default values in Oracle tables (including new 12C features) and oracle12c
This is a problem that I have been paying attention.
11G has been improved on this issue, and 12C has some new features.
For a discussion on the new features of 11g, refer to my blog http://blog.csdn.net/dbcrocodile/article/details/21170407
Record the restoration of the ORACLE 12C CDB database when the current redo is lost. ORACLE 12C redo exception recovery test-some pdb are not open normallyIn order to verify the restoration of the ORACLE 12C CDB database when redo
Server A installs the Oracle 12c 64-bit database, and Machine B accesses the Oracle database.Get ready:1. Download Instantclient-basic-nt-12.1.0.2.0.zip,:http://pan.baidu.com/s/1c04lzso2. Download Plsql,:http://pan.baidu.com/s/1bnhkdojInstallation steps1. Installing the Orcle ClientUnzip the downloaded instantclient-basic-nt-12.1.0.2.0.zip to the directory of the
Label:Oracle DB 12c new feature: Raw device is no longer supported. Reference from:Announcement of De-support of using RAW devices in Oracle Database Version 12.1 (Doc ID 578455.1) Details:De-support of RawThe directory for this article is a notification that the raw device is no longer supported in the Oracle Database 12.1 release.This means that if you use the
In Oracle tablespaces and data files, Temp tablespaces and files are special. In addition to the temporary segment (Temp segment) corresponding to the temp tablespace, it is automatically managed by Oracle. The sparse file feature is also an important aspect to note.In general, we create a data file. Even if we use the
----------------- TO_PRIMARY 1 row selected
Step 5 start to convert the physical standby database to the physical primary database (executed by the original standby database)
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
-- If the ORA-16139: media recovery required is reported, it may be caused by the absence of logs, You can first execute
Alter database recover managed standby database disconnect from session;
Step 6 open the slave database, and then shut down and restart (executed
Description of Oracle 12c CDB and PDB database startup and shutdown, 12 cpdb
In Oracle 12c, it is divided into CDB and PDB. Their startup and shutdown operations are as follows.
1 Container Database (CDB)
For CDB, the startup and shutdown methods are the same as the traditional ones. The specific syntax is as foll
, which is managed after you log in to this URLUse the following URL to access:1. Enterprise Manager Cloud Control URL: https://oel63.ycdata.net:7802/em2. Admin Server URL: https://oel63.ycdata.net:7102/consoleThe following details need to be provided during the additional OMS install:1. Admin Server Hostname:oel63.ycdata.net2. Admin Server port:7102You can find the ports details used by this deployment at:/u01/oms12cr3/oms/install/portlist.iniNote:An encryption key had been generated to encry
/redo13.log' size 50 m;Alter database add standby logfile thread 1 group 14'/u01/app/oracle/oradata/xcldb/redo14.log 'size 50 m;
Note:When adding standby logfile, if thread 1 is a single instance database, but it is a RAC database,Add related Standby logs for each instance;In addition, you can use the following command to create an OMF-managed system:Alter database add standby logfile thread 1 group 11 size 500 m;Verification results:Col member format
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.