No question at this time
DBA Top 10
1 M. Cadot 10400
2 A. Kavsek 9400
3 B. Vroman 4800
4 P. Wisse 4300
5 J. Schnackenberg 2900
6 J. PĂ©ran 2000
7 . Lauri 1000
8 F. Pachot 500
9 Z. Hudec 400
9 G. Lambregts 400
9 N. Havard 400
9 T. Boles 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48524
Total active users1409
Act. users last 24h3
Act. users last hour0
Registered user hits last week77
Registered user hits last month415
Go up

syntax hint
Next thread: lots of processes
Prev thread: Multiple Oracle versions in the same Windows Cluster

Message Score Author Date
Hi, restoring a db on a new system where diskgrou...... Alain Bourgeois Jun 29, 2020, 17:58
Hi Alain, you tell your instance which Disk Gro...... Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts Jan Schnackenberg Jun 29, 2020, 22:26

Follow up by mail Click here


Subject: syntax hint
Author: Alain Bourgeois, Belgium
Date: Jun 29, 2020, 17:58, 39 days ago
Os info: linux 6
Oracle info: 12.2 EE
Message: Hi,
restoring a db on a new system where diskgroups are different.
rman {
... set newname ...;
restore ...;
switch datafile all;
}

But redo log group (and FRA) have also changed.
Is there any command to type before starting recovery (from archivelogs) to tell oracle to use a new dg for online logs / FRA?
DB is restored but not recovered.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: syntax hint
Author: Jan Schnackenberg, Germany
Date: Jun 29, 2020, 22:26, 38 days ago
Score:   Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts
Message: Hi Alain,

you tell your instance which Disk Group to use for FRA by setting the db_recovery_file_dest parameter in the SPFile.

This is not different from normal operation. So, if your restored instance should use a different Disk Group, just set this Parameter in the SPFile after restoring that.

Regards,
Jan

P.S.: When DUPLICATEing a database, you can set new values for instance parameters in the DUPLICATE command.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here