rman全备份

backup database  format '/oracle/backup/full_%U' tag 'fullback';

backup controlfile format '/oracle/backup/controlfile_bak';

backup spfile format '/oracle/backup/spfile_bak'

dd if=/dev/vgdata/rlv_cdb1_password_50m f=/oracle/backup/orapwtdbs2 bs=8192

rman恢复

cd $ORALCE_HOME/dbs

echo "SPFILE='/dev/vgdgdata/rlv_tdb1_spfile_50m'">$ORACLE_HOME/dbs/inittdbs2.ora

ln -s /dev/vgdata/rlv_cdb1_password_50m  orapwtdbs2

dd if=/oracle/backup/spfile_bak f=/dev/vgdata/rlv_qdb3_spfile_50m

dd if=/oracle/backup/orapwtdbs2 f=/dev/vgdata/rlv_cdb1_password_50m

rman target /

----create spfile='/dev/vgdata/rlv_qdb3_spfile_50m' from pfile='/oracle/backup/pfile_bak'

sql 'startup nomount';

restore controlfile  from '/oracle/backup/contorl_sldf';

sql 'alter database mount';

run

{

set newname for datafile 1 to '/dev/vgdata/rlv_qdb3_system01_4g';
set newname for datafile 2 to '/dev/vgdata/rlv_qdb3_undotbs01_10g';
set newname for datafile 3 to '/dev/vgdata/rlv_qdb3_sysaux01_8g';
set newname for datafile 4 to '/dev/vgdata/rlv_qdb3_t29_30g';
set newname for datafile 5 to '/dev/vgdata/rlv_qdb3_users01_1g';
set newname for datafile 6 to '/dev/vgdata/rlv_qdb3_others01_30g';
set newname for datafile 7 to '/dev/vgdata/rlv_qdb3_r01_30g';
set newname for datafile 8 to '/dev/vgdata/rlv_qdb3_t01_30g';
set newname for datafile 9 to '/dev/vgdata/rlv_qdb3_index01_30g';
set newname for datafile 10 to '/dev/vgdata/rlv_qdb3_abc01_16g';

restore database ;

switch datafile all;

}

sql>alter database rename file '/dev/vgdata/rlv_ldb1_redo11_1g' to '/dev/vgdata/rlv_qdb3_redo11_1g';

sql>alter database tempfile '/dev/vgdata/rlv_ldb1_temp01_5g' offline;

sql>alter database rename file '/dev/vgdata/rlv_ldb1_temp01_5g'  to '/dev/vgdata/rlv_qdb3_t02_30g';

recover database