Oracle Recovery Manager (RMAN) satisfies the most pressing demands of performance, manageable backup and recovery, for all Oracle data formats. RMAN provides a common interface, via command line and Enterprise Manager, for backup tasks across different host operating systems. The RMAN command for making backups is Backup. The RMAN BACKUP command supports backing up the following types of … Read more
Check the status of the cluster Check the status of the services on the cluster Stop crs on all nodes (only one node up in this example) Stop crs on specifc node Disable CRS from starting on reboot Enable CRS to start on reboot Start crs on specific node Check database status Stop an instance … Read more
1) Information of database (Primary & Standby). 2) To display current status for Physical Standby Database background processes. 3) Check for messages/errors 4) Show received archived logs on physical standby 5) To check the log status 6) To display various information about the redo data. 7) Verify the last sequence# received and the last sequence# … Read more
The Data Buffer Hit Ratio Oracle metric is a measure of the effectiveness of the Oracle data block buffer. The higher the buffer hit ratio, the more frequently Oracle found a data block in memory and avoid a disk I/O. The buffer hit ratio (BHR) indicates the current ratio of buffer cache hits to total requests, essentially … Read more