Home » RDBMS Server » Backup & Recovery » what is the consequences of adding a plus archivelog and delete in oracle suggested backup (12.1.0.2 redhat 7)
what is the consequences of adding a plus archivelog and delete in oracle suggested backup [message #675779] Thu, 18 April 2019 12:19 Go to previous message
juniordbanewbie
Messages: 250
Registered: April 2014
Senior Member
Dear all,

from https://docs.oracle.com/database/121/ADMQS/GUID-D77B0526-13F6-4570-9C74-6436B76DEA43.htm#GUID-D77B0526-13F6-4570-9C74-6436B76DEA43

RUN {
 ALLOCATE CHANNEL disk_iub DEVICE TYPE DISK;
 RECOVER COPY OF DATABASE WITH TAG daily_iub;
 BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG daily_iub DATABASE;
}
exit
EOF

why isn't archivelog got backup and deleted? if archivelog is not backup and deleted wouldn't one day archivelog space be used up?

also what will happen if i do the following:

RUN {
 ALLOCATE CHANNEL disk_iub DEVICE TYPE DISK;
 RECOVER COPY OF DATABASE WITH TAG daily_iub;
 BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG daily_iub DATABASE plus archivelog delete input;
}

exit

many thanks in advance
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Doubt about what I realy need....
Next Topic: Including Archive logs in Controlfile manually
Goto Forum:
  


Current Time: Thu Apr 25 05:54:35 CDT 2024