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

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

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". "
Wednesday
Rohit Khurana and sumit sood are now friends
Mar 2
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
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
Sreenivasa Suman P commented on Rohit Khurana's blog post ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
"Hi Rohit, You have to issue command SQL> RECOVER DATABASE; in mount phase when you bounced the DB. That command is missing in above scenario. Regards 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

Verify and Fix Corruption in Oracle Databases, Efficiently

Oracle database system stores massive amounts of data, aiming for secure data storage and management. With a number of predefined queries, this database system lets you insert and retrieve data that is stored in multiple tables inside it. For smoother functioning of a database system and its respective databases, your machine must be free of every single issue that is supposed to cause adverse effects on the data. For…

Continue

Posted by Mark Willium on June 3, 2014 at 11:00pm

esProc Enables Oracle JDBC to Speed Up Retrieve Process

Recently, a performance issue occurs in a big detail report, where the original data volume in the two data tables as it involves has exceeded 3 million rows; the data volume that the report can retrieve after filtering remains at round 2 million rows. As we expected before, by using paged retrieve method, this report would present a much higher performance. However, for the fact that the user also needs to…

Continue

Posted by Jim King on May 29, 2014 at 7:00am

Oracle DBaaS in Private Database Cloud workshop

Designing Database as a Service (DBaaS) in own Database Cloud is very comprehensive topic and it requires a lot of things: clear concept and strategy, solid planning, important architecture decisions, considerable involvement of different stakeholders, extra budget, etc. To start talking about this topic I’ll give my own definition of DBaaS which is a managed database service, hosted and offered by DBaaS provider on pay-per-usage basis, which provides access to own database resource with…

Continue

Posted by Kirill Loifman on May 5, 2014 at 12:37am

© 2014   Created by Steve Karam.

Badges  |  Report an Issue  |  Terms of Service