Shulou(Shulou.com)05/31 Report--

In this issue, the editor will bring you about how to restore ORACLE11G RMAN backup to a different database. The article is rich in content and analyzes and describes for you from a professional point of view. I hope you can get something after reading this article.

Scp / u01qprbqpr / rmanbk * oracle@prd-db2:/u01/prb/rmanbk/

Restore parameter files and control files

Scp / u01/app/oracle/oradata/prb/control01.ctlprd-db2:/u01/app/oracle/oradata/prb/

Boot to mount status is normal

ORACLE instance started.

Total System Global Area 584568832 bytes

Variable Size 226493880 bytes

Redo Buffers 3497984 bytes

Register data file backup and archive backup in the new control file

Prd-db2- > rman target /

Recovery Manager: Release 11.2.0.4.0-Production on Wed Aug 1718

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to target database: PRB (DBID=1906641159, not open)

RMAN > catalog start with'/ u01qqprbplash rmanbkUnix'

Using target database control file instead of recovery catalog

Searching for all files that match the pattern / u01/prb/rmanbk/

No files found to be unknown to the database

Restore the entire library

RMAN > restore database

Starting restore at 2016-08-17 18:53:42

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: SID=18 device type=DISK

Channel ORA_DISK_1: starting datafile backup set restore

Channel ORA_DISK_1: specifying datafile (s) to restore frombackup set

Channel ORA_DISK_1: restoring datafile 00001 to/u01/app/oracle/oradata/prb/system01.dbf

Channel ORA_DISK_1: restoring datafile 00002 to/u01/app/oracle/oradata/prb/sysaux01.dbf

Channel ORA_DISK_1: restoring datafile 00003 to/u01/app/oracle/oradata/prb/undotbs01.dbf

Channel ORA_DISK_1: restoring datafile 00004 to/u01/app/oracle/oradata/prb/users01.dbf

Channel ORA_DISK_1: reading from backup piece/u01/prb/rmanbk/fulldb_PRB_03rdg8cm_1_1

Channel ORA_DISK_1: piecehandle=/u01/prb/rmanbk/fulldb_PRB_03rdg8cm_1_1 tag=TAG20160817T164718

Channel ORA_DISK_1: restored backup piece 1

Channel ORA_DISK_1: restore complete, elapsed time: 00:00:15

Finished restore at 2016-08-17 18:53:57

RMAN > recover database

Starting recover at 2016-08-17 18:54:12

Using channel ORA_DISK_1

Starting media recovery

Channel ORA_DISK_1: starting archived log restore to defaultdestination

Channel ORA_DISK_1: restoring archived log

Archived log thread=1 sequence=7

Channel ORA_DISK_1: reading from backup piece/u01/prb/rmanbk/fulldb_PRB_05rdg8d7_1_1

Channel ORA_DISK_1: piecehandle=/u01/prb/rmanbk/fulldb_PRB_05rdg8d7_1_1 tag=TAG20160817T164735

Channel ORA_DISK_1: restored backup piece 1

Channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

Archived log file name=/u01/app/oracle/fast_recovery_area/PRB/archivelog/2016_08_17/o1_mf_1_7_cv8jlo4y_.arcthread=1 sequence=7

RMAN-00571:===

RMAN-00569: = ERROR MESSAGE STACK FOLLOWS=

RMAN-00571: =

RMAN-03002: failure of recover command at 08/17/2016 18:54:14

ORA-00283: recovery session canceled due to errors

RMAN-11003: failure during parse/execution of SQL statement:alter database recover logfile'/ u01 ActionActionoracleActionfastfastfastrecoveryAccorareaPRBAccording to ArchivelogAccording to 2016 / 08 / 17 / 2011 / 01 / 08 / 17 / 01 / 08 / 17 / 01appl / oraclea / oracle.arc'

ORA-00283: recovery session canceled due to errors

ORA-00313: open failed for members of log group 2 of thread 1

ORA-00312: online log 2 thread 1:'/ u01 thread

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

Recovery in the case of missing archive logs

Prd-db2- > export ORACLE_SID=prb

Prd-db2- > sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Aug 17 19:03:522016

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real ApplicationTesting options

SQL > shutdown immediate

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL > startup mount

ORACLE instance started.

Total System Global Area 584568832 bytes

Fixed Size 2255432 bytes

Variable Size 226493880 bytes

Database Buffers 352321536 bytes

Redo Buffers 3497984 bytes

Database mounted.

SQL > alter database open

Alter database open

*

ERROR at line 1:

ORA-01589: must use RESETLOGS or NORESETLOGS option fordatabase open

SQL > alter database open noresetlogs

Alter database open noresetlogs

*

ERROR at line 1:

ORA-01588: must use RESETLOGS option for database open

SQL > alter database open resetlogs

Database altered.

SQL > select max (sequence#) from v$archived_log

MAX (SEQUENCE#)

-

seven

The database starts normally

Prd-db2- > export ORACLE_SID=prb

Prd-db2- > sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Aug 17 19:11:492016

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real ApplicationTesting options

SQL > shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL > startup

ORACLE instance started.

Total System Global Area 584568832 bytes

Fixed Size 2255432 bytes

Variable Size 226493880 bytes

Database Buffers 352321536 bytes

Redo Buffers 3497984 bytes

Database mounted.

Database opened.

This is how the ORACLE11G RMAN backup shared by the editor can be restored to a different database. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

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.