唐SIR
课后按照指点的，修改了rcv,添加了控制文件路径，但是克隆依然报错，求解~
就这东西，反反复复好几天了，一直有问题~
下面是最后步骤的错误信息：
Starting restore at 2016-07-19:14:24:39
using channel ORA_AUX_DISK_1
Oracle instance started
Total System Global Area 1607008256 bytes
Fixed Size 1345240 bytes
Variable Size 520096040 bytes
Database Buffers 1073741824 bytes
Redo Buffers 11825152 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''RCAT'' comment=
''Reset to original value by RMAN'' scope=spfile";
sql clone "alter system reset db_unique_name scope=spfile";
shutdown clone immediate;
}
executing Memory Script
Errors in memory script
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not mounted
ORA-06512: at "SYS.X$DBMS_RCVMAN", line 13466
ORA-06512: at line 1
RMAN-05556: not all datafiles have backups that can be recovered to SCN 2708028
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/19/2016 14:24:41
RMAN-05501: aborting duplication of target database
Recovery Manager complete.
到此，我以为不能mount数据库，试着手动mount了一下，发现是可以得
[oracle@station76 dbs]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jul 19 14:25:07 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> alter database mount;
Database altered.
备份脚本如下
run { allocate channel c1 device type disk format '/u02/backup/%U.bkp'; allocate channel c2 device type disk format '/u02/backup/%U.bkp '; allocate channel c3 device type disk format '/u02/backup/%U.bkp '; allocate channel c4 device type disk format '/u02/backup/%U.bkp '; allocate channel c5 device type disk format '/u02/backup/%U.bkp '; allocate channel c6 device type disk format '/u02/backup/%U.bkp '; allocate channel c7 device type disk format '/u02/backup/%U.bkp '; allocate channel c8 device type disk format '/u02/backup/%U.bkp '; backup database plus archivelog force; backup spfile; backup current controlfile; } rcv脚本如下：
run{ duplicate target database to rcat backup location '/u02/backup/' nofilenamecheck spfile set control_files='/u01/app/oracle/oradata/rcat/control01.ctl','/u01/app/oracle/oradata/rcat/control02.ctl' set db_file_name_convert='/u01/app/oracle/oradata/rcat/','/u01/app/oracle/oradata/rcat' set log_file_name_convert='/u01/app/oracle/oradata/rcat/','/u01/app/oracle/oradata/rcat' set audit_file_dest='/u01/app/oracle/admin/rcat/adump' set db_create_file_dest='' set db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'; } 源头数据库rcat备份出来的结果如下：[oracle@station90 admin]$ ls /u02/backup/
1erb3gti_1_1.bkp 1grb3gti_1_1.bkp 1irb3gti_1_1.bkp 1krb3gti_1_1.bkp 1mrb3gu2_1_1.bkp 1orb3gu2_1_1.bkp 1qrb3gu2_1_1.bkp 1srb3gui_1_1.bkp
1frb3gti_1_1.bkp 1hrb3gti_1_1.bkp 1jrb3gti_1_1.bkp 1lrb3gti_1_1.bkp 1nrb3gu2_1_1.bkp 1prb3gu2_1_1.bkp 1rrb3gu2_1_1.bkp 1trb3guj_1_1.bkp
[oracle@station90 admin]$ du -sh /u02/backup/
2.1G /u02/backup/ 目标数据库复制命令，及检查结果如下：[oracle@station76 dbs]$ scp [url=mailto racle@192.168.0.90:/u02/backup/]oracle@192.168.0.90:/u02/backup/[/url]* /u02/backup/
[url=mailtoracle@192.168.0.90]oracle@192.168.0.90's[/url] password:
1erb3gti_1_1.bkp 100% 71MB 71.1MB/s 00:01
1frb3gti_1_1.bkp 100% 119MB 39.7MB/s 00:03
1grb3gti_1_1.bkp 100% 109MB 36.2MB/s 00:03
1hrb3gti_1_1.bkp 100% 57MB 28.4MB/s 00:02
1irb3gti_1_1.bkp 100% 120MB 59.8MB/s 00:02
1jrb3gti_1_1.bkp 100% 113MB 37.7MB/s 00:03
1krb3gti_1_1.bkp 100% 116MB 38.6MB/s 00:03
1lrb3gti_1_1.bkp 100% 115MB 38.4MB/s 00:03
1mrb3gu2_1_1.bkp 100% 613MB 47.2MB/s 00:13
1nrb3gu2_1_1.bkp 100% 627MB 34.8MB/s 00:18
1orb3gu2_1_1.bkp 100% 2240KB 2.2MB/s 00:00
1prb3gu2_1_1.bkp 100% 20MB 20.2MB/s 00:01
1qrb3gu2_1_1.bkp 100% 9568KB 9.3MB/s 00:00
1rrb3gu2_1_1.bkp 100% 96KB 96.0KB/s 00:00
1srb3gui_1_1.bkp 100% 96KB 96.0KB/s 00:00
1trb3guj_1_1.bkp 100% 9568KB 9.3MB/s 00:00 [oracle@station76 dbs]$ ls /u02/backup
1erb3gti_1_1.bkp 1grb3gti_1_1.bkp 1irb3gti_1_1.bkp 1krb3gti_1_1.bkp 1mrb3gu2_1_1.bkp 1orb3gu2_1_1.bkp 1qrb3gu2_1_1.bkp 1srb3gui_1_1.bkp
1frb3gti_1_1.bkp 1hrb3gti_1_1.bkp 1jrb3gti_1_1.bkp 1lrb3gti_1_1.bkp 1nrb3gu2_1_1.bkp 1prb3gu2_1_1.bkp 1rrb3gu2_1_1.bkp 1trb3guj_1_1.bkp
[oracle@station76 dbs]$ du -sh /u02/backup/
2.1G /u02/backup/
| 
发表于 2016-7-19 14:36:01
发表于 2016-7-19 20:03:40
