Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member.When you attempt to start the database, you receive the following errors:ORA-00313: open failed for members of log group 1 of thread 1ORA-00312: online log 1 thread 1: 'D:\REDO01.LOG'You discover that the online redo log file of the current redo group is corrupted.Which statement should you use to resolve this issue?
The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:LOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1/archive'LOG_ARCHIVE_DEST_2 = 'SERVICE = stdb1'DB_RECOVERY_FILE_DEST = '/u01/oradata'Examine the following RMAN command issued to set the deletion policy for archived log files:RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO sbt;Which statement is true regarding what this command accomplishes?
You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option.After some days, you want to change the status of the database backup and you issued the following command:RMAN>CHANGE BACKUPSET 231 NOKEEP;What is the implication of this command?
You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is (jetting filled up very fast and it is running out of space. Your database flash recovery area is low on specie and you have no more room on disk.Proactively, which two options could you use to make more space available in the flash recovery [Choose two]
Consider the following scenario for your database:- Backup optimization is enabled in RMAN.- The recovery window is set to 7 days in RMAN.- The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.- The TOOLS tablespace is read-only since November 4, 2007.On November 23, 2007, you issue the RMAN command to back up the database to disk.Which statement is true regarding the backup of the TOOLS tablespace?
The INV_HISTORY table is created using the command:The following data has been inserted into the INV_HISTORY table:You would like to store the data belonging to the year 2006 in a single partition and issue the command:SQL> ALTER TABLE inv_history -MERGE PARTITIONS -FOR(TO_DATE('15-feb-2006','dd-mon-yyyy')),FOR(TO_DATE('15-apr-2006'))INTO PARTITION sys_py;What would be the outcome of this command?
