nerdexam
Oracle

1Z0-062 · Question #238

Your database instance has started using an SPFILE. Examine the RMAN configuration settings: You execute the command: RMAN> BACKUP AS COPY TABLESPACETEST; Which three types of files are backed up by u

The correct answer is B. control file C. SPFILE E. data file(s). When backing up a tablespace using RMAN with BACKUP AS COPY, the data files of the specified tablespace, the control file, and the SPFILE (if in use) are included in the backup.

Performing Backup and Recovery

Question

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

You execute the command:

RMAN> BACKUP AS COPY TABLESPACETEST; Which three types of files are backed up by using this command?

Options

  • Aonline redo log files
  • Bcontrol file
  • CSPFILE
  • Darchived redo log files
  • Edata file(s)
  • FPFILE

How the community answered

(48 responses)
  • A
    2% (1)
  • B
    75% (36)
  • D
    8% (4)
  • F
    15% (7)

Why each option

When backing up a tablespace using RMAN with BACKUP AS COPY, the data files of the specified tablespace, the control file, and the SPFILE (if in use) are included in the backup.

Aonline redo log files

Online redo log files are never backed up by RMAN because they are continuously being written to and are only truncated after being archived.

Bcontrol fileCorrect

RMAN automatically backs up the control file when performing a backup of data files or tablespaces, ensuring that the necessary metadata for recovery is available.

CSPFILECorrect

When the database is using an SPFILE, RMAN automatically backs up the SPFILE along with the control file and data files, as it is crucial for instance startup.

Darchived redo log files

Archived redo log files are not included in a BACKUP TABLESPACE command unless specifically requested with clauses like PLUS ARCHIVELOG or a separate BACKUP ARCHIVELOG command.

Edata file(s)Correct

The BACKUP AS COPY TABLESPACE TEST command explicitly instructs RMAN to create image copies of all data files belonging to the TEST tablespace.

FPFILE

A PFILE is a static text file and is not used when an SPFILE is active; RMAN backs up the SPFILE, not an unused PFILE.

Concept tested: RMAN backup scope for tablespace

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/BACKUP.html#GUID-E5652570-5F33-4010-B147-386C8690D4D3

Topics

#RMAN#backup#tablespace backup#control file#SPFILE

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice