RMAN>run{
2> allocate auxiliary channel c1 type disk;
3> recover tablespace jlwang until scn 1023871;}
allocated channel: c1
channel c1: sid=35 devtype=DISK
Starting recover at 06-JUL-07
contents of Memory Script:
{
# set the until clause
set untilscn 1023871;
# restore the controlfile
restore clone controlfile;
# mount the controlfile
sql clone 'alter database mount clone database';
# archive current online log for tspitr to a resent until time
sql 'alter system archive log current';
# avoid unnecessary autobackups for structural changes during TSPITR
sql 'begin dbms_backup_restore.AutoBackupFlag(FALSE); end;';
# resync catalog after controlfile restore
resync catalog;
}
executing Memory Script
executing command: SET until clause
Starting restore at 06-JUL-07
channel c1: starting datafile backupset restore
channel c1: restoring control file
channel c1: reading from backup piece /oracle/u01/app/oracle/flash_recovery_area/ORA10/autobackup/2007_07_06/o1_mf_s_627198612_38w42og4_.bkp
channel c1: restored backup piece 1
piece handle=/oracle/u01/app/oracle/flash_recovery_area/ORA10/autobackup/2007_07_06/o1_mf_s_627198612_38w42og4_.bkp tag=TAG20070706T055012
channel c1: restore complete, elapsed time: 00:00:03
output filename=/oracle/u02/oradata/jlwang/control01.ctl
output filename=/oracle/u02/oradata/jlwang/control02.ctl
output filename=/oracle/u02/oradata/jlwang/control03.ctl
Finished restore at 06-JUL-07
sql statement: alter database mount clone database
sql statement: alter system archive log current
sql statement: begin dbms_backup_restore.AutoBackupFlag(FALSE); end;
starting full resync of recovery catalog
full resync complete
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/06/2007 07:06:12
RMAN-06136: ORACLE error from auxiliary database: ORA-06550: line 1, column 7:
PLS-00553: character set name is not recognized
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated
不知道到底错哪里了。
请帮忙看一看,瞧一瞧!
allocate auxiliary channel
recover tablespace jlwang ???
The auxiliary instance is only used for duplicate and standby database created with the DUPLICATE command and for tablespace point-in-time .