Home » RDBMS Server » Backup & Recovery » Recovery .... (Oracle 10g, Windows 2003 Sp2..)
Recovery .... [message #486708] Sun, 19 December 2010 05:52 Go to next message
rizwans
Messages: 5
Registered: September 2010
Location: Saudi arabia
Junior Member
Dear All,
i want to restore and recover my database. I Have taken the last night logical backup (i.e) export and imported into database, but i want to recover the database , so that i should get the data of todays , till the time of crash.
Waiting for immediate response / Help.
Need the steps also to do the restore.

Thanks and best Regards
Rizwan

Report message to a moderator

Re: Recovery .... [message #486709 is a reply to message #486708] Sun, 19 December 2010 06:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You cannot.

Export is NOT a database backup.
You cannot recover with an export.
The only thing you can do is to create a new database and import into it at the time of the export.

If you want a real backup, learn and use RMAN.

Regards
Michel

Report message to a moderator

Re: Recovery .... [message #486740 is a reply to message #486708] Sun, 19 December 2010 22:21 Go to previous messageGo to next message
Markwillium
Messages: 13
Registered: December 2010
Location: India
Junior Member
You can not recover your database by export the database but you have another option. You can try third party recovery tool which is definitely help you to recover your database.

[Updated on: Sun, 19 December 2010 22:27]

Report message to a moderator

Re: Recovery .... [message #486741 is a reply to message #486740] Sun, 19 December 2010 22:42 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>i want to recover the database , so that i should get the data of todays , till the time of crash.
Is the DB running with Archiver enabled?

Report message to a moderator

Re: Recovery .... [message #486744 is a reply to message #486741] Sun, 19 December 2010 23:35 Go to previous messageGo to next message
rizwans
Messages: 5
Registered: September 2010
Location: Saudi arabia
Junior Member
YES ...Archive log is on.
its archiving.

Thanks

Report message to a moderator

Re: Recovery .... [message #486745 is a reply to message #486744] Sun, 19 December 2010 23:39 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I Have taken the last night logical backup (i.e) export and imported into database,
The "imported" DB is a different DB than source DB, so archived REDO logs from source DB can NOT applied to target DB.

Report message to a moderator

Re: Recovery .... [message #486746 is a reply to message #486744] Sun, 19 December 2010 23:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
It does not matter you cannot do anything with an only export.
Archive logs would be useful if you had a real backup.

Regards
Michel

Report message to a moderator

Re: Recovery .... [message #487655 is a reply to message #486708] Wed, 29 December 2010 06:17 Go to previous messageGo to next message
dataentryoutsourcing
Messages: 3
Registered: December 2010
Location: GUJARAT
Junior Member
You can perform cancel-based media recovery. the steps are:-
1)Start SQL*plus and connect to oracle with administrator privileges.
2)Start a new instance and mount the database:
STARTUP MOUNT
3)Begin cancel-based recovery by issuing the following command:
RECOVER DATABASE UNTIL CANCEL
If you are using a backup control file with this incomplete recovery,then specify the using BACKUP CONTROL FILE option in the RECOVER command.
4)Oracle applies the necessary redo log files to reconstruct the restored datafiles.
5)Continue applying redo log files until the last log has been applied to the restored datafiles and execute the command files
CANCEL
6)Open the database in RESTLOGS mode.

Report message to a moderator

Re: Recovery .... [message #487658 is a reply to message #487655] Wed, 29 December 2010 07:55 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
2) How is this possible if you no more have a database and nothing to restore?

Regards
Michel

Report message to a moderator

Previous Topic: Confusion of Archive log generation and RMAN backup
Next Topic: ORA-0036: file 57 can not be read - Controlfile Recreate Not of Help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 21 20:36:11 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.