Database Backup and Recovery (MOSC)

MOSC Banner

Why rman Create Standby Using DUPLICATE isn't working

Hi @All,

i have trouble to start rman duplicate. rman isn't running. I am grateful for any help.

RMAN> duplicate target database

2>  for standby

3>  from active database

4>  dorecover

5>  spfile

6>   set db_unique_name='bgp_stby' COMMENT 'Is standby'

7>  nofilenamecheck;


Starting Duplicate Db at 23-JUN-23

using channel ORA_AUX_DISK_1

current log archived


contents of Memory Script:

{

  backup as copy reuse

  passwordfile auxiliary format 'D:\oracle\BGP\19.0.0\DATABASE\PWDbgp.ORA'  ;

  restore clone from service 'bgp' spfile to

 'D:\ORACLE\BGP\19.0.0\DATABASE\SPFILEBGP.ORA';

  sql clone "alter system set spfile= ''D:\ORACLE\BGP\19.0.0\DATABASE\SPFILEBGP.ORA''";

}

executing Memory Script


Starting backup at 23-JUN-23

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