Tuesday, January 10, 2006

Duplicate database by until logseq

Example: command-line by RMAN

run {
allocate auxiliary channel c1 device type disk ;
set until logseq 3585;
set newname for datafile 1 to '/oracle/dupdb/file1.dbf';
set newname for datafile 2 to '/oracle/dupdb/file2.dbf';
set newname for datafile 3 to '/oracle/dupdb/file3.dbf';
set newname for datafile 4 to '/oracle/dupdb/file4.dbf';
set newname for datafile 27 to '/oracle/dupdb/file27.dbf';
set newname for datafile 28 to '/oracle/dupdb/file28.dbf';
duplicate target database to 'dupdb'
skip tablespace USERS,...,...
logfile
group 1 ('/oracle/dupdb/redo1.log') size 10M reuse,
group 2 ('/oracle/dupdb/redo2.log') size 10M reuse;
}

--- duplicate datafiles to new location and skip some tablespaces

No comments: