Thursday 6 November 2014

RMAN check all the backup in one go


Do the following from RMAN while connected to the target. If the preview fail then so will the duplication. 

Do the following so we will know your RMAN configuration. 

To get the right time of the backup you have to make sure NLS date is set. 

If using csh 

setenv NLS_DATE_FORMAT 'DD-MON-YYYY HH24:MI:SS' 

If using ksh use: 

export NLS_DATE_FORMAT='DD-MON-YYYY HH24:MI:SS' 

RMAN >>@RMAN_CHECK.RCV ( MAKE FILE OF BELOW CONTENT )

spool log to preview.log; 
set echo on; 

show all; 


list incarnation of database; 


run { 

set until time "to_date('25-09-2014 20:00:00','DD-MM-YYYY HH24:MI:SS')"; 
allocate channel d1 type='sbt_tape'; 
restore preview database controlfile spfile;} 


list backup summary; 


list backup of database archivelog all; 


list backup of controlfile; 


list archivelog all; 


report schema; 


list copy of database; 


-- Upload preview.log 


==============================
RMAN 11GR2 : DUPLICATE Without Target And Recovery Catalog Connection ( Doc ID 874352.1 ) 

No comments: