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

Convert Prospects into Repeat Customers with Amazon Data Entry Services

eCommerce store owners get a better exposure for their products by selling on a platform like Amazon. If you are thinking about selling on Amazon or you are already a seller who needs help in managing product listings on this popular online marketplace, stop worrying. Professionals with sound technical knowledge of Amazon product listings, categorization, content, etc. are there to make things easier for you.

You can outsource …

Continue

Posted by Alvaro Dee on April 12, 2017 at 10:05pm

Increase Sales with Unique and Compelling Product Descriptions

Are you thinking about opening an online store? Or, do you already have one? Whether you have a small online business or a big store, the manner in which you list your products leads to a dramatic impact on your sales.



Don’t just sell a product, you need to sell an experience.
You yourself get excited about the features and specifications of your products. But the problem is that your…

Continue

Posted by Alvaro Dee on April 10, 2017 at 11:18pm

Business Research Helps You Understand Critical Traits of Your Business

Business organization needs strong customer and actionable industry insights to develop better understanding of its market and other important aspects. It can meet business objectives and make tactical, strategic and operational decisions with the help of business research services. The growth of a company largely depends on effective business research. You can conduct a successful market research with…

Continue

Posted by Alvaro Dee on April 3, 2017 at 3:23am

Streamline Your Business Process with Real Estate Data Entry Services

People in the real estate business have to deal with huge volumes of data on a regular basis. It includes the data that is generated from legal documents, property valuation statements, latest commercial and non-commercial property information, etc. This database should be regularly updated and processed properly to help you in your business procedures. With access to relevant real-time data, your business organization can thrive in the commercial real estate market. In…

Continue

Posted by Alvaro Dee on March 27, 2017 at 2:48am

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service