alter system archive log current
582889Nov 20 2009 — edited Nov 23 2009Hi;
Regarding the "alter system archive log current" clause.
Which one is the best usage in below script
1-)
run {
BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
}
2-)
run {
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;
}
3-)
run {
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
}
4-)
BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG; :)