Oracle Rman Backup (iv) replica

Source: Internet
Author: User
Tags create database backup

Eight Copy

Introduction to 8.1 image replicas

RMAN can create database data files, archive redo logs, or exact copies of control files. The Rman copy is a copy of these files, and the difference is only in the name and location changes. We don't

You need to consider backup slices or other issues. The image copy can only be generated on disk and cannot generate an incremental replica. The build image copy must load or open the database. Build history save for replica

In the database control file. So we can track the time that the replica was generated and where it resides.

Similar to regular backups, you can create an image copy of an entire database, table space, or data file. The RMAN replication process provides some of the same protection as regular Rman backup sets, such as checking corruption code

Blocks as well as logical corruption. In addition, image replicas can be combined with regular backup sets to help complete database recovery.

8.2 Image copies of databases, tablespaces, and data files

The Backup command supports the creation of a copy of the database image. Rman can generate an image copy through the backup as Copy command.

Rman>backup as copy database;

Image replica creation for tablespace:

Rman>backup as copy tablespace Users;

Image copy of data file:

Backup as copy datafile 1;

Backup as Copy datafile ' D:/app/administrator/oradata/orcl/dave0. DBF ';

8.3 Copy of control file

Backup control Files:

Backup current Controlfile;

To create a copy of the control file:

Backup as copy current controlfile;

To create a control file for backing up a database:

Backup as copy standby controlfile;

You can also specify aliases at the time of creation:

Backup as copy standby controlfile format ' D:/backup/controlfilecopy.ctl ';

8.4 Archivelog Image Copy

It is useful to generate archived redo log replicas. A redo log copy using Oracle's Logminer product Mining (Mine) archive is obviously more heavy than having to extract the archive from the backup set first

It's easier to make a log. You can create an archived redo log copy by using the Archivelog parameter of the copy command. Unfortunately, you must list the redo days for each archive when using copy Archivelog

Log name, and you cannot specify the time range for the redo log of the archive to be replicated.

Backup as copy archivelog all;

Related Article

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.