Home » RDBMS Server » Backup & Recovery » Perform incomplete user managed backup and recovery
Perform incomplete user managed backup and recovery [message #537646] Fri, 30 December 2011 00:31 Go to next message
ashishs
Messages: 40
Registered: May 2011
Member

Hey,
create table t1(code number)tablespace test;
insert into t1(123);
commit;
alter system switch logfile;
alter database begin backup;
cp'/home/oracle/../test.dbf '/home/oracle/../backup/test.dbf
cp'/home/oracle/../system.dbf' '/home/oracle/../backup/system.dbf
.
.
.
cp '/home/oracle/../dtf1' '/home/oracle/../backup/dtf1.dbf
alter database end backup;
select *from current_timestamp from dual;(30-dec-2011:11:00:00)
insert into t1(456);
commit;
alter system switch logfile;
shutdown immediate;
rm'/home/oracle/../test.dbf'
rm'/home/oracle/../system.dbf'.
.
rm '/home/oracle/../users.dbf' 

mv'/home/oracle/../backup/test.dbf''/home/oracle/../test.dbf'
mv'/home/oracle/../backup/system.dbf''/home/oracle/../system.dbf'
.
mv'/home/oracle/../backup/users.dbf' '/home/oracle/../users.dbf' 
startup mount;
recover database until time '30-dec-2011:11:00:00';
alter database open resetlogs;

---
when i performed this step,it display error "recover succeed but recovery for datafile 1 require more backup..
why is this happend.
Re: Perform incomplete user managed backup and recovery [message #537648 is a reply to message #537646] Fri, 30 December 2011 00:42 Go to previous messageGo to next message
Michel Cadot
Messages: 65848
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From your previous topic:

Michel Cadot wrote on Thu, 29 December 2011 08:42
Use SQL*Plus and copy and paste your session, the WHOLE session.

Regards
Michel


How can we trust what you posted and waid when you already lied to us?

ashishs wrote on Thu, 29 December 2011 09:28
ok,i'm telling lie but you know how to do it,can you correct my step.



Re: Perform incomplete user managed backup and recovery [message #537657 is a reply to message #537648] Fri, 30 December 2011 02:04 Go to previous messageGo to next message
ashishs
Messages: 40
Registered: May 2011
Member

Ok Michel,
i think you dont know about user managed incomplete recovery..read that topic and understand what i want..ok read oracle 10g ws2 pdf read chapter 5.
Re: Perform incomplete user managed backup and recovery [message #537662 is a reply to message #537657] Fri, 30 December 2011 02:18 Go to previous messageGo to next message
Michel Cadot
Messages: 65848
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This does not change a single point of what I wrote.

Regards
Michel
Re: Perform incomplete user managed backup and recovery [message #537666 is a reply to message #537657] Fri, 30 December 2011 02:42 Go to previous message
John Watson
Messages: 7620
Registered: January 2010
Location: Global Village
Senior Member
Ashishs, we have no idea what your problem is. Why not? Because we do not know what you did. But what is certain is that you did NOT do what you say you did.
For example, all your Unix commands will have failed because you have missed out the space seprators that must follow them. So according to what you say, you do not in fact have a backup.

When you ask for advice from one of the best DBAs on the planet (MC does know about user managed recovery) you need to give him the information necessary for him to assist.
Previous Topic: Recovery Catalog
Next Topic: Parttioned table back
Goto Forum:
  


Current Time: Sat Oct 20 18:13:59 CDT 2018