Home > Administration with ASM, ASM > Can’t restore backup of database

Can’t restore backup of database

I need to restore a database to different asm diskgroup. Once I start to restore the database with the command follows.

run{
set newname for datafile 1 to ‘+DISKGROUP/cmsprod/datafile/system.261.670168721’;
set newname for datafile 2 to ‘+DISKGROUP/cmsprod/datafile/undotbs1.262.670168727’;
set newname for datafile 3 to ‘+DISKGROUP/cmsprod/datafile/sysaux.263.670168729’;
set newname for datafile 4 to ‘+DISKGROUP/cmsprod/datafile/undotbs2.265.670168733’;
set newname for datafile 5 to ‘+DISKGROUP/cmsprod/datafile/users.266.670168737’;
set newname for datafile 6 to ‘+DISKGROUP/cmsprod/datafile/tbs_cms.296.670173343’;
set newname for datafile 7 to ‘+DISKGROUP/cmsprod/datafile/tbs_production.297.670173385’;
set newname for datafile 8 to ‘+DISKGROUP/cmsprod/datafile/tbs_volantis_mcs.298.670173393’;
set newname for datafile 9 to ‘+DISKGROUP/cmsprod/datafile/volantis_tbs.316.670175271’;
set newname for datafile 10 to ‘+DISKGROUP/cmsprod/datafile/tbs_volantis_mcs_stg.317.670174997’;
set newname for datafile 11 to ‘+DISKGROUP/cmsprod/datafile/perfstat.335.671363091’;
set newname for datafile 12 to ‘+DISKGROUP/cmsprod/datafile/undotbs3.389.673005569’;
set newname for datafile 13 to ‘+DISKGROUP/cmsprod/datafile/tbs_cms.397.700411387’;
set newname for datafile 14 to ‘+DISKGROUP/cmsprod/datafile/tbs_cms.393.731520969’;
set newname for datafile 15 to ‘+DISKGROUP/cmsprod/datafile/manuted.368.731673341’;
set newname for datafile 16 to ‘+DISKGROUP/cmsprod/datafile/tbs_cms.401.736106307’;
restore database;
}

The message returned as below. It showed that it couldn’t connect to ASM Instance since the maximum number of processes exceeded. The default ASM instance default process is 40.

ORA-19870: error reading backup piece /u01/bkup/database/cmsprod/CMSPROD_data_bkup_5193
ORA-19504: failed to create file “+DISKGROUP”
ORA-17502: ksfdcre:4 Failed to create file +DISKGROUP
ORA-15055: unable to connect to ASM instance
ORA-00020: maximum number of processes () exceeded
ORA-15055: unable to connect to ASM instance
ORA-00020: maximum number of processes () exceeded
failover to previous backup

Fix Procedures

Then I increased process number in ASM instance and restarted. The problem is fixed

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: