The social network for Oracle people
-
Rohit Khurana
- Male
- delhi
- India
- Blog Posts (19)
- Discussions
- Events (1)
- Groups (8)
- Featured Photos (5)
- Photo Albums
- Featured Videos
Rohit Khurana's Groups
-
The Indian Oracle
66 members
-
Performance Tuning
240 members
-
Oracle Certified Master
50 members
-
SQL Developer
79 members
-
Donald K. Burleson Group
26 members
Gifts Received
Rohit Khurana has not received any gifts yet
Rohit Khurana's Page
Latest Activity
Bhopinder Singh commented on Rohit Khurana's blog post HOW TO EXPORT A TABLE IN ORACLE 10G"nice article man"
Rohit Khurana posted a blog postRecover 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
Rohit Khurana commented on Rohit Khurana's blog post ORA-00265: instance recovery required, cannot set ARCHIVELOG mode"Sure"
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..."
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."
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"
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"
Rohit Khurana joined venkatesh's group
The Indian Oracle
Hello Friends, Share your experiences and update your information here. This group is for general Oracle professions..
Rohit Khurana posted a blog postORA-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 ONLY * ERROR at line 1: ORA-16006: audit_trail destination incompatible with database open mode SQL> SHOW PARAMETER AUDIT_TRAIL audit_trail string DBSQL> ALTER SYSTEM SET audit_trail=none…See More
Profile Information
- About Me:
- Oracle Certified Associate
- My Website:
- http://www.facebook.com/rohitkhurana.k
Rohit Khurana's Photos
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…
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 :-)…
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 …
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…
Posted on February 27, 2012 at 1:30am
Comment Wall
- No comments yet!
© 2013 Created by Eddie Awad.
