Every Sunday the Unix system administrator has a job that executes a full backup of the
entire Unix system your database is on. Is this backup usable for backup and recovery of
your database?
A.
Yes, if the database is in ARCHIVELOG mode.
B.
Yes, if the database is in NOARCHIVELOG mode.
C.
No, the backup is not usable in any way.
D.
Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE.
This question is ambigious
Yes the backup could work if the database is in ARCHIVELOG mode and if the administrator used commands similar to
SQL> ALTER DATABASE BEGIN BACKUP;
use OS commands to back up database here
SQL> ALTER DATABASE END BACKUP;
the entire unix system includes the operating system not just the database.
while SQL> ALTER DATABASE BEGIN BACKUP;
backs up just the database.
@King,
The entire unix system includes the OS + database + all files
Also
SQL> ALTER DATABASE BEGIN BACKUP;
does NOT back up the database. It tells Oracle that you are going to run a user backup so it can prepare itself.
I suggest you read the documentation at
http://oracle.su/docs/11g/backup.112/e10642/osbackup.htm
the questions is pretty clear, its a os file level backup, its not usable in any way for recovering a database.
C is correct.
Yes there are steps you can take to have file level backup that is usable but that is not the question.