Skip to main content
Question

RMAN restore error

  • October 5, 2022
  • 1 reply
  • 375 views

Forum|alt.badge.img+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 
 

Forum|alt.badge.img+21
  • Superhero (Employee)
  • October 6, 2022

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings