oracle_11g_migratetofs

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
oracle_11g_migratetofs [2019/08/09 13:24] – andonovjoracle_11g_migratetofs [2019/10/18 20:04] (current) – external edit 127.0.0.1
Line 544: Line 544:
 / /
 </sxh> </sxh>
 +
 +
 +======Incremental backup recovery of database copy======
 +As complex as it sound, you can create incrementally updated copies of tha database:
 +
 +<sxh bash>
 +RUN {
 +ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT '/app/data/orcltest/datafiles/%U';
 +RECOVER COPY OF DATABASE WITH TAG 'mydb_incr_backup' UNTIL TIME 'SYSDATE - 7';
 +BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'mydb_incr_backup' DATABASE;
 +}
 +</sxh>
 +
 +This script will either do a recover a copy OR create a backup.
  • oracle_11g_migratetofs.1565357084.txt.gz
  • Last modified: 2019/10/18 20:04
  • (external edit)