OraFAQ Forum: Backup & Recovery » DB Recover until cancel

Home » RDBMS Server » Backup & Recovery » DB Recover until cancel (oracle 10g, linux)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

DB Recover until cancel [message #493839]

Thu, 10 February 2011 03:24

pokhraj_d
Messages: 116
Registered: December 2007

Senior Member

Hi,
Currently my DB is running on 10g Archivelog mode. All the archive logs being generated at /u04/dbarch/.
The server crashed yesterday. Now when I want to start my instance it throwing the error ORA-01110 and ORA-01113-- system01.dbf need more recovery.

The below are the command I fired from sql prompt:-
SQL>STARTUP MOUNT;
SQL>RECOVER DATABASE UNTIL CANCEL;
But still oracle suggesting that system01.dbf need more recovery.

Please suggest how can I recover my database.

Thanks-
P

Report message to a moderator

Re: DB Recover until cancel [message #493844 is a reply to message #493839]

Thu, 10 February 2011 03:32

Michel Cadot
Messages: 54223
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Why do you use "until cancel"?

Regards
Michel

Report message to a moderator

Re: DB Recover until cancel [message #493852 is a reply to message #493844]

Thu, 10 February 2011 03:52

pokhraj_d
Messages: 116
Registered: December 2007

Senior Member

I have actually fired the below command:
SQL> RECOVER DATABASE;

Then Oracle asking for recovery needed for system01.dbf

After that I use "until cancel" option.

Please suggest

Thanks-
P

Report message to a moderator

Re: DB Recover until cancel [message #493854 is a reply to message #493839]

Thu, 10 February 2011 03:56

knight
Messages: 111
Registered: January 2009

Senior Member

please post your rman session where you are doing recovery

Report message to a moderator

Re: DB Recover until cancel [message #493858 is a reply to message #493854]

Thu, 10 February 2011 04:06

pokhraj_d
Messages: 116
Registered: December 2007

Senior Member

Hi,

I am not doing any recovery. The situation is as below:-

1. My server crashed suddenly.
2. I dont have the valid backup.
3. I tried to start my database when the server is up and running
SQL>STARTUP;
4. The DB mounted and then giving error:-
ORA-01110 and ORA-01113: system01.dbf need more recovery.

5. I fired : SQL>RECOVER DATABASE;
6.Getting error ORA-01110 and ORA-01113: system01.dbf need more recovery.

7. Then fired : SQL>RECOVER DATABASE ULTIL CANCEL;

8. Getting error ORA-01110 and ORA-01113: system01.dbf need more recovery.

Please suggest.

Regards-
P

Report message to a moderator

Re: DB Recover until cancel [message #493916 is a reply to message #493839]

Thu, 10 February 2011 07:20

knight
Messages: 111
Registered: January 2009

Senior Member

Quote:

I am not doing any recovery

then why do you

Quote:

5. I fired : SQL>RECOVER DATABASE;

copy and paste your session

Report message to a moderator

Previous Topic:	Backup until....in RMAN
Next Topic:	RMAN Recovery failing with Incremental level 0 Backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 23 20:17:53 CDT 2013

Total time taken to generate the page: 0.13850 seconds