RMAN restore error during mount db

Jan 8, 2021 2:49AM

Hi all,

I'm doing db restore from prod backup set.

When mount the database there is error due to exceed db_files.

Any workaround here.

OS : Red hat linux 6

DB : Oracle 12c R1

RMAN> startup nomount pfile='/u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/init01_vmdevspace.ora';

Oracle instance started

Total System Global Area 12884901888 bytes

Fixed Size 3725224 bytes

Variable Size 6777997400 bytes

Database Buffers 6073352192 bytes

Redo Buffers 29827072 bytes

RMAN> restore controlfile from '/svspacebackup/SPACEXFAB1/Daily/ctrlfile_spacexfab1_881993947_20210107_4dvk0gee_1_1';

Starting restore at 2021-01-08 10:41:05

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=198 device type=DISK

Database Backup and Recovery (MOSC)