Home IT Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ Oracle Duplicate build DataGuard     - Install Ubuntu 14.04 and Windows 8 / 8.1 dual-boot in UEFI mode (Linux)

- Install Java JDK 8 in CentOS 7 / 6.5 / 6.4 (Linux)

- Linux server security settings to close unused ports (Linux)

- Linux server data backup (Server)

- JavaScript cross-browser event object library (Programming)

- OpenNMS separate database (Server)

- RabbitMQ user roles and access control (Linux)

- VPS xen openvz kvm (Server)

- Java Adapter Mode (Programming)

- TCP network communication Java Programming (Programming)

- To share Linux script automatically change passwords (Linux)

- To teach you a trick to find the real IP address (Linux)

- Eclipse distributed management using GitHub project development (Linux)

- Ubuntu 13.04 configure MyEclipse 10.7 Environment (Linux)

- Upgrade to Linux Mint 16 petra Mint 17 Qiana (Linux)

- Linux directory structure (Linux)

- Linux basis: a comprehensive study pwd command (Linux)

- Bubble Sort Algorithms (Programming)

- Linux System Getting Started Learning: the curl set custom HTTP header (Linux)

- Ubuntu install snmp packets Unlinked OID in IPATM-IPMC-MIB: marsMIB (Linux)

  Oracle Duplicate build DataGuard
  Add Date : 2017-04-13      
  Duplicate build DataGuard:

Source Library:

allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
backup as compressed backupset database;
sql 'alter system archive log current';
release channel ch1;
release channel ch2;

Check out the data file path
select 'set newname for datafile' || FILE_ID || 'to' || file_name || ';' from dba_data_files;

select 'set newname for datafile' || FILE_ID || 'to' || file_name || ';' from dba_TEMP_files;

Use duplicate, to be prepared in the library have been working with the main library the same backup directory and have a backup set on the inside, run the command in the main library.

On the standby database configured pfile and standby controlfile

Preparation of library operation:
auxorcl target library tnsname.

rman target sys / Oracle @ cai auxiliary sys / oracle @ auxorcl;

set newname for datafile 1 to '/u01/app/oracle/oradata/cai/system01.dbf';
set newname for datafile 2 to '/u01/app/oracle/oradata/cai/sysaux01.dbf';
set newname for datafile 3 to '/u01/app/oracle/oradata/cai/undotbs01.dbf';
set newname for datafile 4 to '/u01/app/oracle/oradata/cai/users01.dbf';
set newname for datafile 5 to '/u01/app/oracle/oradata/cai/test.dbf';
set newname for tempfile 1 to '/u01/app/oracle/oradata/cai/temp01.dbf';
duplicate target database for standby;
- What happens after the MySQL disk space is full (Database)
- Recycle Bin function realization in Linux (Linux)
- Use rfkill soft-switching and Bluetooth wireless capabilities in Linux (Linux)
- Linux file permissions to modify the command: chmod (Linux)
- The ActiveMQ JMS installation and application examples for Linux (Linux)
- Linux NFS service fixed ports and firewall configuration (Linux)
- Binary tree traversal recursive and non-recursive (cyclic) traversal achieve (Programming)
- CentOS / Linux install VNC Server (Linux)
- Use window.name + iframe cross-domain access to data Detailed (Programming)
- Ubuntu 14.04 virtual machine switching desktop environments (Linux)
- Shell programming entry (Programming)
- Ubuntu 12.04 configure NVIDIA CUDA 5.5 Record (Linux)
- Customize the output format in Linux history (Linux)
- Security Configuration SQL Server 2000 database tutorial (Linux)
- Ubuntu 14.10 / 14.04 how to install Quick Start tool Mutate 2.2 (Linux)
- CentOS / Linux SWAP partitions added (Linux)
- HTML5 Fundamentals study notes (Programming)
- Solve ORA-01012: not logged on (Database)
- Use Elasticsearch + Logstash + Kibana set up centralized log Practice Analysis Platform (Server)
- How to set IonCube Loaders in Ubuntu (Linux)
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.