If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hybrid View

Rman Recovery

Hi All
I am testing Rman recovery process. I have created a tablespace, and a table that I nhave populated with 150 records.

I took incr_0 backup (Full database backup)

Dropped the table and invoked Rman to do the restore and the recovery.

Recovery completed successfully with no error. When I went to look for the table I have dropped it was not there. why will rman recovery be successful and the table recovered not there? I expect to see the table I have been recovered there. Any idea or sugestion?

Thanks for your response. So refering to your comment how can I correct that? Can you show me the command?
I have tried to recover the tablespace to a point in time and getting the "Auxilliary database error" Where is the auxilliary database? I think this should be the Target.

Rman Recovery

Thomas
Thanks for your quick response. Eventhough I took off the "clone" clause and simply allocated one chanel, I am still getting this "Not connected to the Auxilliary database" error.
Where and how to connect the auxilliary database?

Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

You can't recover just tablespace in Point-In_time_recovery. You need to restore complete database and recover. No PARMS for SBT_TAPE? Where is your backups - in tape or disk? I just given a simple script.

Rman Recovery

Thomas
You said that:
You can't recover just tablespace in Point-In_time_recovery. You need to restore complete database and recovery.

The documentation says that you can perform tablespace point in time rfecovery using RMAN.
You can also perform recovery at the following level.
Database
Tablespace
Datafile
and I wass trying to do the Tablespace point in time recovery.
(TSPITR)

Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.