RMAN> backup current controlfile;
Starting backup at 10-DEC-23
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=55 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 10-DEC-23
channel ORA_DISK_1: finished piece 1 at 10-DEC-23
piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/012dlsh6_1_1 tag=TAG20231210T084525 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 10-DEC-23
Starting Control File and SPFILE Autobackup at 10-DEC-23
piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/c-2926183155-20231210-00 comment=NONE
Finished Control File and SPFILE Autobackup at 10-DEC-23
Going ABF
A: since the question says "by using RMAN", I won't consider a User Managed Backup by copying the SPFILE, what means that I have to used "BACKUP SPFILE". And AUTOBACKUP always backs up the control file after a BACKUP command, so A is correct.
I'm considering E wrong because if the database is running in NOARCHIVELOG mode the autobackup won't run after a structural change.
E is true because of datafiles of tablespace. Datafiles are physical structures and controlfile contains information of physical structures. New entry in controlfile means new autobackup
For non-CDBs, if CONFIGURE CONTROLFILE AUTOBACKUP is ON, then RMAN automatically backs
up the control file and the current server parameter file (if used to start the database) after a
successful BACKUP command. For CDBs and standalone databases with the COMPATIBLE
initialization parameter set to 12.0 or higher, by default, the control file autobackup is turned
on.
Chapter 8
About RMAN Control File and Server Parameter File Autobackups
8-15
If the database runs in ARCHIVELOG mode, RMAN makes control file autobackups when
a structural change to the database affects the contents of the control file.
Oracle Database 12c Release 2 (12.2) DBUA : Understanding New Changes / Features (Doc ID 2171985.1)
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
antonica
3 months, 2 weeks agoShunpin
7 months, 1 week ago8111
9 months, 2 weeks agopiontk
10 months ago_gio_
1 year ago_gio_
10 months, 4 weeks agoScottL
1 year, 2 months agohilaire
1 year, 6 months agoilputto
1 year, 6 months agoilputto
1 year, 6 months ago