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

Android video recovery software

The entire construtors asserted come across android video recovery software french 5,000 words is made for both relatively easy in addition to excellent individuals, And also for next to anybody what person requires an google android os touch screen phone. Owners and similarly added if the 65 progressive speech treatments will be contributed to the application customer base soon enough but also 1000 keyword sentences will be added monthly to the. Major flaws that novice trisports people…

Continue

Posted by Donalds Snoi on January 15, 2017 at 6:14pm

Data Enrichment can Help You Derive Value from Your Data

The standardization, correction, and validation of existing data to maximize its efficiency is called data enrichment. As business expands and grows, it needs more accurate and refined data. Data, one of the most valuable assets of an organization,…

Continue

Posted by Alvaro Dee on January 11, 2017 at 9:21pm

How to Set Yourself Up For Success on eBay

One of the most popular marketplaces, eBay is setting new examples for competitors in terms of customer satisfaction. Its excellent services and quality of products has made it that popular. eBay…

Continue

Posted by Alvaro Dee on January 8, 2017 at 9:33pm

Know How to Save More Time to Focus and Grow Your Primary Business

Data is the most valuable asset of an organization. To get the most out of data, one needs to properly manage and maintain it. Accurate and easily-accessible business data can help in making informed decisions, enable better understanding, and improve…

Continue

Posted by Alvaro Dee on December 22, 2016 at 8:42pm

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service