Given the following steps, which would be the correct order to create a backup of an Oracle
database in ARCHIVELOG mode with control-file autobackups enabled?
A.
backup archivelog all;
e
B.
backup database all;
a, b, a, c
C.
backup controlfile;
d
D.
backup archivelog, database, controlfile delete input;
b, a, c
E.
backup database plus archivelog delete input
b, a, c, d, e
A.
backup archivelog all;
e
B.
backup database all;
a, b, a, c
C.
backup controlfile;
d
D.
backup archivelog, database, controlfile delete input;
b, a, c
E.
backup database plus archivelog delete input
b, a, c, d, e
A. backup archivelog all;
B. backup database all;
C. backup controlfile;
D. backup archivelog, database, controlfile delete input;
E. backup database plus archivelog delete input
F. e
G. a, b, a, c
H. d
I. b, a, c
J. b, a, c, d, e
Answer: A
Steps
A. backup archivelog all;
B. backup database all;
C. backup controlfile;
D. backup archivelog, database, controlfile delete input;
E. backup database plus archivelog delete input
Options
A. e
B. a, b, a, c
C. d
D. b, a, c
E. b, a, c, d, e
Answer A
Given the following steps, which would be the correct order to create a backup of an Oracle
database in ARCHIVELOG mode with control-file autobackups enabled?
Steps
A. backup archivelog all;
B. backup database all;
C. backup controlfile;
D. backup archivelog, database, controlfile delete input;
E. backup database plus archivelog delete input
Options
A. e
B. a, b, a, c
C. d
D. b, a, c
E. b, a, c, d, e
Answer A
Step e is the best step, however it does delete the archivelog as it backs them up, not sure if this is necessary.
Answer is A
case for A:
http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta007.htm#RCMRF107
Note: If you run BACKUP ARCHIVELOG ALL, or if the specified log range includes logs from prior incarnations, then RMAN backs up logs from prior incarnations to ensure availability of all logs that may be required for recovery through an OPEN RESETLOGS.
This could work if you had all of the archivelogs since the last datafile backup (assuming that this is available). However you would have to have a LOT of space to store them (prior incarnations or not) and a LOT of time to restore them. Not to mention other considerations you would have to make as the number of tablespaces/datafiles grows, NOLOGGING activities etc… hey didn’t someone say “we study Oracle Administration to make life easier on ourselves”?
I’d reconsider option E.