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
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

What Benefits Does an MCSE Certification Carry?

MCSE certifications are the most popular certifications around the world. And, their popularity isn't without reason. In the following post I have highlighted the benefits that you can derive from an MCSE certification, so as to help you gauge how useful it can be for your career. Read on to know.…

Continue

Posted by Michael Warne on May 28, 2015 at 1:32am

Default Login Form customize

Dear All, I want to customize oracle 10g default login page. How can I do this. I attached the login page for better understanding.

Posted by Shakaouth Shanto on May 19, 2015 at 10:00pm

Live SAP Hybris Online Training Classes at VirtualNuggets

Web URL      :  http://www.virtualnuggets.com/sap-hybris.html

Email              :  info@virtualnuggets(dot)com

Contact           :  +1-7076668949(USA)         +91-8885560202(India) 

 

Live SAP Hybris Online Training Classes at VirtualNuggets

 

SAP Hybris is a standout amongst the most widely recognized e-commerce platforms       on the Internet…

Continue

Posted by Virtualnuggets on May 12, 2015 at 11:14pm

TIBCO BE Online Training

TIBCO BE Online Training

                                          

            We are Glad To Announce That TIBCO BE Online Training Offered by Industry real time Experts at VirtualNuggets Institute. we are offering TIBCO BE Online Training with a customized course design, The Learners who participate in our online training sessions will able to easily grab the required skills of TIBCO BE Which needed to solve integration challenges in real…

Continue

Posted by Virtualnuggets on May 6, 2015 at 11:27pm

© 2015   Created by Steve Karam.

Badges  |  Report an Issue  |  Terms of Service