Posts

Showing posts from July 29, 2013

Oracle 10g:RMAN backup restore with Incomplete recovery

Image
 RMAN Backup restore Sometime RMAN Backup needs to restore other machine and check weather it is valid and if any issue come and need to restore to another server.For new test server creation by rman manual restore. RMAN Cloning also one of the finest way to make new cloned database. Follow this easy steps to rman backup restore. 1.Take full rman backup. 2.Map drive of rman backup to destination server or manually copy rman all backup to destination server.    There is one problem of found which files need to copy.If source database available then use this query and find the name of paryticular backup. select tag,to_char(completion_time,'DD-MON-YY') backup_date,'CATALOG BACKUPPIECE '''||fname||''';' fname,round(sum(bs_bytes)/1024/1024/1024,2) backup_size_gb from v$backup_files where trunc(completion_time)=trunc(sysdate) Group by tag,to_char(completion_time,'DD-MON-YY'),fname order by to_char(completi