(1)将源数据库端的plife取出
set oracle_sid =zsddb
sqlplus "/as sysdba"
create pfile='/data/backup/pfile_zsddb.ora' from spfile;
(2)用文本工具修改相关参数保存,在目标端创建spfile
create spfile from pile ='/data/backup/pfile_zsddb.ora'
4.恢复控制文件并进入到加载状态
从备份集中恢复控制文件
set oracle_sid=zsddb
rman target /
RMAN>set dbid=1536079480
RMAN>RESTORE CONTROLFILE FROM '/data/backup/c-1536079480-20121103-00';
就是做到这一步的时候。报出了错误
Starting restore at 08-NOV-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=19 device type=DISK
channel ORA_DISK_1: no AUTOBACKUP in 7 days found
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/08/2012 17:46:48
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
是不是我的思路有问题,还是哪个细节缺漏了?
版本都是*.compatible='11.2.0.0.0'
一:执行:startup nomount的时候,出现如下错误:
ERROR:
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9925
ORA-01075: you are currently logged on
解决方法:创建目录
mkdir -p /data/ora11g/admin/userdb/adump
二:执行:RESTORE CONTROLFILE FROM '/data/backup/rman/con_c-3913726272-20121103-00'的时候,出现如下错误:
channel ORA_DISK_1: no AUTOBACKUP in 7 days found
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/08/2012 17:46:48
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
解决方法:看看对应的/data/backup/rman/目录下文件的权限问题。
chown oracle
racle /data/backup/rman/*
三:执行:RESTORE DATABASE;的时候,出现如下错误:
channel ORA_DISK_1: ORA-19870: error while restoring backup piece /data/backup/rman/18nop29i_1_1-USERDB-20121027.full
ORA-19504: failed to create file "/data/ora11g/oradata/userdb/hdmember01.dbf"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
解决方法:建立对应的数据目录:
mkdir -p /data/ora11g/oradata/userdb/
这是我解决这个问题的所有思路和过程。希望给以后碰到同样问题的人有启迪的作用。