Oracle-Rman(物理备份)
Rman(物理备份) Rman -recover manager
|
Rman 备份的对象
不能备份在线日志 |
Rman 备份和恢复的演示
[oracle@WHOST ~]$ rman target / RMAN> backup database;
[oracle@WHOST ~]$ cd /u01/app/oracle/fast_recovery_area/GAGA01/backupset/2017_06_15 到备份路径下可以看到2个文件,一个大文件是数据,一个小文件是关于备份的一些信息.
查看备份的信息:RMAN> list backupset;
查看表空间:SQL> select name from v$tablespace; SQL> select name from v$tablespace;
NAME ------------------------------ SYSTEM SYSAUX UNDOTBS1 USERS TEMP 备份表空间:RMAN> backup tablespace USERS;
恢复表空间: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>
|