Rman demo of backup and recovery
- 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;
- 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>
- Data file backup and recovery
|