Which three types of backups can be performed for a database running in NOARCHIVELOG mode?
Which three statements are true about Flashback Data Archive?
Examine the RMAN commands:
RMAN> CONNECT TARGET “sbu@prod AS SYSBACKUP”;
RMAN>CONNECT AUXILIARY “sbu@dup_db AS SYSBACKUP”;
RMAN >DUPLICATE TARGET DATABASE TO dup_dbFROM ACTIVE DATABASE
SECTION SIZE 400M;
Which statement is true about the DUPLICATE command?
Your database is running in ARCHIVELOG mode and flashback is enabled.
In which scenario must you use RMAN backups for recovering tables and table partitions?
In your database, the user SCOTT wants to retrieve the dropped HR. EMPLOYEES table by using the command:
SQL> FLASHBACK TABLE HR.EMPLOYEES TO BEFORE DROP;
What are three prerequisites for this command to succeed?
Which two are prerequisites for performing Flashback Transaction?
You use RMAN to take regular backups for your database.
Examine the RMAN commands:RMAN> CROSSCHECK BACKUP;
RMAN>DELETE EXPITED BACKUP;
Which statement is true?
You are performing regular backups of your production database by using a recovery catalog.
You add two new tablespaces to your production database after performing a backup. They must be included in future backups.
Which action should you perform?
Your database is running in archivelog mode. Examine the parameters for your database instance:
LOG_ARCHIVE_DEST_l =’LOCATION=/disk1/arch MANDATORY’
LOG_ARCHIVE_DEST _4 =’LOCATIONs/disk4/arch’
LOG_ARCHIVE _MIN_SUCCEED_DEST = 2
While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not available. All redo log groups have beenused.
What happens at the next log switch?
Which two operations are NOT performed by the DUPLICATE command in RMAN while duplicating a database that is open?