mkdir -p /u01/app/oracle/admin/hk/{adump,bdump,cdump,dpdump,udump,pfile}
让客户满意是我们工作的目标,不断超越客户的期望值来自于我们对这个行业的热爱。我们立志把好的技术通过有效、简单的方式提供给客户,将通过不懈努力成为客户在信息化领域值得信任、有价值的长期合作伙伴,公司提供的服务项目有:国际域名空间、网站空间、营销软件、网站建设、祥云网站维护、网站推广。
mkdir -p /u01/app/oracle/oradata/hk
mkdir -p /u01/app/oracle/fast_recovery_area/hk
echo 'db_name=hk' > $ORACLE_HOME/dbs/inithk.ora
more $ORACLE_HOME/dbs/inithk.ora
export ORACLE_SID=hk
rman target /
set dbid 3515046639 --原始数据库dbid
startup nomount; --启动到nomount
-----恢复spfile文件
restore spfile from '/u01/app/oracle/oradata/hk/hk_spfile_81t2a2gm_1_1.bak';
startup nomount force;-----重启实例到nomount状态
查看spfile文件中控制文件路径,并创建或者如下
restore controlfile from '/u01/app/oracle/oradata/hk/hk_Controlfile_c-3278571708-20180506-01';
ORA-19870: error while restoring backup piece /u01/app/oracle/oradata/hk/hk_Controlfile_c-3278571708-20180506-01
ORA-19504: failed to create file "/oradata/hk/control01.ctl"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
mkdir -p /oradata/hk
restore controlfile from '/u01/app/oracle/oradata/hk/hk_Controlfile_c-3278571708-20180506-01';
alter database mount;启动实例到mount状态
restore database; //还原数据文件
channel ORA_DISK_1: ORA-19870: error while restoring backup piece /backup/database/hk_full_6mt1jcvt_1_1
ORA-19505: failed to identify file "/backup/database/hk_full_6mt1jcvt_1_1"
ORA-27037: unable to obtain file status
-------检查/backup/database权限和路径,
restore database;
recover database;
archived log thread=1 sequence=1735
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/07/2018 01:02:08
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 1735 and starting SCN of 34275591
recover database until scn 34275591;
alter database open resetlogs;------至此恢复完毕
RMAN> quit
验证:
sqlplus / as sysdba
select name,OPEN_MODE from v$database;