Shulou(Shulou.com)05/31 Report--

This article mainly explains "the backup and recovery method of Oracle 12c". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn the backup and recovery method of Oracle 12c.

Backup:

1. Back up all databases (including CDB)

Rman target /

BACKUP DATABASE

two。 Back up only CDB

Rman target /

BACKUP DATABASE ROOT

3. Back up only PDB (one or more)

3.1 single CDB backup:

Rman target=sys/oracle@pdb1

BACKUP DATABASE

Or

Rman target /

BACKUP PLUGGABLE DATABASE pdb1

3.2 multiple CDB backups:

Rman target /

BACKUP PLUGGABLE DATABASE pdb1,pdb2

4. Back up only one of the tablespaces

This is no different from the original, just need rman login to back up that database.

Rman target=sys/oracle@pdb1

BACKUP TABLESPACE users

Restore:

1. Restore all databases

Rman target /

Startup mount

Restore database

Recover database

Alter database open

two。 Only CDB restore

Rman target /

Startup mount

Restore database root

Recover database root

Alter database open

3. Only PDB restore (one or more)

Rman target /

Alter pluggable database pdb1, pdb2 close

Restore pluggable database pdb1, pdb2

Recover pluggable database pdb1, pdb2

Alterpluggable database pdb1, pdb2 open

At this point, I believe you have a deeper understanding of the backup and recovery method of Oracle 12c. You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.