Database Backup and Recovery (MOSC)

MOSC Banner

backup database plus archivelog

edited Aug 5, 2019 5:01AM in Database Backup and Recovery (MOSC) 6 commentsAnswered

hi all,

i want to know if my script of backup is correct, for make a restore until last sequence:

RUN

{

CROSSCHECK ARCHIVELOG ALL;

DELETE EXPIRED ARCHIVELOG ALL;

SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';

BACKUP DATABASE PLUS ARCHIVELOG;

BACKUP CURRENT CONTROLFILE;

BACKUP ARCHIVELOG ALL DELETE INPUT;

}

are there rendundant instruction?

Is correct the sequence of this istruction?

i have to make the backup of controlfile before of the backup of database?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center