You are administering a database that supports a data warehousing workload and is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 incremental backups on all the other days of the week.
One of the data files is corrupted and the current online redo log file is lost because of a media failure.
Which action must you take for recovery?
See Example 3-6 Recovering a NOARCHIVELOG Database STARTUP FORCE NOMOUNT; RESTORE CONTROLFILE; # restore control file from consistent backup ALTER DATAB ASE MOUNT; RESTORE DATABASE; # restore data files from consistent backup RECOVER DATABASE NOREDO; # specify NOREDO because online redo logs are lost ALTER DATABASE OPEN RESETLOGS;
References: https://docs.oracle.com/database/121/RCMRF/rcmsynta2001.htm#RCMRF140
Examine the commands:
SQL> ALTER SESSION SET RECYCLBIN = ON;
Session altered.
SQL> DROP TABLE emp; --(First EMP table)
Total dropped.
SQL> CREATE TABLE emp (id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name VARCHAR2 (15), salary NUMBER(7,2) );
Table created.
You then execute multiple INSERT statements to insert rows into EMP table and drop the table again:
SQL> DROP TABLE emp; -- (Second EMP table)
Table dropped.
SQL> FLASHBACK TABLE emp TO BEFORE DROP;
Which statement is true about the FLASHBACK command?
Your database supports an OLTP workload. Examine the output of the query:
SQL> SELECT target_mttr, estimated_mttr
FROM v$instance_recovery
Target_mttr estimated_mttr
---------------------- ---------------------------
0 76
To ensure faster instance recovery, you set the fast_start_mttr_target initialization parameter to 30.
What is the effect of this setting on the database?
Identify three scenarios in which RMAN will use backup sets to perform active database duplication.
Starting with Oracle Database 12c Release 1 (12.1), RMAN can use backup sets to transfer the source database files that need to be duplicated. The backup sets are transferred over the network to the auxiliary database. Backup sets can be encrypted for additional security. Specify the encryption algorithm by using the SET ENCRYPTION ALGORITHM command before the DUPLICATE command. RMAN uses backup sets to perform active database duplication when the connection to the target database is established using a net service name and any one of the following conditions is satisfied: The DUPLICATE ... FROM ACTIVE DATABASE command contains either the USING BACKUPSET, USING COMPRESSED BACKUPSET, or SECTION SIZE clause. The number of auxiliary channels allocated is equal to or greater than the number of target channels allocated.
References:
http://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV298
