RMAN incremental backup
RMAN incremental backup RMAN Command rman> report need backup; The report need backup command tells you that you must back up which all database files to comply with your retention… Read more »
ORA-28003, ORA-20002 while changing password
ORA-28003, ORA-20002 while changing password Error: While changing user password ORA-28003 and ORA-20002 raised. sys@prod1>alter user DEVTEST identified by oracleworlds; alter user DEVTEST identified by oracleworlds * ERROR at line 1: ORA-28003:… Read more »
How to get table and index DDL in Oracle
How to get table and index DDL in Oracle? To get all table and indexes for the EDS table, we execute dbms_metadata. get_ddl, select from DUAL, and providing all required… Read more »
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 »
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 »