Home IT Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ Oracle Duplicate build DataGuard     - About Python default character set (Linux)

- How to create an alternative Android / iOS connected wireless hotspot AP in Ubuntu 15.04 (Linux)

- Based on OpenSSL for HTTPS service configuration (Server)

- Everyone should know something about TCP (Linux)

- CentOS7 virtual machine creation failed Solution (Linux)

- quotacheck command file can not be created aquota.user and aquota.group solutions (Linux)

- CentOS 7 - use cgroups limit process resource (Linux)

- How to manage Vim plugin (Linux)

- Linux System Getting Started Learning: rename multiple files in Linux (Linux)

- How to monitor Nginx (Database)

- Oracle 11g creates virtual private directory RMAN-06004 ORA-00942 error handling (Database)

- Linux systems use logwatch log file monitoring (Linux)

- OpenGL ES 3.0 vertex buffer (Programming)

- CentOS7 installation configuration Redis-3.0.0 (Database)

- GROUP BY extension (Database)

- blecat: Bluetooth Gadgets (Linux)

- Under CentOS 7 installation and deployment environment Ceph (Server)

- Function Getting the Linux shell (Programming)

- Atheros AR8161 / AR8162 network card driver problem solving in CentOS 6.4 (Linux)

- ORA-04031 error appears in the solution run utlrp.sql (Database)

  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;
- How to Create a file can not be changed under Linux (Linux)
- MySQL enabled SSD storage (Database)
- Java NIO1: I / O model overview (Programming)
- C / C ++ language variable scope: local variables, global variables, file-level variables (Programming)
- Linux daemon (Linux)
- J2EE Example of Filter (Programming)
- iscsiadm command usage (Linux)
- Linux shell string interception and stitching (Linux)
- Installation salt-minion on RHEL5 (Linux)
- How to install Nginx on FreeBSD 10.2 as an Apache reverse proxy (Server)
- Visual Studio Code experience (Linux)
- Keepalived + Nginx Installation and Configuration (Server)
- MultiWriter: while the ISO image concurrent writes 20 USB Startup Disk (Linux)
- CentOS 6.5 installation and deployment SVN 1.8.10 (Linux)
- Recover Ubuntu 14.04 wakes up from standby in case mouse keyboard appears dead (Linux)
- IO reference Docker container (Server)
- How to Install terminator 0.98 on Ubuntu and Linux Mint (Linux)
- Java developers question (Programming)
- How to use OpenVPN and PrivacyIDEA build two-factor authentication for remote access (Server)
- How SSHfs mount a remote file system on Linux (Linux)
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.