Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens?()
In your database, online redo log files are multiplexed and one of the members in a group is lost due to media failure? How would you recover the lost redo log member?()
When you are allowing RMAN to backup your archived redo log files,how does RMAN know which archived redo logs to back up from your archive log destination?()
Which of the following commands can be used to gain root privileges and profile without initially logging in as root?()
Which is the correct command to back up the database, back up the archived redo logs, and then remove the backed-up archived redo logs?()
Which of the following commands can be used to watch system errors as they are logged?()
What is the maximum number of ARCn processes that can be defined using the initialization parameter LOG_ARCHIVE_MAX_PROCESSES?()
Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens? ()
You configured the Flash Recovery Area for your database. The database instance has been started inARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications onthe archiving and the location of archive redo log files()
You notice that your RMAN script used to copy the datafiles, control files, and archived redo log files is performing very slowly. Which two changes might you want to include in your RMAN script to speed up the COPY commands?()
You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? ()
How can a JFS2 filesystem be added to a volume group that has insufficient space to host a log LV?()
During recovery, you need to know if log sequence 11 is in the online redo logs, and if so, you need to know the names of the online redo logs so you can apply them during recovery. Which view or views would you use to determine this information?()
You have implemented OMF for redo log management. Which of the following choices reflects a log filename that might be employed when OMF is enabled?()
A user in the op_storage group logs onto the DS GUI and goes to the User Administration panel. Which users can be seen and what actions can be performed()
Which of the following parameters defines the location where Oracle should create archived redo logs?()
Which of the following commands can be used to review the system error logs?()
A System p administrator needs to run the annualreval.sh script, directing standard error to /var/log/reval.err, and appending standard out to /var/log/reval.log. How can this be accomplished ()
Which statement is true regarding the Archiver (ARCn) process,archived log files,and recovery? ()
The online redo log group configuration for your database is as follows: What will happen if the online redo log file ’ora02/oradata/redo02b.log’is corrupted while working on the database?()
One of the redo log members in your database is lost. You queried V$logfile for further details. What would be the member’s status?()
As soon as you discover that you have lost an online redo log, if the database is still functioning, what should be your first action?()
If you lost your entire database,including the database spfile,control files,online redo logs,and database datafiles,what kind of recovery would be required with RMAN?()
In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?()