Rohit Khurana
  • Male
  • delhi
  • India
Share on Facebook
Share

Rohit Khurana's Friends

  • sumit sood
  • Rajesh
  • Theyakarajan S
  • Pratima
  • Divyang Shah
  • ABDULLLAHI  AYDRUS DAAR
  • ANURAG KUMAR PANDEY
  • Mohammad Shadab
  • Rajasekar
  • Muhammad Atif Akram
  • Ritu Sharma
  • Saurabh K. Gupta
  • Mahir M. Quluzade
  • Muhammad Abdul Halim
  • oraclebase

Gifts Received

Gift

Rohit Khurana has not received any gifts yet

Give a Gift

 

Rohit Khurana's Page

Latest Activity

Peter Ephanga commented on Rohit Khurana's blog post RMAN UNTIL SCN EXAMPLE
"Why would you shutdown your database to restore one tablespace that does not belong to sys or sysaux? "
Jan 12, 2015
Md. Khorshed Alam commented on Rohit Khurana's blog post HOW TO EXPORT A TABLE IN ORACLE 10G
"Nice explanation. Please if possible share about "Migration database along with constraints and all other objects from SQL server 2008 R2 to Oracle 11g R2 Database". "
Jul 22, 2014
Rohit Khurana and sumit sood are now friends
Mar 2, 2014
Madhava Verma Dantuluri commented on Rohit Khurana's blog post HOW TO EXPORT A TABLE IN ORACLE 10G
"Wonderfully explained putting all steps in order."
Feb 21, 2014
Rohit Khurana is now friends with Theyakarajan S and Rajesh
Jan 17, 2013
Rohit Khurana is now friends with Pratima and Divyang Shah
Jul 24, 2012
Bhopinder Singh commented on Rohit Khurana's blog post HOW TO EXPORT A TABLE IN ORACLE 10G
"nice article man"
May 1, 2012
Rohit Khurana is now friends with ABDULLLAHI AYDRUS DAAR and Ritu Sharma
Apr 3, 2012
Saurabh K. Gupta and Rohit Khurana are now friends
Mar 17, 2012
Rohit Khurana updated their profile
Mar 17, 2012
Rohit Khurana posted a blog post

Recover a Lost Datafile with No Backup

CONNECT WITH RMAN C:\>RMAN TARGET / Recovery Manager: Release 10.2.0.1.0 - Production on Wed Feb 29 13:36:14 2012 Copyright (c) 1982, 2005, Oracle.  All rights reserved. connected to target database: ORCL (DBID=1304302012) CHECK IT OUT DO YOU HAVE ANY BACKUP ?? RMAN> LIST BACKUP SUMMARY; using target database control file instead of recovery catalog IN THIS SCENARIO WE REQUIRED OLD BACKUP SO TAKE A FULL BACKUP RMAN> BACKUP DATABASE PLUS ARCHIVELOG TAG='FULL_BACKUP';…See More
Mar 17, 2012
Rohit Khurana is now friends with ANURAG KUMAR PANDEY and Rajasekar
Mar 15, 2012
Rohit Khurana commented on Rohit Khurana's blog post ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
"Sure"
Feb 29, 2012
Sreenivasa Suman P commented on Rohit Khurana's blog post ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
"Can you pl share some of the errors you got. I am looking for a change and this might useful..."
Feb 29, 2012
Sreenivasa Suman P commented on Rohit Khurana's blog post ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
"Hi Rohit, Might be SMON is automatically recovering the DB once you bounced. Thanks for updates."
Feb 29, 2012
Rohit Khurana commented on Rohit Khurana's blog post ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
"Thank's For your Valuable Feedback Sreenivasa Suman P"
Feb 29, 2012

Profile Information

About Me:
Oracle Certified Associate
My Blog:
http://www.oraclecommunity.net/profile/rohitkhurana
My Website:
http://www.facebook.com/rohitkhurana.k

Rohit Khurana's Blog

Recover a Lost Datafile with No Backup

CONNECT WITH RMAN



C:\>RMAN TARGET /



Recovery Manager: Release 10.2.0.1.0 - Production on Wed Feb 29 13:36:14 2012



Copyright (c) 1982, 2005, Oracle.  All rights reserved.



connected to target database: ORCL (DBID=1304302012)



CHECK IT OUT DO YOU HAVE ANY BACKUP ??



RMAN> LIST BACKUP…

Continue

Posted on March 17, 2012 at 4:30am

Spool File In Oracle For Rman

Thanx For Reading My Blog Give Comment's & Suggesstions At The End of The Blog :-)…

Continue

Posted on February 29, 2012 at 3:00am

ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

ACTION = Clean Shutdown Required  SHUTDOWN NORMAL , SHUT IMMEDIATE

SQL> select name , log_mode , flashback_on , dbid from v$Database;



NAME      LOG_MODE          FLASHBACK_ON             DBID

--------- ------------ ------------------       ----------

ORCL     …

Continue

Posted on February 28, 2012 at 11:30pm — 5 Comments

ORA-16006: audit_trail destination incompatible with database open mode

Action: When the Database is opened for read-only access, the audit_trail initialization parameter can only be set to "OS" or "NONE" (FALSE).

SQL> STARTUP MOUNT;

ORACLE instance started.

 

Database mounted.

SQL> ALTER DATABASE OPEN READ ONLY;

ALTER DATABASE OPEN READ…

Continue

Posted on February 27, 2012 at 1:30am

Comment Wall

You need to be a member of Oracle Community to add comments!

Join Oracle Community

  • No comments yet!
 
 
 

Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins

Badge

Loading…

Blog Posts

Why you Should Include Push Notifications in your Mobile App?

Push notifications are a display of your application’s icon and a message in the status bar of your device. We stress the importance of including push notifications in your mobile application for three major reasons:-

  1. Push Notifications allow direct marketing to your clients: When a customer downloads your application and enables push notification, it gives you direct…

Continue

Posted by Alvaro Dee on August 23, 2016 at 10:50pm

Amazon Virtual Assistant Services for Efficient e-store Management

Virtual assistant (VA) is a term that has been buzzing around in the business world for quite some time now. Essentially, a VA is skilled administrator who takes care of your technical/creative business support activities while working offsite. If you already have a designated eCommerce store on Amazon seller central or wish to start one, an Amazon VA will help you manage the store and update it regularly with utmost precision.

Amazon VA creates and updates the…

Continue

Posted by Alvaro Dee on August 23, 2016 at 2:56am

What to Expect When Investing in Data Cleansing Services?

Why invest in data cleansing services?

Imagine a scenario- You are maintaining huge databases containing information about your potential customers and you are all geared up with next direct mailing campaigns. After promotional mailers have been sent, you realize the fact that the major part of your database actually contained supplier information.

Such blunders can happen anytime and can…

Continue

Posted by Alvaro Dee on July 25, 2016 at 11:30pm

Avail Affordable and Specialized Android Games Development Services

Cellular gaming has become hugely popular in the last few years. With cellular gaming and amazing features of the Android operating system mixed together, the demand for Android games development services has increased drastically. Gaming becomes fun on Android based Smartphones with its great features getting the users hooked from the word go!

Android supports clarity…

Continue

Posted by Alvaro Dee on July 24, 2016 at 10:47pm

© 2016   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service