No question at this time
DBA Top 10
1 M. Cadot 10800
2 B. Vroman 6500
3 A. Kavsek 5600
4 J. Schnackenberg 2600
5 P. Wisse 2200
5 J. Péran 2200
7 T. Boles 600
8 D. Dave 400
9 . Lauri 200
9 R. Rao Kulkarni 200
9 H. Bhangu 200
9 V. Gupta 200
9 A. Bourgeois 200
9 M. Jain 200
9 K. Pingeli 200
9 J. Baet 200
9 B. Jacobs 200
9 R. Pastre 200
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48605
Total active users1406
Act. users last 24h5
Act. users last hour0
Registered user hits last week164
Registered user hits last month694
Go up

Restore
Next thread: Scheduled jobs
Prev thread: Health Check script from Oracle : I got the solution for some errors and warnings

Message Score Author Date
Hi Everyone, I have server1 => Container1= pdb1/...... Bob B Feb 23, 2021, 01:54
Hi, what's wrong with complete recovery of pdb2...... Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts Ales Kavsek Feb 23, 2021, 12:45
Hi, In this test case, the restore is from a parti...... Bob B Feb 23, 2021, 16:58
Hi, are you talking about point in time recover...... Ales Kavsek Feb 23, 2021, 18:41
Hi, Yes restore of one particular pdb from a bac...... Bob B Feb 24, 2021, 16:23
Hello Bob, what about    run { set until sequ...... Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts Bruno Vroman Feb 24, 2021, 18:41
Hello Bruno, Restores and Recovers in Single Te...... Bob B Feb 26, 2021, 00:52
Hi, you can do two types of pdb2 recovery. Comp...... Score: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 Pts Ales Kavsek Feb 26, 2021, 20:06
Hi Ales, Thanks for confirming that!! Regards, ...... Bob B Feb 26, 2021, 22:42

Follow up by mail Click here


Subject: Restore
Author: Bob B, United States
Date: Feb 23, 2021, 01:54, 78 days ago
Os info: RHEL 7
Oracle info: 19
Message: Hi Everyone,
I have server1 => Container1= pdb1/pdb2/pdb3.
I will have to perform multiple restores to pdb2, after each test case, the restore will be from a base backup( full backup of container 1).
The restore of a single pluggable can be done with rman auxiliary and unplug and plug the pdb to cdb1.

Is there any better way to restore a single pdb?
Any help is appreciated.

Regards,
BOB
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Restore
Author: Ales Kavsek, Slovenia
Date: Feb 23, 2021, 12:45, 77 days ago
Score:   Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts
Message: Hi,

what's wrong with complete recovery of pdb2 from root container?

$ rman target=/
RUN {
ALTER PLUGGABLE DATABASE pdb2 CLOSE;
RESTORE PLUGGABLE DATABASE pdb2;
RECOVER PLUGGABLE DATABASE pdb2;
ALTER PLUGGABLE DATABASE pdb2 OPEN;
}


Regards,
Ales
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Restore
Author: Bob B, United States
Date: Feb 23, 2021, 16:58, 77 days ago
Message: Hi, In this test case, the restore is from a particular backup set. Restore from root will happen using the latest backups.

Regards,
BOB
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Restore
Author: Ales Kavsek, Slovenia
Date: Feb 23, 2021, 18:41, 77 days ago
Message: Hi,

are you talking about point in time recovery of one particular pluggable database? (pdb2)

Regards,
Ales
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Restore
Author: Bob B, United States
Date: Feb 24, 2021, 16:23, 76 days ago
Message: Hi,
Yes restore of one particular pdb from a backupset.
I am testing to restore 1 pdb using a full backup.

Regards,
Bob

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Restore
Author: Bruno Vroman, Belgium
Date: Feb 24, 2021, 18:41, 76 days ago
Score:   Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts
Message: Hello Bob,

what about
   run { set until sequence = NNNN; … }
(beware: with NNNN : the first sequence number that you don't want) ((or until scn or until time))

Best regards,

Bruno Vroman.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Restore
Author: Bob B, United States
Date: Feb 26, 2021, 00:52, 75 days ago
Message: Hello Bruno,

Restores and Recovers in Single Tenant:
rman target /
catalog start with '<loc>' NOPROMPT;
restore database;
recover database;
exit;

For understanding, in multitenant, to restore a single pluggable(pdb2), will have to be done using until scn/time.
correct?

Regards,
BOB
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Restore
Author: Ales Kavsek, Slovenia
Date: Feb 26, 2021, 20:06, 74 days ago
Score:   Score: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 Pts
Message: Hi,

you can do two types of pdb2 recovery. Complete recovery (shown in my example above) and point in time recovery. If you want to recovery point in time PDB2...
today it's Friday 26th of February 2021, you wish to restore PDB2 to the state of Monday 22th of February 2021, 17:00.

$ rman target=/
RUN {
ALTER PLUGGABLE DATABASE pdb2 CLOSE;
SET UNTIL TIME "TO_DATE('22-FEB-2021 17:00:00','DD-MON-YYYY HH24:MI:SS')";
RESTORE PLUGGABLE DATABASE pdb2;
RECOVER PLUGGABLE DATABASE pdb2;
ALTER PLUGGABLE DATABASE pdb2 OPEN RESETLOGS;
ALTER PLUGGABLE DATABASE pdb2 OPEN;
}


Of course, behind a scene much more is going on if you're doing PDB point in time recovery instead of complete recovery, because Oracle must restore and recover SYSTEM, UNDO and SYSAUX in auxiliary database to that point of time as well.
Don't worry about RESETLOGS statement, Oracle will create new PRD2 incarnation and will not really do anything to the REDOLOGS that are shared with all PDBs.

Reference:
https://docs.oracle.com/database/121/BRADV/rcmflash.htm#GUID-031D9695-A9D2-4381-A840-39BD3CC19946

Regards,
Ales
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Restore
Author: Bob B, United States
Date: Feb 26, 2021, 22:42, 74 days ago
Message: Hi Ales, Thanks for confirming that!!

Regards,
Bob



Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here