Shulou(Shulou.com)06/01 Report--

Rman off-machine recovery 1. Create directories needed for recovery

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

Second, set init and sid

Echo 'db_name=hk' > $ORACLE_HOME/dbs/inithk.ora

More $ORACLE_HOME/dbs/inithk.ora

Export ORACLE_SID=hk

Rman target /

Set dbid 3515046639-original database dbid

III. Begin to recover

Startup nomount;-- Boot to nomount

-restore spfile files

Restore spfile from'/ u01qapqqoracleUnixoradataPlacement hkUnix spfile81t2a2gmqq'.bak'

Startup nomount force;- restarts the instance to nomount state

View the control file path in the spfile file, and create either the following

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; starts the instance to mount status

Restore database; / / restore data files

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

-check / backup/database permissions and paths

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;- has been restored at this point

RMAN > quit

Verify:

Sqlplus / as sysdba

Select name,OPEN_MODE from v$database

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.