oracle 10g RMAN [message #140832] |
Wed, 05 October 2005 16:40 |
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 #141070 is a reply to message #140841] |
Thu, 06 October 2005 16:45 |
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 |
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
|
|
|