| Restore question [message #197978] |
Fri, 13 October 2006 10:11  |
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  |
 |
Mahesh Rajendran
Messages: 10708
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. 
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 #202191 is a reply to message #197978] |
Wed, 08 November 2006 11:57 |
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.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
