Recovery of Non-system Datafile without backup using rman in 11gR2

Assumption :- For tablespace RECOVERY one datafile is backedup using rman and other datafile is not backedup. 1.. Create tablespace called RECOVERY with one datafile recovery01.dbf 2.. Take full backup of Database using rman Now again add a new datafile as recovery02.dbf to RECOVERY Tablespace that you have created. 3.. For testing purpose create a … Continue reading Recovery of Non-system Datafile without backup using rman in 11gR2

Ways to find report or package file version in Oracle E-Business Suite….

1.. ADIDENT Utility :-  ADIDENT Utility in ORACLE application is used to find version of any file. Syntax: - adident Header <file_name> 2.. STRINGS Utility Strings is a UNIX based utility which is used to print the strings of printable characters in files and can be used to extract header information from the string content … Continue reading Ways to find report or package file version in Oracle E-Business Suite….

Ways to find Out DBID of Oracle Database in 11gR2

DBID stands for database identifier which is a unique identifier for each oracle database running in your server. DBID information is found in control files as well as datafile header. If the database is up and running then DBID can be found from v$database or while connecting to rman target / 1.. If Oracle Database … Continue reading Ways to find Out DBID of Oracle Database in 11gR2

Restore and Recovery of Redo log files complete loss in 11gR2

1.. Check name , open mode and log mode of database 2..  Check online redo log file group, redo log file name and size 3..  To simulate go to redo log location and delete redo log file 4..  Check Archive log is enabled or not 5.. Alter switch syntax will hang Error in Alert log … Continue reading Restore and Recovery of Redo log files complete loss in 11gR2