Monthly Archives: August 2013

Recovery of Online Redo log file

1- Check existing online Redo log file SQL> select * from v$Logfile; GROUP# STATUS  TYPE    MEMBER 2 ONLINE C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_91MVD8GZ_.LOG YES 1 ONLINE C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_91MVD6TJ_.LOG YES 2- Add one more Redo log group to database. SQL> ALTER DATABASE ADD LOGFILE ‘C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\Redo_-01_03.LOG’ … Continue reading

Posted in rman | Leave a comment

rman recovery if the missing archive logs are required for recovery

1- ———Restore the database —————– RMAN> restore database; Starting restore at 25-AUG-13 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00001 to C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF channel ORA_DISK_1: … Continue reading

Posted in rman | Leave a comment

rman backup and Recovery, if all archive logs and redo logs are available

1-  ————Take Rman Backup——————- RMAN> run 2> { 3> ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT ‘C:\oraclexe\rman\rman%U’; 4> backup AS COMPRESSED BACKUPSET tag Full_database_open database; 5> } using target database control file instead of recovery catalog allocated channel: disk1 channel … Continue reading

Posted in rman | Leave a comment

RMAN-03002: failure of switch command

Rman restored successfully completed but at the end there is a switch statement which got failed. rman last few lines which shows it is successfully restored. RMAN> channel ORA_DISK_2: reading from backup piece /orarman2/drrmanbackup/part2/rman2jofj96j_1_1 channel ORA_DISK_5: restored backup piece 1 … Continue reading

Posted in rman | Leave a comment

Steps to shut down or reboot an Exadata storage cell without affecting ASM

  To provide steps to power down or reboot an Exadata Storage cell without affecting ASM. SOLUTION Steps to power down or reboot a cell without affecting ASM: When performing maintenance on Exadata Cells, it may be necessary to power … Continue reading

Posted in Exadata | 3 Comments

Steps To Shutdown/Startup The CRS, OHAS, ASM & RDBMS Services on RAC 11.2 Configuration

The present document provides in detail the steps to shutdown/startup The CRS, OHAS, ASM & RDBMS Services on a RAC 11.2. Configuration: 1) Connect to node #1, then please check if the CRS/OHAS & services are enabled to autostart as … Continue reading

Posted in Exadata, Oracle RAC | Leave a comment

Create Oracle RAC Database in Silent Mode on Exadata

Database Version 11gR2 -bash-4.1$ pwd/u01/app/oracle/product/11.2.0.3/dbhome_1 -bash-4.1$ cd bin -bash-4.1$ ./dbca -silent -createDatabase -templateName General_Purpose.dbc -g dbName EBSPROD -sid EBSPROD -sysPassword welcome1 -systemPassword welcome1 -sysm anPassword welcome1 -dbsnmpPassword welcome1 -emConfiguration LOCAL -storageType ASM -diskGroupName DATA_DAH1 -datafileJarLocation $ORACLE_HOME/assistants/dbca/ templates -nodeinfo dbserver1,dbserver2 -characterset … Continue reading

Posted in Exadata, Oracle RAC | Leave a comment