Home » RDBMS Server » Backup & Recovery » DB Recover until cancel (oracle 10g, linux)
DB Recover until cancel [message #493839] Thu, 10 February 2011 03:24 Go to next message
pokhraj_d
Messages: 117
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
Re: DB Recover until cancel [message #493844 is a reply to message #493839] Thu, 10 February 2011 03:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why do you use "until cancel"?

Regards
Michel
Re: DB Recover until cancel [message #493852 is a reply to message #493844] Thu, 10 February 2011 03:52 Go to previous messageGo to next message
pokhraj_d
Messages: 117
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
Re: DB Recover until cancel [message #493854 is a reply to message #493839] Thu, 10 February 2011 03:56 Go to previous messageGo to next message
knight
Messages: 111
Registered: January 2009
Senior Member
please post your rman session where you are doing recovery
Re: DB Recover until cancel [message #493858 is a reply to message #493854] Thu, 10 February 2011 04:06 Go to previous messageGo to next message
pokhraj_d
Messages: 117
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





Re: DB Recover until cancel [message #493916 is a reply to message #493839] Thu, 10 February 2011 07:20 Go to previous message
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
Previous Topic: Backup until....in RMAN
Next Topic: RMAN Recovery failing with Incremental level 0 Backup
Goto Forum:
  


Current Time: Fri Mar 29 04:40:01 CDT 2024