1.1、备份数据库
SQL> backup database full to FULL_BACKUP backupset '/dm8/backup/full_backup';
操作已执行
已用时间: 00:00:03.205. 执行号:1200.
SQL> select * from v$backupset;
未选定行
已用时间: 14.365(毫秒). 执行号:1201.
SQL>
添加备份目录
SQL> SF_BAKSET_BACKUP_DIR_ADD('disk','/dm8/backup/full_backup');
DMSQL 过程已成功完成
已用时间: 3.100(毫秒). 执行号:1202.
SQL> select device_type,backup_name,backup_path from v$backupset;
行号 DEVICE_TYPE BACKUP_NAME BACKUP_PATH
---------- ----------- ----------- -----------------------
1 DISK FULL_BACKUP /dm8/backup/full_backup
已用时间: 13.829(毫秒). 执行号:1203.
SQL>
2.2、增量备份
SQL> backup database INCREMENT to incre_backup_1 backupset '/dm8/backup/incre_backup_1';
操作已执行
已用时间: 00:00:02.953. 执行号:1209.
SQL> SF_BAKSET_BACKUP_DIR_ADD('disk','/dm8/backup');
DMSQL 过程已成功完成
已用时间: 0.414(毫秒). 执行号:1210.
SQL>
SQL> select device_type,backup_name,backup_path from v$backupset;
行号 DEVICE_TYPE BACKUP_NAME BACKUP_PATH
---------- ----------- -------------------- --------------------------------
1 DISK FULL_BACKUP /dm8/backup/full_backup
2 DISK INCRE_BACKUP_1 /dm8/backup/incre_backup_1
已用时间: 18.189(毫秒). 执行号:1212.
SQL>
3、增量累积备份
SQL> backup database INCREMENT CUMULATIVE to cumul_backup backupset '/dm8/backup/cumul';
操作已执行
已用时间: 00:00:02.939. 执行号:1213.
SQL> select device_type,backup_name,backup_path from v$backupset;
行号 DEVICE_TYPE BACKUP_NAME BACKUP_PATH
---------- ----------- -------------------- --------------------------------
1 DISK FULL_BACKUP /dm8/backup/full_backup
2 DISK INCRE_BACKUP_1 /dm8/backup/incre_backup_1
3 DISK CUMUL_BACKUP /dm8/backup/cumul
已用时间: 24.775(毫秒). 执行号:1214.
SQL>
4、备份表空间
SQL> select tablespace_name,file_name from dba_data_files where tablespace_name = 'TBS1';
行号 TABLESPACE_NAME FILE_NAME
---------- --------------- ---------------------
1 TBS1 /dm8/data/tbs1_01.dbf
2 TBS1 /dm8/data/tbs1_02.dbf
已用时间: 3.220(毫秒). 执行号:1215.
SQL>
SQL> backup tablespace tbs1 to tbs_backup backupset '/dm8/data/backup/tbs_backup';
操作已执行
已用时间: 00:00:02.874. 执行号:1216.
SQL> SF_BAKSET_BACKUP_DIR_ADD('disk','/dm8/data/backup/');
DMSQL 过程已成功完成
已用时间: 0.444(毫秒). 执行号:1217.
SQL> select device_type,backup_name,backup_path from v$backupset;
行号 DEVICE_TYPE BACKUP_NAME BACKUP_PATH
---------- ----------- -------------------- --------------------------------
1 DISK FULL_BACKUP /dm8/backup/full_backup
2 DISK INCRE_BACKUP_1 /dm8/backup/incre_backup_1
3 DISK CUMUL_BACKUP /dm8/backup/cumul
4 DISK TBS_BACKUP /dm8/data/backup/tbs_backup
已用时间: 24.156(毫秒). 执行号:1218.
SQL>
