Skip to content

Instantly share code, notes, and snippets.

@fljdin

fljdin/oracle rman duplicate from backup

Last active August 29, 2015 14:01
Show Gist options
  • Save fljdin/77e760ca30a2586e2ed1 to your computer and use it in GitHub Desktop.
Save fljdin/77e760ca30a2586e2ed1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
oracle rman duplicate from backup
DUPLICATE DATABASE TO dup11r2
UNTIL TIME "TO_DATE('29-MAY-2010 14:16:42','DD-MON-YYYYHH24:MI:SS')"
SPFILE
set control_files='D:\dup11r2\c1.ctl'
set db_file_name_convert='D:\Database\Ora11g2\ora11g2','d:\dup11r2'
set log_file_name_convert='D:\Database\Ora11g2\ora11g2','d:\dup11r2'
BACKUP LOCATION 'D:\dup11r2';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment