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

mount.nfs

MOUNT.NFS(8)						      System Manager's Manual						      MOUNT.NFS(8)

NAME

       mount.nfs, mount.nfs4 - mount a Network File System

SYNOPSIS

       mount.nfs remotetarget dir [-rvVwfnsh ] [-o options]

DESCRIPTION

       mount.nfs is a part of nfs(5) utilities package, which provides NFS client functionality.

       mount.nfs  is  meant to be used by the mount(8) command for mounting NFS shares. This subcommand, however, can also be used as a standalone
       command with limited functionality.

       mount.nfs4 is used for mounting NFSv4 file system, while mount.nfs is used to mount NFS file systems versions 3 or 2.   remotetarget  is  a
       server share usually in the form of servername:/path/to/share.  dir is the directory on which the file system is to be mounted.

OPTIONS

       -r     Mount file system readonly.

       -v     Be verbose.

       -V     Print version.

       -w     Mount file system read-write.

       -f     Fake mount. Don't actually call the mount system call.

       -n     Do not update /etc/mtab.	By default, an entry is created in /etc/mtab for every mounted file system. Use this option to skip making
	      an entry.

       -s     Tolerate sloppy mount options rather than fail.

       -h     Print help message.

       nfsoptions
	      Refer to nfs(5) or mount(8) manual pages.

NOTE

       For further information please refer nfs(5) and mount(8) manual pages.

FILES

       /etc/fstab	 file system table

       /etc/mtab	 table of mounted file systems

SEE ALSO

       nfs(5), mount(8),

AUTHOR

       Amit Gud <agud@redhat.com>

								    5 Jun 2006							      MOUNT.NFS(8)