Which three types of files are backed up by using this …

Your database instance has started using an SPFILE.
Examine the RMAN configuration settings:

You execute the command:
RMAN> BACKUP AS COPY TABLESPACE TEST;
Which three types of files are backed up by using this command?

Your database instance has started using an SPFILE.
Examine the RMAN configuration settings:

You execute the command:
RMAN> BACKUP AS COPY TABLESPACE TEST;
Which three types of files are backed up by using this command?

A.
online redo log files

B.
control file

C.
SPFILE

D.
archived redo log files

E.
data file(s)

F.
PFILE

Explanation:
http://www.juliandyke.com/Research/RMAN/BackupCommand.php



Leave a Reply 2

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


Richard

Richard

The correct answers should be B, D, and E. You use BACKUP AS COPY to back up to disk as image copies.

— Backup sets —
Default option
Oracle proprietary backup
format
Can store datafile, archivelog,
controlfile, spfile
Incremental Backups
Can be compressed, encrypted
Various optimizations
History and automatic retention
Multisection
RMAN Backup Methods

— Image Copies —
Just exact copies of
datafiles, archived log
files or control file
No compression
NO encryption
No history
No optimizations
Can be incrementally
refreshed