Oracle Apps DBA

To Start CRS Go to CRS_HOME/bin ./crsctl start crs To Stop CRS Go to CRS_HOME/bin ./crsctl stop crs Status of CRS services Go to CRS_HOME/bin bash-3.00$ ./crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora.cmwdb1.gsd application ONLINE ONLINE cmwdb1 ora.cmwdb1.ons application ONLINE ONLINE cmwdb1 ora.cmwdb1.vip application ONLINE ONLINE cmwdb1 ora.cmwdb2.gsd application ONLINE ONLINE cmwdb2 ora.cmwdb2.ons application ONLINE ONLINE cmwdb2 ora.cmwdb2.vip application ONLINE ONLINE cmwdb2 Check current OCR file bash-3.00$ ocrcheck Status of Oracle Cluster Registry is as follows : Version : 2 Total space (kbytes) : 102188 Used space (kbytes) : 2140 Available space (kbytes) : 100048 ID : 617463612 Device/File Name : /dev/vx/rds

Scenario: While doing RMAN Duplicating database we missed some archivelog backup from backup mountpoint, so it gives error like executing Memory Script executing command: SET until clause Starting recover at 18-SEP-10 starting media recovery channel C1: starting archive log restore to default destination channel C2: starting archive log restore to default destination channel C3: starting archive log restore to default destination channel C1: restoring archive log archive log thread=2 sequence=80918 channel C2: restoring archive log archive log thread=2 sequence=80917 channel C2: reading from backup piece /rmanback/arch_52886.arc channel C3: restoring archive log archive log thread=1 sequence=71380 channel C1: restoring archive log archive log thread=2 sequence=80919 ORA-19870: error reading backup piece /rmanback/arch_52886.arc ORA-19505: failed to identify file "/rmanback/arch_52886.arc" ORA-27041: unable to open file SVR4 Error: 13: Permission denied Additional information: