Oracle 11g R2 rac rman backup script example
1. Switch RAC to archive Mode
1. Modify the archive mode of the database. Generally, archive is configured and the flash back area is used when RAC is installed. you can skip the steps below if you have configured archive.
SQL> alter system set cluster_database = false scope = spfile sid = '*';
2. Shut down all instances (shutdown on both sides)
SQL> shutdown imm
devices will no longer be supported in Oracle12. Oracle strongly recommends using at least 3 voting disks in a different location. When using ASM to manage voting disks, you need to be aware of the redundancy levels of disk groups and failure groups. Note that all copies of voting disk are in one disk group, and you cannot distribute voting disks across multiple disk groups. When using an externally redundant disk group, you can only have 1 voting di
Oracle.sysman.emcp.EMDBPostConfig Invoke Warning: WARNING ************************ The management repository is placed in safe mode, in which Enterprise Manager data is encrypted. The encryption key has been placed in the file d:/app/10188535/product/11.2.0/dbhome/a23181215.z The Te.intra_dw/sysman/config/emkey.ora. Be sure to back up this file, because if this file is lost, the encrypted data will not be
New Features of Oracle 11G: collecting multi-column statistics
Generally, when we submit an SQL statement to an Oracle database, Oracle selects an optimal method for execution, which is achieved by the Query Optimizer. CBO (Cost-Based Optimizer) is the default query Optimizer mode used by
Guidance:Oracle announced at its U.S. headquarters that,Oracle Database 11 GBInTPC-HA new world record was created in the MB benchmark. This achievement marks another milestone in Oracle Database development and marks the rapid development of Oracle databases. This is the fastest result of Non-cluster configuration and overall leading cost-effectiveness. In addit
Tags: 11g hand-built library Oracle 11gFirst step: Catalog-- Database Files directory$ cd $ORACLE _base/oradata$ ls-- When you see a library that already exists SIDPROD$ pwd-- Take a look at the absolute path/u01/app/oracle/oradata$ mkdir HYL$ ls-l-- production look at the directory and permissions-- plan the different
Support group. To create an Oracle user and password, enter the command: useradd-g oinstall -g dba -m oracle passwdoracleThen will let you enter the password, the password any input 2 times, but must be consistent, enter the confirmation. 2) Create database software directory and data file directory, directory location, according to their own situation, pay att
Tnsnames.ora file can also be copied from the Network\admin directory of the Oracle database home directory, as well as the Sqlnet.ora.) Then determine whether the host configuration is correct, if host is the hostname, you need to remove the domain name after the hostname)3. Configuring the Oracle Home and OCI libaray for PL/SQL developerEnter the PL/SQL Developer in non-logon mode, designate the
boundaryORA-14075: Partition maintenance operations can only be performed on partitioned indexesOra-14076:drop/splitpartition cannot be applied to local index partitionsORA-14078: You can not delete the highest partition of the global indexORA-14079: Invalid partition option marked as useless indexORA-14080: Unable to split partition by specified upper limitORA-14081: The new partition name must be different from the old partition nameORA-14082: The new partition name must be different from any
undertakes read operations. This architecture is suitable for read-intensive types of applications, and read performance can grow linearly by increasing the number of Slave DB. To avoid a single point of failure in Master DB, the cluster typically uses two Master db for dual-machine hot standby, so the entire cluster has very high levels of read and write availability. In addition to providing Active Standby functionality from 11g, mysql,
home directory, as well as the Sqlnet.ora.) Then determine whether the host configuration is correct, if host is the hostname, you need to remove the domain name after the hostname)3. Configuring the Oracle Home and OCI libaray for PL/SQL developerEnter the PL/SQL Developer in non-logon mode, designate the Oracle home path as the Oracle Client directory (C:\inst
directory, as well as the Sqlnet.ora.) Then determine whether the host configuration is correct, if host is the hostname, you need to remove the domain name after the hostname)3. Configuring the Oracle Home and OCI libaray for PL/SQL developerEnter the PL/SQL Developer in non-logon mode, designate the Oracle home path as the Oracle Client directory (C:\instantcl
In Oracle 11g, the system provides a new function, Virtual columns.
Official Website description:
A virtual column is not stored on disk. Rather, the database derives the values in a virtual column on demand by computing a setExpressions or functions. Virtual columns can be used in queries, DML, and DDL statements.
The system uses virtual columns to call operations or functions when this column of
According to the official oracle documentation, the oracle 11g replicuard can also apply redo in the open state on the physical standby machine, so it was tested locally, in this way, both redo and Data Query and Database Backup can be applied. it not only solves data disast
Tags: Oracle Linux due to project requirements, the need to install Oracle 11g on 64-bit Linux systems, a lot of content on the Internet, combined with their own practical experience, finally installed successfully, recorded, and shared to the needy comrades. First, installation Preparation If you are using a text-interface Linux, install the Linux GUI first. Bec
whether it ignores the case. -- Test SYS User:When we created the password file, we were competing against this user.Sql> Conn Sys/oracle as SYSDBA;Connected.Sql> Conn Sys/oracle as SYSDBA;Connected.Sql> Conn Sys/dave as SYSDBA;ERROR:Ora-01017:invalid Username/password; LogondeniedWarning:you is no longer connected tooracle.--The SYS user has successfully ignored the case problem.Summary:Through the above
$ Rman Target/Rman> BACKUP DATABASE as compressed backupset format '/oracle/rman/full_%d_%u.bak ';2. Create a Standby control file--performed on the primaryALTER DATABASE CREATE STANDBY controlfile as '/oracle/rman/standby.ctl ';3. Create the standby parameter file PfileCREATE pfile= '/oracle/rman/pfile ' from SPFILE;4. Modify the configuration associated with th
Oracle's official SQL Developer comes with Oracle migration Workbench.
What is Oracle SQL Developer? On the official page, this is how it is presented:
Oracle SQL Developer is a free and fully supported graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug
Considerations for new features of Oracle 11g
After upgrading from Oracle 10g to Oracle 11g, you need to understand the new features of Oracle 11G. These features may affect the applica
Before 11g, add a field with default value, the implementation principle is as follows:ALTER TABLE T1 add C1 varchar2 (a) default ' XX ' NOT null;Assuming that the T1 table has 40 million rows of data, Oracle returns a "Success Prompt" to the user when it executes the above DDL statement while updating the 40 million rows of
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.