Home » RDBMS Server » Backup & Recovery » Doubt on database recover (oracle 10g,unix)
Doubt on database recover [message #403535] Sat, 16 May 2009 10:07 Go to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member


Hi all,

I have a doubt regarding recovering database.


I have a rman backup in disk and archive logs in separate disk.
when a datafile is missing or some problem with database, at that time from where the data is used to recover the ? either from backup disk or from archive logs disk?

PLease clear my doubt.


Mohan

Report message to a moderator

Re: Doubt on database recover [message #403536 is a reply to message #403535] Sat, 16 May 2009 10:27 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
It could depend on what you are recovering from.

Check Backup and Recovery Basics for more information regarding restore & recovery.

Report message to a moderator

Re: Doubt on database recover [message #404315 is a reply to message #403535] Thu, 21 May 2009 05:30 Go to previous messageGo to next message
anwar786
Messages: 25
Registered: May 2009
Location: bangalore
Junior Member
if u have datafile missing then copy back the specific datafile from the backup location to the original location
then if u startup put
RECOVER DATABASE command,
then it will ask for archive logs to apply something like this
ORA-00279: change 655683 generated at 05/21/2009 11:26:58 needed for thread 1
ORA-00289: suggestion :
D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ARC00010_0686254531.001
ORA-00280: change 655683 for thread 1 is in sequence #10

here ARC00010_0686254531.001 is the archive file it is asking paste the path including filename after this and press ENTER
now sme times it will b enough otherwise it will ask for next archive file after everything is finished
it will say
Log applied.
Media recovery complete.
now issue
SQL> alter database open;
Database altered.

the database is open u can shutdown and startup again to check if it is working.Always do this to verify

Report message to a moderator

Re: Doubt on database recover [message #404321 is a reply to message #404315] Thu, 21 May 2009 06:06 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
This is too generic of a response. How will this help the OP with "some problem with database" ?

In addition, the OP is talking about restore & recovery with RMAN.

Report message to a moderator

Previous Topic: creating backup script of 10g database in rhel4
Next Topic: Online redo log in flashback area: best practise?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 16 15:02:53 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.