My friend Franck Pachot noticed that EM12c doesn’t show the blocking sessions across all RAC nodes.
As Franck told, I couldn’t see any blocking sessions although I checked both instances.
Slideshare uses cookies to improve functionality and performance, and to provide you with relevant advertising.
Write for OTN Earn money and promote your technical skills by writing a technical article for Oracle Technology Network. One of my friend told me that they used to have Oracle Enterprise Manager Grid Control 10g and deployed its agents to some database servers but now they removed Grid Control and want to use Oracle Enterprise Manager Database Console. After we uninstall the agent, we’re ready to reconfigure Enterprise Manager Database Control. The steps and commands in listed in document are they executed on the Target server or on the OMS server?
Please could you identified for me which of the proceedure on the document are executed on the Target server and which one are executed on the OMS serevr.
I rerun the process again after deleting and recreating the agent12c directory per your instruction. However, before I could get the SEs to run the scripts as root for me on the server, the system timed out on me. If you can’t deinstall your agent with runInstaller (because your deployment is broken), you may delete the directory of the agent and re-deploy the agent to another directory. In other word you want me to delete “agent12c” directory I created before the deployment of the agent on the target server?
You shouldn’t ignore the prerequisites, you should try to fix them before you deploy the agent.
I have connected to first node of our RAC database, created a sample table, inserted a row, committed, and then deleted the row.
While the session is open, I opened another terminal, connected to second node and tried to delete the rows in same table so my second session started to wait for the transaction of my first session completed. The scripts are placed in a shell script wrapper at the Unix level, and then scheduled using the Unix cron job facility. As and when Oracle releases new versions of the Oracle database, the future versions of the Oracle Enterprise Manager database plug-in would automatically cater to the new release, and any special feature in that release, making RMAN script maintenance unnecessary. This is an incremental level 0 cumulative backup that can be used as the basis of an incremental backup strategy. New RMAN features (such as compression, encryption, block change tracking, etc.) would be available when setting up the backup in Enterprise Manager itself. After this database backup is completed, a control file and SPFILE autobackup are also created, because we identified earlier that we wanted these files to be automatically backed up with each backup.
This results in time and cost savings due to increased productivity and automation of the entire approach.
After successful backup, RMAN deletes the archivelogs from their disk location because of the included delete input clause.
During such a recovery-complete or incomplete-Oracle uses the archive logs to apply all the changes, so as to restore the database to any point of time (the main purpose of archive logging). When the home page appears (make sure you are logged in to the database with SYSDBA credentials), set up the Fast Recovery Area (FRA) to help automate the backups. In the past, DBAs had to perform a manual restore of the archive logs from their compressed Unix tape archiving (or tar) archives and then place the restored archive logs in a directory accessible by the Oracle-controlled recovery.

This kind of manual searching and restoring of the archive logs is no longer needed in the case of RMAN, which automatically locates the archive log backup sets needed and extracts the archive logs required for the recovery.
The first two subdirectories will be used for the backup and the autobackup, and the archivelog subdirectory will be used to store normal archive logs that are generated by the database in archivelog mode.
It is possible to resize the FRA later on, but if it runs out of space, archive logs (if in Archivelog Mode) may stop being generated, and the database will not process any transaction after that unless the space issue is resolved.
This happens every time a backup is taken and if the directory structure up to the day level doesn't exist, it is created. As we can see in the RMAN output, another control file and SPFILE autobackup takes place after the archive logs backup.
Once configured, these autobackups will automatically occur after any RMAN database backup or archive logs backup completes. The names of the backup files and archive log files have been catalogued by RMAN and exist as entries in the control file records.
During the RMAN maintenance activities that are started by the maintenance commands you included (including the extra ones we had listed), these entries are crosschecked to verify that they physically exist on disk. Selecting a larger parallelism will increase the number of concurrent RMAN streams to the disk backup location; use this feature with care, since it depends on how much the disk can handle.
Using such a setting will increase the speed of the backup, but this will also depend on the disk subsystem structure. Similarly, since the database backup, archivelog backup, and the autobackup in this job have succeeded, the entries of the previous backup and autobackup files are checked to see if they still need to be retained, as per the retention policy.
In the case of obsolete records, the actual physical backup files are also deleted from the disk. The test will write some test backup files to the disk backup location, and let you know if successful.
Oracle's integrated secure tape backup management system, OSB provides an alternative to third-party tape backup solutions that may not be tightly integrated with Oracle RMAN and Oracle Enterprise Manager. This will create a level 1 cumulative incremental backup, as opposed to the level 0 backup that is taking place each Sunday. Since you are using the nocatalog mode of RMAN, it is of utmost importance to ensure the safety of the control file and make certain it is backed up, because the control files contains the history of all the backups.
Consequently, an incremental cumulative backup will be performed daily that updates the datafile copies with all the changes.
This feature was introduced in Oracle 10g and helps considerably to increase the speed of incremental backups, since all database block changes are tracked in this special file (only tens of MB in size). The RMAN process in this case will not need to scan the entire datafile for changed blocks, when taking incremental backups. The advantage is that you can easily switch over to this backup and use it as a production database in the case of an emergency, without any restore of the backup or recovery of the database. However, when the database size is more than, say, 200 GB, it is time to rethink your backup strategy.
Select Retain at least the specified number of full backups for each datafile, and enter 1 as the number of backups to retain at any one time - this is your redundancy. And regular testing of your RMAN backup of all your databases is one of the DBA's mandatory responsibilities. In this case, backups would be retained to allow recovery of the database up to the specified number of days. You can adopt a better backup strategy by taking a full database backup once a week on a Sunday and then an incremental database backup Monday through Saturday.

You must take into account the following: The total size of the database The types of backups taken each day (full or incremental) The amount of archive logs generated each day (since archive log backups are also included) The amount of finite space allocated to the database's FRA The database administrator must keep all these factors in mind, and closely monitor the database backup space available over the next few weeks, adjusting the Recovery Window if required or changing the Retention Policy to Redundancy instead of a Recovery Window. Assuming that the FRA is set, the archived redo logs that have been backed up and are obsolete as per the retention policy will be deleted by the RMAN maintenance commands. You can take an image copy of all the datafiles of a database once in a while, and then take an incremental backup each day that will actually refresh the image copy of the database with all the incremental changes. The datafile copies become the same as in production, since they are being brought up to date each day when the incremental backup is run.
Technically, you have managed a recovery of the database without performing a restore of the files from backup, and this makes the entire recovery faster and simpler. If you use a backup strategy like this, which is based on incrementally updated backups, it can help minimize the media recovery time of your database.
This option deletes the archived redo logs that have been applied or shipped to all remote destinations, and also deletes archived logs after considering whether the specified number of archived log backups have been backed up to a tertiary device. This facility is visible and easily understandable if Oracle Enterprise Manager is used to schedule RMAN backups. In the case of a standby database, there are three main options: None Delete archived redo log files after they have been applied to the standby database Delete archived redo logs after they have been backed up the specified number of times.
You can now set up the level 1 incremental backup for every weekday as before, but with this refreshing of the image copy as well, to keep the image copy up-to-date with your production database.
Backup optimization is ON, controlfile autobackup is ON, and there is a parallelism of 1 using a compressed backupset.
The DBA can then perform a fast recovery from the available disk-based backup, in case of any production issues, rather than waiting for the tape to be located and the tape backup to be restored to the disk. We are going to set up a full backup of this type on Sundays, as well as a daily incremental backup of the database.
To delete backups marked as obsolete (as per the retention policy), select Delete obsolete backups.
Backup Encryption was first introduced in Oracle Database 10g Release 2 and is available for all later versions.
You must make sure you are licensed to use this option, because being licensed for the Oracle Database Enterprise Edition (EE) does not automatically mean you are licensed to use the Advanced Security Option. Also, there will be greater flexibility since you can use either the wallet or the password when the RMAN backup needs to be restored.
For example, if you select days as the frequency type and 1 as the frequency, the back up will run once every day at the time you have specified. We suggest 3 AM the following morning so that the backup will start at this time of low activity. The archive logs are deleted after backup, after which the maintenance commands that delete obsolete diskbackups are executed. These actions are derived from what we previously specified in the Cloud Control backup setup and backup schedule wizard pages. Nevertheless, you may want to change the RMAN script to include extra maintenance commands that will crosscheck backups and archivelogs, and delete the backups and archivelogs that have expired.

Cloud storage wish list
Free cloud storage for all amazon content manager
Make clouds your room rates
Free signup affiliate programs 90s


  1. 29.07.2016 at 18:16:22

    Save any type of file recovery with deduplication solutions.

    Author: Y_A_L_A_N_C_I
  2. 29.07.2016 at 17:52:41

    Integration with Active Directory and LDAP google, meanwhile, is planning to open 12 new the.

    Author: TT
  3. 29.07.2016 at 16:25:43

    Enterprises, petabyte (PB) storage real-time application based clouds.

    Author: Santa_Banta
  4. 29.07.2016 at 21:22:13

    Indicate how much of the time a data drive only has about 3.5.

    Author: Naile