You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). RMAN is connected to CDB$ROOT. Examine the command: RMAN> LIST FAILURE; Which statement is true about this command?
A.
It lists failures only for the CDB root database.
B.
It lists failures for a PDB only when RMAN is connected to a recovery catalog.
C.
It lists failures for the CDB and all the PDBs in this CDB.
D.
It lists failures only if RMAN is connected to a PDB.
Suggested Answer:A🗳️
In the current release, Data Recovery Advisor can only be used to diagnose and repair data corruptions in non-CDBs and the root of a multitenant container database (CDB). Data Recovery Advisor is not supported for pluggable databases (PDBs). Note: You can run the LIST FAILURE command to show all known failures. References: https://docs.oracle.com/database/121/BRADV/rcmrepai.htm
ASMCMD [+data1/cdb/9BF24BE2DF883C4BE0534601E80A562D/datafile] > rm -fr DUPA.270.1031161263
rman target sys/sys@CDB
connected to target database: CDB (DBID=214)
RMAN> list failure;
Failure ID Priority Status Time Detected Summary
362 HIGH OPEN 03-FEB-20 One or more non-system datafiles are missing
RMAN> advise failure;
Failure ID Priority Status Time Detected Summary
362 HIGH OPEN 03-FEB-20 One or more non-system datafiles are missing
analyzing automatic repair options; this may take some time
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=21 device type=DISK
analyzing automatic repair options complete
Optional Manual Actions
=======================
1. If file +DATA1/CDB/9BF24BE2DF883C4BE0534601E80A562D/DATAFILE/dupa.270.1031161263 was unintentionally renamed or moved, restore it
Automated Repair Options
Option Repair Description
1 Restore and recover datafile 23
Strategy: The repair includes complete media recovery with no data loss
Repair script: /u01/app/oracle/diag/rdbms/cdb/CDB/hm/reco_2248120728.hm
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.
hilaire
3 years, 4 months agoKalinos20
4 years, 10 months agosherifelia
4 years, 10 months agogracee
4 years, 11 months agoSugar
4 years, 5 months agoalipilot2006
5 years, 7 months ago