Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
> Rman Restore on 11g
Jerald Praveen
post May 15 2011, 07:09 AM
Post #1


Newbie
*

Group: Members
Posts: 5
Joined: 17-January 09
Member No.: 39,471



Hi,

I have some problem while restore the database in separate environment.

This My backup policy and retention

I have monthly full database backup on march the backup started 2nd march 15:31 and completed at 03 march 11:12 AM retention period 3 years

We have ADHOC ARCHIVE backup which will run for certain conditions if the file system threshold reach 80%

In between the monthly backup the ADHOC ARCHIVE jobs has executed from 03Mar2011 00:00 to 03Mar2011 05:14 this retention period is 30 days

So while restore the database with the help of monthly backup i can't able to recover the the datafiles due to adhoc archive files are missing.

If there is any way to rectify this situation

Regards
Jerry
Go to the top of the page
 
+Quote Post
 
Start new topic
Replies (1 - 4)
SteveC
post May 15 2011, 08:57 AM
Post #2


Advanced Member
***

Group: Members
Posts: 2,835
Joined: 11-March 08
Member No.: 18,933



If you backed up the archived redo logs, then restore them.
Go to the top of the page
 
+Quote Post
Jerald Praveen
post May 15 2011, 09:02 AM
Post #3


Newbie
*

Group: Members
Posts: 5
Joined: 17-January 09
Member No.: 39,471



Hi steve

its not in the tape because of retention period ,its 30 days only

Regards
Jerald
Go to the top of the page
 
+Quote Post
SteveC
post May 15 2011, 09:24 AM
Post #4


Advanced Member
***

Group: Members
Posts: 2,835
Joined: 11-March 08
Member No.: 18,933



Restore from an older backup.
Go to the top of the page
 
+Quote Post
RHR
post May 18 2011, 04:20 PM
Post #5


Advanced Member
***

Group: Admin
Posts: 230
Joined: 25-September 07
Member No.: 12,334



More information on RMAN incremental backups is available here:

http://www.dba-oracle.com/t_incr_different...ive_backups.htm

RHR
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 22nd October 2014 - 02:57 AM