Examine the RMAN command:
RMAN> BACKUP VALIDATE DATABASE;
Which statement is true about the execution of the command?
A.
Block change tracking must be enabled before executing this command.
B.
The database must be running in archivelog mode for the successful execution of this
command.
C.
A complete database backup must exist before executing this command.
D.
The command checks for blocks containing all zeros, an invalid checksum, or a corrupt
block header.
E.
The command checks for blocks that contain a valid checksum and matching headers and
footers, but that has logically inconsistent contents.
B
RMAN> BACKUP VALIDATE DATABASE;
Starting backup at 13-AUG-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 08/13/2015 22:13:59
RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode
I think D. You can mount (not open) your db and run the command.
Hi Puntano,
Not sure why you are getting error RMAN-06149 in no archivelog mode, I tested same it worked for me in no archiveloglog mode only.
it behaves differently in 11g and 12c.
it did success in 11g but fails in 12c while in noarchivelog mode.
It will succeseed in nonarchive log mode
just put the database in Mount state
It is explained in Oracle 12c: Backup and recovery workshop , Activity Guide
B,D (B experimentally tested for 12c and D – quotation from official documentation for this command)
Which one is correct?
As Siegried is saying I would go for D
Thanks Feedback
It is a bug : see Metalink ( RMAN-06149 DURING VALIDATE DATABASE IN NOARCHIVELOG MODE AND DB IS OPEN VERSION 12.1.0.2 (Doc ID 2018595.1))
So answer is D
B:
RMAN> BACKUP VALIDATE DATABASE;
Starting backup at 06-MAR-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=368 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 03/06/2016 09:37:37
RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode
RMAN>
Perhaps your database is open? It must be mounted in NOARCHIVELOG mode, to be able to create a backup.
D
rman target /
Recovery Manager: Release 12.1.0.2.0 – Production on Wed Jun 15 14:52:08 2016
Copyright (c) 1982, 2015, Oracle and/or its affiliates. All rights reserved.
connected to target database: G01 (DBID=3805337024, not open)
RMAN> select log_mode from v$database;
using target database control file instead of recovery catalog
LOG_MODE
————
NOARCHIVELOG
RMAN> select open_mode from v$database;
OPEN_MODE
——————–
MOUNTED
RMAN> backup validate database;
Starting backup at 15-JUN-16
allocated channel: ORA_DISK_1
…
Finished backup at 15-JUN-16
D
D