Unable to enter the DB Post: 302595590

Sponsored Content

Homework and Emergencies Emergency UNIX and Linux Support Unable to enter the DB Post 302595590 by vivek.goel.piet on Friday 3rd of February 2012 04:00:33 PM

02-03-2012

Registered User

I have also tried to do this

Code:

SQL> recover database until cancel USING BACKUP CONTROLFILE;
ORA-00279: change 91832826 generated at 01/31/2012 20:55:27 needed for thread 1
ORA-00289: suggestion :
/var/opt/mediation/ora/oralog/bgw/archive_log_1_4152_716325247.dbf
ORA-00280: change 91832826 for thread 1 is in sequence #4152


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
CANCEL
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1:
'/var/opt/mediation/ora/oradata/BGW/datafile/o1_mf_system_5wcl4ors_.dbf'


ORA-01112: media recovery not started


SQL>

---------- Post updated at 02:30 AM ---------- Previous update was at 12:06 AM ----------

Some more logs for investigation purpose.

Code:

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1:
'/var/opt/mediation/ora/oradata/BGW/datafile/o1_mf_system_5wcl4ors_.dbf'


SQL>

vivek.goel.piet

View Public Profile for vivek.goel.piet

Find all posts by vivek.goel.piet

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

HELP with Enter Character

I'm using PHP in my site. I have txt files for news. I reads the txt files and post the news. i have a php function that finds the caracter asc(13) which is the enter, and puts a <br>. It works in Windows, but not on Unix. Can u help me with that. Thanks

2. Solaris

Cant enter password

When i come to the login screen i will put root and no password, and it will say its incorrect, but even when i try to enter a password nothing comes up in the box

3. Solaris

Enter to OBP

Hello, today i'm comment in /etc/vfstab fs /usr and my server load in SingleUser without anything commands :( How i can enter to OBP from # ? or ILOM ? I'm try CTRL+BREAK (F5) , CTRL+ALT+BREAK (F5) and #. but it's don't help me :((((

4. Shell Programming and Scripting

how to have ENTER after each symbol.

I want to know script for Input file : 123456789 outputfile : 1 2 3 4 5 6 7 8 9 now please how can generalize it like i want output : 123 456 789

5. Shell Programming and Scripting

Trigger Enter

Hello, I need to trigger every time enter has been clicked while some one on terminal i tried to googleit but with out result any idea ?? thanks in advance

6. Shell Programming and Scripting

remove enter

Hi All, I have a file , delimited by | Last column of the file has a extra enter causing error in my program Eg: firstworld <enter>; NO EMP i want data to be firstworld; NO EMP Is there a way to remove enter from a file

7. UNIX for Dummies Questions & Answers

Tab and Enter

Do Tab or Enter behave like a command in some cases? For example, I had been trying to plot with gnuplot by usinf shell script like command inside: cat plot.gnu gives : plot 'datafile1' , \ 'datafile2' Now gnuplot doesn't recognize the newline command "\" unless I use "enter" in the...

8. Shell Programming and Scripting

Pressing enter and script still goes on

i have a bash shell script and i press enter and the script still continues on? how do i stop this

9. Shell Programming and Scripting

Loop logic, enter into respective IF as per enter input file name

have three big data file, however I just need to see the mentioned below one line form the all the file which has SERVER_CONNECTION Value File 1 export SERVER_CONNECTION=//dvlna002:10001/SmartServer File2 export SERVER_CONNECTION=///SmartServer File3 export...

LEARN ABOUT CENTOS

nfsiostat

nfsiostat(8)						      System Manager's Manual						      nfsiostat(8)

NAME

       nfsiostat - Emulate iostat for NFS mount points using /proc/self/mountstats

SYNOPSIS

       nfsiostat [[<interval>] [<count>]] [<options>][<mount_point>]

DESCRIPTION

       The nfsiostat command displays NFS client per-mount statisitics.

       <interval>
	      specifies the amount of time in seconds between each report.  The first report contains statistics for the time since each file sys-
	      tem was mounted.	Each subsequent report contains statistics collected during the interval since the previous report.

       <count>
	      If the <count> parameter is specified, the value of <count> determines the number of reports generated at <interval> seconds  apart.
	      if the interval parameter is specified without the <count> parameter, the command generates reports continuously.

       <options>
	      Define below

       <mount_point>
	      If  one  or  more  <mount  point> names are specified, statistics for only these mount points will be displayed.	Otherwise, all NFS
	      mount points on the client are listed.

OPTIONS

       -a  or  --attr
	      displays statistics related to the attribute cache

       -d  or  --dir
	      displays statistics related to directory operations

       -h  or  --help
	      shows help message and exit

       -l LIST or  --list=LIST
	      only print stats for first LIST mount points

       -p  or  --page
	      displays statistics related to the page cache

       -s  or  --sort
	      Sort NFS mount points by ops/second

       --version
	      show program's version number and exit

FILES

       /proc/self/mountstats

SEE ALSO

       iostat(8), mountstats(8), nfsstat(8)

AUTHOR

       Chuck Lever <chuck.lever@oracle.com>

								    15 Apr 2010 						      nfsiostat(8)