No question at this time
The DBA-Village forum
as RSS feed
Site StatisticsEver registered users | 48581 | Total active users | 1393 | Act. users last 24h | 5 | Act. users last hour | 0 | Registered user hits last week | 165 | Registered user hits last month | 388 |
|
Go up
Restore
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...... |
     |
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...... |
     |
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...... |
     |
Ales Kavsek |
Feb 26, 2021, 20:06 |
Hi Ales, Thanks for confirming that!!
Regards,
...... |
|
Bob B |
Feb 26, 2021, 22:42 |
Subject: |
Restore |
Author: |
Bob B, United States |
Date: |
Feb 23, 2021, 01:54, 6 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, 6 days ago |
Score: |
       |
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, 6 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, 6 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, 5 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, 5 days ago |
Score: |
       |
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, 3 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, 2 days ago |
Score: |
       |
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, 2 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
|