No question at this time
DBA Top 10
1 M. Cadot 10400
2 A. Kavsek 7600
3 B. Vroman 4800
4 P. Wisse 4000
5 J. Schnackenberg 3200
6 J. PĂ©ran 2200
7 T. Boles 600
8 Z. Hudec 400
8 G. Lambregts 400
8 N. Havard 400
8 F. Pachot 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48534
Total active users1395
Act. users last 24h0
Act. users last hour0
Registered user hits last week82
Registered user hits last month353
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, 82 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, 82 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