Database Backup and Recovery (MOSC)

MOSC Banner

RMAN takes too long to complete restoring a db

edited Jan 15, 2015 11:56AM in Database Backup and Recovery (MOSC) 7 commentsAnswered

Hi there,

I'm trying to make a complete restore of a database using RMAN, I have a full backup on tape. The media manager is EMC Networker.

My server runs Oracle Linux 6.5, the Oracle software is Oracle Database Enterprise Edition 11g (11.2.0.4).

After preparing the pfile, the next step was to restore the control file, but then it just stays there:

export ORACLE_SID=

rman target /

shutdown abort

SET DBID=<original dbid>;

RMAN> STARTUP FORCE NOMOUNT PFILE='/u01/app/oracle/product/11.2.0/dbhome_1/dbs/pfile.ora';

RMAN> RUN {

  ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE';

    SEND DEVICE TYPE 'SBT_TAPE' 'NSR_ENV=(NSR_CHECKSUM=true)';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center