Question

RMAN restore error

  • 5 October 2022
  • 1 reply
  • 253 views

Userlevel 1
Badge +3

Hi 

I am doing some testing on RMAN restore. (Restore Database from OLD backup (backup from another server)).

 

rman auxiliary=sys/XXXX@TEST

RMAN> RUN
{
  SET NEWNAME FOR DATABASE TO 'G:\oradata\TEST\%b'; 
  DUPLICATE DATABASE TO 'TEST' BACKUP LOCATION 'I:\PROD_20220530' NOFILENAMECHECK
    LOGFILE
      GROUP 1 (
    'G:\oradata\TEST\REDO011.LOG',
    'G:\oradata\TEST\REDO012.LOG' ) SIZE 50M REUSE,
  GROUP 2 (
    'G:\oradata\TEST\REDO021.LOG',
    'G:\oradata\TEST\REDO022.LOG' ) SIZE 50M REUSE,
  GROUP 3 (
    'G:\oradata\TEST\REDO031.LOG',
    'G:\oradata\TEST\REDO032.LOG' ) SIZE 50M REUSE;
}


RMAN> exit;
I used above command to restore the DB. Now i am getting error middle of the process. 



== ERROR MESSAGE STACK FOLLOWS

IRMAN-03002: failure of Duplicate Db command at 10/04/2022 17:54:48
RMAN-05501: aborting duplication of target database
RMAN-06136: Oracle error from auxiliary database: ORA-00471: DBWR process terminated with error
ORA-00471: DBWR process terminated with error
RMAN-06031: could not translate database keyword

any help much appreciated. 
thank you 
maduranga 
 


1 reply

Userlevel 7
Badge +21

Hi @Maharawaththa ,

You have a syntax error in the duplication command. In your duplicate command you are missing the “TARGET”. correct syntax is “DUPLICATE TARGET DATABASE” instead of “DUPLICATE DATABASE”

Cheers

Reply