Oracle-rman (physical Backup)

Source: Internet
Author: User

Rman ( physical Backup)

Rman-recover Manager

Rman backed-up objects

      1. Data Files Data Files (Data File)
      2. Control Files Control Files (Control File)
      3. parameter File parameter File (Spfile/pfile)
      4. Archive File Archive File

Cannot back up online logs

Rman demo of backup and recovery

        1. Database backup and Recovery

[[email protected] ~]$ Rman target/

rman> backup Database;

[email protected] ~]$ cd/u01/app/oracle/fast_recovery_area/gaga01/backupset/2017_06_15

to the backup path, you can see the 2 files, a large file is data, a small file is about the backup of some information .

to view backup information: rman> list backupset;

        1. Table space Backup and recovery

To view a table space: sql> select name from V$tablespace;

Sql> select name from V$tablespace;

NAME

------------------------------

SYSTEM

Sysaux

UNDOTBS1

USERS

TEMP

Backup table space: rman> backup tablespace USERS;

To recover a table space: rman> recover tablespace USERS;

rman> recover tablespace USERS;

Starting recover at 16-JUN-17

Using channel Ora_disk_1

Starting Media recovery

Media recovery complete, elapsed time:00:00:00

Finished recover at 16-JUN-17

Rman>

        1. Data file backup and recovery

Oracle-rman (physical Backup)

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.