Your database is in NOARCHIVELOG mode. You start to do a backup, but your users
complain that they don’t want you to shut down the database to perform the backup. What
options are available to you?
A.
Put the database in hot backup mode and perform an online backup, including backing up
the archived redo logs.
B.
Just back up the database datafiles without shutting down the database.
C.
You will have to wait until you can shut down the database to perform the backup.
D.
Mark each datafile as backup in progress, back them up individually, and then mark them
as backup not in progress. No archived redo logs will need to be backed up.
E.
Only back up the datafiles that the user will not be touching. Once the user has finished
what they were doing, you can shut down the database and back up the datafiles the user
changed during the course of the remaining backup
i think the correct answer is between C and E
E is totally wrong. C is the only option with no archive.
@cuco is correct, backing up datafiles that users are not touching is not good enough, this is because the checkpoint process is continually updating the tablespaces datafile headers with information including the latest SCN.