Home » RDBMS Server » Backup & Recovery » how to force the old backup for recovery (10.2.0.1.0,NT)
how to force the old backup for recovery [message #278018] Thu, 01 November 2007 08:09 Go to next message
lm_suresh
Messages: 24
Registered: September 2007
Location: Chennai,India
Junior Member
Hi
I am learning RMAN. Question might be very basic but i need clarification.
This is my backupset list.
RMAN> list backup summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
542 B F A DISK 30-OCT-07 1 1 NO TAG20071030T142511
543 B F A DISK 30-OCT-07 1 1 NO TAG20071030T142511
544 B F A DISK 30-OCT-07 1 1 NO TAG20071030T142511
677 B F A DISK 30-OCT-07 1 1 NO TAG20071030T144138
711 B F A DISK 30-OCT-07 1 1 NO TAG20071030T145501
724 B F A DISK 30-OCT-07 1 1 NO TAG20071030T145505
749 B F A DISK 30-OCT-07 1 1 NO TAG20071030T151650
765 B F A DISK 30-OCT-07 1 1 NO TAG20071030T151654
807 B F A DISK 30-OCT-07 1 1 NO TAG20071030T152033
825 B F A DISK 30-OCT-07 1 1 NO TAG20071030T152037
880 B A A DISK 30-OCT-07 1 1 NO TAG20071030T173941
903 B F A DISK 30-OCT-07 1 1 NO TAG20071030T173948
1023 B F A DISK 01-NOV-07 1 1 NO TAG20071101T152118
1024 B F A DISK 01-NOV-07 1 1 NO TAG20071101T152118
1169 B F A DISK 01-NOV-07 1 1 NO TAG20071101T153653


How to differentiate the rman backupsets. Here i have taken full database backup 3 times and i want to use the backup which is obsolete for recovery. how i can i force to use the particular set of backup for recovery.

Thanks.
Suresh

Re: how to force the old backup for recovery [message #278029 is a reply to message #278018] Thu, 01 November 2007 09:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can use "until" clause just after the backup you want to use.
Or you can use "change" command to make some backup unavailable.

Regards
Michel
Re: how to force the old backup for recovery [message #278037 is a reply to message #278018] Thu, 01 November 2007 10:46 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You could specify the TAG name in your restore command (ie. RESTORE...FROM TAG...).
Re: how to force the old backup for recovery [message #278129 is a reply to message #278018] Fri, 02 November 2007 00:21 Go to previous messageGo to next message
lm_suresh
Messages: 24
Registered: September 2007
Location: Chennai,India
Junior Member
It will be helpful if you could post some reference links for study/practice.

Thanks
Suresh
Re: how to force the old backup for recovery [message #278153 is a reply to message #278129] Fri, 02 November 2007 02:11 Go to previous message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://tahiti.oracle.com

Regards
Michel
Previous Topic: refresg using rman
Next Topic: reuse existing dbf file from another corrupted DB
Goto Forum:
  


Current Time: Mon May 20 08:48:32 CDT 2024