OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Recovery .... (Oracle 10g, Windows 2003 Sp2..)

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

Recovery .... [message #486708]

Sun, 19 December 2010 05:52

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

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

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

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

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

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

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

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

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

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

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 13:57:32 CDT 2024