Home » RDBMS Server » Backup & Recovery » oracle 10g RMAN
oracle 10g RMAN [message #140832] Wed, 05 October 2005 16:40 Go to next message
skaundin
Messages: 2
Registered: October 2005
Junior Member
Hi,

I have been trying to do a simple backup and restore. I did a backup using backup database; in RMAN utility.

I then deleted a table.

I then did a restore using

restore database;
recover database;
alter database open;

The table which I deleted is not getting restored. I dont know what wrong. Please help. This is urgent.

Thanks,
Suchita
Re: oracle 10g RMAN [message #140841 is a reply to message #140832] Wed, 05 October 2005 19:15 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
That is normal.
You have to say something like
'restore to a point in-time before delete was issued '
else
your restore process will bring back the database as it was before.
So during restore process your dropped table will be created and then dropped again. (since the current information is available in the local archived logs).
Make use of TSPITR (Tablespace point in time recovery).
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmtspit.htm#449254

[Updated on: Wed, 05 October 2005 19:16]

Report message to a moderator

Re: oracle 10g RMAN [message #141070 is a reply to message #140841] Thu, 06 October 2005 16:45 Go to previous messageGo to next message
skaundin
Messages: 2
Registered: October 2005
Junior Member
Hi,

I did this -

run {

shutdown immediate;
startup mount;
backup database;
alter database open;
}

deleted 2 tables

then -

run {
shutdown immediate;
startup mount;
recover database until time "('06/10/2005:2:20:00pm','dd/mm/yyyy:hh:mi:sspm')";
restore database;
alter database open;
}

I still dont see the deleted tables ???

Thanks,
Suchita
Re: oracle 10g RMAN [message #141112 is a reply to message #141070] Fri, 07 October 2005 00:30 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member
skaundin wrote on Fri, 07 October 2005 03:15




run {
shutdown immediate;
startup mount;
recover database until time "('06/10/2005:2:20:00pm','dd/mm/yyyy:hh:mi:sspm')";
restore database;alter database open;
}



AS i know you need to alter the NLS_DATE_FORMAT before doing TSPITR using RMAN, Try it like this


 run
{
sql " Alter session set NLS_DATE_FORNAT=' 'DD-MON-YYYY HH24:MI:SS' ' ";
SET UNTIL TIME '06-10-2005 14:20:00';
RESTORE DATABASE:
RECOVER DATABASE;
}


regards,
tarun
Previous Topic: Error While Export
Next Topic: Consistent Online Backup
Goto Forum:
  


Current Time: Fri Mar 29 02:41:51 CDT 2024