How to Use RMAN to restore some tablespaces

How to Use RMAN to restore some tablespaces

During the routine maintenance and use of the Oracle database, data may be accidentally deleted (drop, delete, truncate). When we use conventional means (flashback query, flashback drop, we can use the latest logical backup and dmp on different machines to restore the corresponding tables. However, if these logical backups are not available, there is a recent rman full backup, then we can use this backup to restore the accidentally deleted tablespace to restore the data. Here I will take the NBU backup environment as an example to briefly describe how to restore some tablespaces;

------- Restore the control file in nomount status
Run {
Allocate channel t1 type 'sbt _ tape ';
Send 'nb _ ORA_SERV = maid, NB_ORA_CLIENT =

Basic Oracle tutorial-copying a database through RMAN

Reference for RMAN backup policy formulation

RMAN backup learning notes

Oracle Database Backup encryption RMAN Encryption

-------------------------------------- Split line --------------------------------------