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
 
 
 
Reply to this topicStart new topic
> RMAN Restore, Restoring using last available Archive Log
hy.qube
post May 16 2017, 11:48 AM
Post #1


Advanced Member
***

Group: Members
Posts: 86
Joined: 17-May 14
From: London
Member No.: 49,627



Hi All,

We have a scenario we are testing but before we go ahead I am wondering is someone can advice. We are using Oracle 12c Standard Edition running on windows 2012 R2, backups running using a catalog, archive logs being switched every 30 minutes and copied off to the backup server.

We have tested a scenario where we recover to a point in time which is fine and works as expected. For instance if we wanted to restore to 5pm today:

RUN
{
STARTUP NOMOUNT
SET UNTIL TIME "TO_DATE('16052017 17:00:00','DDMMYYYY HH24:MI:SS')";
RESTORE CONTROLFILE;
ALTER DATABASE MOUNT;
RESTORE DATABASE;
RECOVER DATABASE;
}
ALTER DATABASE OPEN RESETLOGS;
RESYNC CATALOG;

We are now testing the scenario where we lose the server and have to restore the back by using

the last full backup
last cumulative backup
available archive logs we have copied back off the backup server

So rather than providing a point of time restore I am assuming we run:

RUN
{
STARTUP NOMOUNT
RESTORE CONTROLFILE;
ALTER DATABASE MOUNT;
RESTORE DATABASE;
RECOVER DATABASE;
}
ALTER DATABASE OPEN RESETLOGS;
RESYNC CATALOG;

Will this restore to the last available archive log available on the file system?

Hakan
Go to the top of the page
 
+Quote Post
burleson
post May 22 2017, 09:51 AM
Post #2


Advanced Member
***

Group: Members
Posts: 13,577
Joined: 26-January 04
Member No.: 13



Hi Hakan,

Sorry about the delay!

>> Will this restore to the last available archive log available on the file system?

This page is packed with working RMAN examples:

http://www.dba-oracle.com/t_rman_67_disaster_recovery.htm

Also see here:

http://dba-oracle.com/googlesearchsite_pro...6307j28689069j4

Good Luck!




--------------------
Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
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: 23rd October 2017 - 01:39 PM