Prev Question
Next Question

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?

Put the database in hot backup mode and perform an online backup, including backing up the archived redo

Just back up the database datafiles without shutting down the database.

You will have to wait until you can shut down the database to perform the backup.

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.

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

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *