col file_name format a60
set linesize 130
select 'alter database datafile '''||file_name ||''' offline;' from dba_data_files where file_name like '+ORCL_DATA1%';
SQL> alter database datafile '+ORCL_DATA1/ORCL/datafile/dwprd.538.890842741' offline;
RMAN> copy datafile '+ORCL_DATA1/ORCL/datafile/dwprd.538.890842741' to '+ORCL_DATA';
Starting backup at 24-SEP-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1903 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00044 name=+ORCL_DATA1/ORCL/datafile/dwprd.538.890842741
output file name=+ORCL_DATA/ORCL/datafile/dwprd.272.891298569 tag=TAG20150924T225609 RECID=1 STAMP=891298705
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:25
Finished backup at 24-SEP-15
Starting Control File and SPFILE Autobackup at 24-SEP-15
piece handle=/orcldb/db/orcl_base/11.2.0/dbs/c-941435738-20150924-01 comment=NONE
Finished Control File and SPFILE Autobackup at 24-SEP-15
SQL> alter database rename file '+ORCL_DATA1/ORCL/datafile/dwprd.538.890842741' to '+ORCL_DATA/ORCL/datafile/dwprd.272.891298569';
RMAN> switch datafile '+ORCL_DATA/ORCL/datafile/dwprd.272.891298569' to copy;
RMAN> recover datafile '+ORCL_DATA/ORCL/datafile/dwprd.272.891298569';
SQL> alter database datafile '+ORCL_DATA/ORCL/datafile/dwprd.272.891298569' online;
set linesize 130
select 'alter database datafile '''||file_name ||''' offline;' from dba_data_files where file_name like '+ORCL_DATA1%';
SQL> alter database datafile '+ORCL_DATA1/ORCL/datafile/dwprd.538.890842741' offline;
RMAN> copy datafile '+ORCL_DATA1/ORCL/datafile/dwprd.538.890842741' to '+ORCL_DATA';
Starting backup at 24-SEP-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1903 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00044 name=+ORCL_DATA1/ORCL/datafile/dwprd.538.890842741
output file name=+ORCL_DATA/ORCL/datafile/dwprd.272.891298569 tag=TAG20150924T225609 RECID=1 STAMP=891298705
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:25
Finished backup at 24-SEP-15
Starting Control File and SPFILE Autobackup at 24-SEP-15
piece handle=/orcldb/db/orcl_base/11.2.0/dbs/c-941435738-20150924-01 comment=NONE
Finished Control File and SPFILE Autobackup at 24-SEP-15
SQL> alter database rename file '+ORCL_DATA1/ORCL/datafile/dwprd.538.890842741' to '+ORCL_DATA/ORCL/datafile/dwprd.272.891298569';
RMAN> switch datafile '+ORCL_DATA/ORCL/datafile/dwprd.272.891298569' to copy;
RMAN> recover datafile '+ORCL_DATA/ORCL/datafile/dwprd.272.891298569';
SQL> alter database datafile '+ORCL_DATA/ORCL/datafile/dwprd.272.891298569' online;
No comments:
Post a Comment