Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)
A.
Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in the MOUNT state.
B.
Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in MOUNT state.
C.
An Oracle database can be restored from backup files copied using O/S utilities.
D.
Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.
E.
Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.
F.
Oracle archive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.
G.
Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in OPEN state.
A,B,G are not right because the question is telling us 'without RMAN'. To put it in mount/open or so, are necessary only in case of using RMAN. Otherwise, using OS Utils, DB must be closed or maximum in NOMOUNT state.
Agree
F is incorrect as according to the following note only archivelog, backuppiece, controlfilecopy or datafilecopy can be cataloged
https://docs.oracle.com/cd/B19306_01/backup.102/b14194/rcmsynta011.htm
Generally, I agree with you.
However, back to the Oracle 9 when RMAN is not available. We can backup the DB (with archive log enabled) which is opened in read/write mode using OS copy command. (I am sure about that because my company used this for Oracle 9 online backup). what you need to do is something like following:
1. Execute "ALTER TABLESPACE tb_name BEGIN BACKUP;" for each tablespace before the backup start.
2. Copy files
3. Execute "ALTER TABLESPACE tb_name END BACKUP;" for each tablespace after the backup end.
https://docs.oracle.com/cd/B10501_01/server.920/a96572/osbackups.htm
But answere G states that it is REQUIRED to have the database Open, while what you said proves you simply CAN do that with the db open. Nothing prevents backing up the database via OS copy when it's shutdown.
Agree but it is not mentioned in G. It should have said: ...the database OPEN, and a command ALTER DATABASE... BEGIN BACKUP executed. Then you can copy the files with OS utils.
Captain here
Backing up a database with OS utilites can be performed only when the database is shut down, so...
A, B, G are incorrect
OS copies are not backupsets, so again F is incorrect.
It remains CDE that should be correct.
The question is:
'...about backup, restore, and recovery operations done WITHOUT using Recovery Manager (RMAN)?' Think only about the use of OS utilities here. I would disregard DF since it speaks about 'adding' the OS taken backup to RMAN.
If RMAN is not an option at all, I believe the correct answers are CEG
E: Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down. --> OS-Backup is possible when the DB is in nomount/mount state, too ...so i think E is not correct
i go with CDF...
why f: you can recatalog any backup to rman catalog....
E is correct per <https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/user-managed-database-backups.html#GUID-65C5E03A-E906-47EB-92AF-6DC273DBD0A8>
If you run the database in NOARCHIVELOG mode, however, then the backup must be consistent; that is, you must shut down the database cleanly before the backup.
I think C,E,G is correct -
E - before mount you must shutdown
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/user-managed-database-backups.html#GUID-65C5E03A-E906-47EB-92AF-6DC273DBD0A8
You can make a whole database backup if a database is operating in either ARCHIVELOG or NOARCHIVELOG mode. If you run the database in NOARCHIVELOG mode, however, then the backup must be consistent; that is, you must shut down the database cleanly before the backup. "
CDE ?
C doesn't specified if the backup files where copied with the database closed.
i think A and B are incorrect, the database must be closed in order to do a backup with o/s utilities
ADG
A is correct, and E incorrect -> with NOARCHIVELOG must be in MOUNT state https://orahow.com/backup-oracle-database-in-noarchivelog-mode/ however with ARCHIVELOG must be OPEN, so that G is correct and B and is incorrect and D is correct too https://docs.oracle.com/html/E10643_07/rcmsynta008.htm, I think C is incorrect.
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.
janw
Highly Voted 3 years, 5 months agojulica
Highly Voted 3 years, 7 months agoMastino69
3 years agoAlejandrrro
2 years, 11 months agohkshado
3 years, 3 months agoSimoneF
2 years, 9 months agoMastino69
3 years agopiontk
Most Recent 5 months ago_gio_
5 months, 2 weeks agoScottL
9 months, 1 week agojareach
11 months, 4 weeks agoBio12345
1 year, 11 months agosmartvan
2 years, 3 months agoNeil107
2 years, 5 months agoSchmeili
3 years, 2 months agobrolem
1 year, 9 months agocerebro2000x
3 years, 5 months agomik8440p
3 years, 6 months agologica
3 years, 7 months agoald85
3 years, 7 months agoveginha
3 years, 7 months agoald85
3 years, 7 months ago