How to change RMAN backup location
How to Change RMAN backup location If you want to change your database RMAN Backup configuration please follow below steps: NOTE: Database must be in archivelog mode. If database not in archive log… Read more »
Author Archives: Pankaj Yadav
Database and server details Report from OEM
Database and server details Report from OEM: 1- How do get the number of databases for each category version? SELECT property_value, COUNT(*) FROM mgmt$target_properties WHERE target_type = ‘oracle_database’ AND property_name… Read more »
Database RMAN backup report
OEM Management view: Whenever OEM Grid control is being practiced to monitor a majority of your databases and whenever RMAN is being used to take backup of the databases ‘either… Read more »
Cross-Platform Database Migration
Cross Platform Database Migration Window’s To Linux: 1-To convert the database from one platform to another, the endian format of both databases should be the same. So as a first… Read more »
Convert Single Instance database to 2 Node RAC
Convert Single Instance Database to 2 Node RAC oracle 10g / 11g. Install Clusterware on the nodes on which node you want to setup RAC . Install Oracle Database 10g… Read more »