Home » RDBMS Server » Backup & Recovery » Restore question
Restore question [message #197978] Fri, 13 October 2006 10:11 Go to next message
roopla
Messages: 52
Registered: May 2006
Member
I am a newbie to RMAN stuff. I just want to find out what exactly Recovery command does when one is trying to recover the database.

The following step I've done to backup the database

startup mount
rman target /
backup database

I assume when you do "backup database", it will backup all files
like datafile,control files and redo log files in some location


Then, I opened the database by issuing following commands

alter database open;
dropped the table;
shutdown immediate;


Now, I am trying to restore and recover the my dropped table from
the backup I did in the first step. For this I did the following steps

startup mount
rman target /
restore database
recover database
alter database open

But, still I can't see the my dropped table evernthough I recovered it. I am not sure what exactly recover command does, whether it applies redo logs from the backup I have taken or the
it applies current redo logs. Obviously, it's applying current redo logs to the restored database, that's why I am still not able to see my dropped table. Somebody pointed out I've to take Point in Time recovery. But again, this is very simple thing I am trying to do. Can somebody throw some light into this without doing Point in time recovery
Re: Restore question [message #197979 is a reply to message #197978] Fri, 13 October 2006 10:28 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> Can somebody throw some light into this without doing Point in time recovery
Not sure what you are expecting here to do.
Simply put, NO. You cannot. You need to do a POINT-IN-TIME recovery .
It is not that hard.
Just search for examples in this board.
Coincidentally, I am right now (while typing this) doing a restoration using TSPITR on 10gR2. Smile

Restore database will restore will restore to point the database is backed up and also uses the information in archived logs ( if available in local disk ) to go past the backupsets.
So you must actually doing a TSPITR or tablespace point-in-time recovery.

timepoint 1: take backup
timepoint 2: nothing.
timepoint 3: do changes ( drop table T1).
timepoint 4: restore & recover database
check Database: you cannot see the table T1 . Becuase by default "restore database" will restore database from backupsets and also apply all the archived logs available. So your table was first created and dropped again.

This is what you need to do.
timepoint 4: resore and recover to timepoint 2 ( after backup,before changes. This is TSPITR).
Spend some time in docs. It is all documented.


[Updated on: Fri, 13 October 2006 15:49]

Report message to a moderator

Re: Restore question [message #197980 is a reply to message #197979] Fri, 13 October 2006 10:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Also, please look here for a simple demo
http://www.orafaq.com/forum/m/169457/42800/#msg_169457
Re: Restore question [message #202191 is a reply to message #197978] Wed, 08 November 2006 11:57 Go to previous messageGo to next message
afa654321
Messages: 2
Registered: November 2006
Junior Member
Hello,

This is not a reply but rather a general question.
We have Oracle 10g & a Dell 132T tape backup library, do we need to purchase additional software(e.g., Symantec Backup Exec) to actually be able to back up our DB?

From my reading it seems we can't just use the RMAN console & backup our DB to an external tape device?

BTW, we're running Windows Server 2003 Enterprise 64-bit version.

Thx.
Re: Restore question [message #202192 is a reply to message #202191] Wed, 08 November 2006 11:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
In 10g you can directly write to a tape device. No need for a Media management layer.

Edit:
Correction. Still MML is required. Seems Oracle has its own MML suport now.

[Updated on: Wed, 08 November 2006 12:18]

Report message to a moderator

Re: Restore question [message #202193 is a reply to message #202192] Wed, 08 November 2006 12:03 Go to previous messageGo to next message
afa654321
Messages: 2
Registered: November 2006
Junior Member
Thanks Mahesh.

Can you pls refer me to some doc(RMAN, etc.) with details.
Re: Restore question [message #202195 is a reply to message #202193] Wed, 08 November 2006 12:16 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I have'nt tried it myself.
Seems it is now possible with use of Oracle Secure Backup.
http://www.oracle.com/technology/deploy/availability/pdf/S941_Cooksey.doc.pdf

RMAN ability to write directly to tape has been a long time requested feature.
Previous Topic: Backup using RMAN failed
Next Topic: RMAN Duplicate Database
Goto Forum:
  


Current Time: Fri Dec 09 13:17:46 CST 2016

Total time taken to generate the page: 0.05410 seconds