out a given restore operation, based on the information in the RMAN repository.
These commands are brilliant for planning restore and recovery operations, for example
RESTORE DATABASE PREVIEW;
RESTORE TABLESPACE users PREVIEW;
RESTORE DATAFILE 3 PREVIEW;
RESTORE ARCHIVELOG FROM LOGSEQ 200 PREVIEW;
RESTORE ARCHIVELOG FROM TIME 'SYSDATE-7' PREVIEW;
RESTORE ARCHIVELOG FROM SCN 234546 PREVIEW;
RESTORE DATABASE UNTIL TIME "TO_DATE('18.11.2014 18:00:00','DD.MM.YYYY HH24:MI:SS')" PREVIEW;
Use the RESTORE... PREVIEW SUMMARY option to suppress much of the detail about specific files used and
affected by the restore process:
RESTORE DATABASE PREVIEW SUMMARY;
RESTORE DATABASE UNTIL TIME "TO_DATE('31-08-2010 18:00:00', 'DD-MM-YYYY HH24:MI:SS')" PREVIEW;
RESTORE DATABASE UNTIL TIME 'sysdate-3' PREVIEW SUMMARY;
RESTORE DATABASE UNTIL TIME 'sysdate-1/24' preview summary; -->; one hour ago
RESTORE TABLESPACE users PREVIEW SUMMARY;
RESTORE DATAFILE 3 PREVIEW SUMMARY;
RESTORE ARCHIVELOG FROM SCN 234546 PREVIEW SUMMARY;
-- For pluggable databases, add the keyword "pluggable" to the very same statement
RESTORE PLUGGABLE DATABASE PDB2 until time "TO_DATE('31-08-2010 18:00:00', 'DD-MM-YYYY HH24:MI:SS')" PREVIEW;
To avoid the following error stack:
Starting restore at 02.12.2014 16:51:24 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=15 device type=DISK RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 12/02/2014 16:51:25 RMAN-06026: some targets not found - aborting restore RMAN-06100: no channel to restore a backup or copy of datafile n
you need to allocate the appropriate channels for maintenance first, such as
allocate channel for maintenance type 'sbt_tape';
Output example from a preview started 06.05.2015 14:18:12, checking to see what would be needed if I took the database back approximately 1,5 hours:
RMAN> restore database until time "TO_DATE('06.05.2015 12:52:00','DD.MM.YYYY HH24:MI:SS')" preview summary;
Starting restore at 06.05.2015 14:18:12
using channel ORA_SBT_TAPE_1
using channel ORA_DISK_1
using channel ORA_DISK_2
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- ------------------- ------- ------- ---------- ---
373688959 B 0 A SBT_TAPE 30.04.2015 17:42:55 1 1 NO 20150430173000.SOLP2
373688963 B 0 A SBT_TAPE 30.04.2015 17:43:06 1 1 NO 20150430173000.SOLP2
373688965 B 0 A SBT_TAPE 30.04.2015 17:43:21 1 1 NO 20150430173000.SOLP2
373688962 B 0 A SBT_TAPE 30.04.2015 17:43:03 1 1 NO 20150430173000.SOLP2
373688958 B 0 A SBT_TAPE 30.04.2015 17:42:26 1 1 NO 20150430173000.SOLP2
373688961 B 0 A SBT_TAPE 30.04.2015 17:43:02 1 1 NO 20150430173000.SOLP2
373688956 B 0 A SBT_TAPE 30.04.2015 17:42:22 1 1 NO 20150430173000.SOLP2
373688957 B 0 A SBT_TAPE 30.04.2015 17:42:24 1 1 NO 20150430173000.SOLP2
373688960 B 0 A SBT_TAPE 30.04.2015 17:42:58 1 1 NO 20150430173000.SOLP2
373927006 B 0 A SBT_TAPE 06.05.2015 12:49:58 1 1 NO 20150506123352.SOLP2
373688966 B 0 A SBT_TAPE 30.04.2015 17:45:12 1 1 NO 20150430173000.SOLP2
373688964 B 0 A SBT_TAPE 30.04.2015 17:43:12 1 1 NO 20150430173000.SOLP2
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- ------------------- ------- ------- ---------- ---
373689024 B A A SBT_TAPE 30.04.2015 17:45:28 1 1 NO TAG20150430T174527
373701547 B A A SBT_TAPE 30.04.2015 21:40:29 1 1 NO TAG20150430T214020
373708776 B A A SBT_TAPE 30.04.2015 23:40:24 1 1 NO TAG20150430T234018
373715185 B A A SBT_TAPE 01.05.2015 03:40:28 1 1 NO TAG20150501T034020
373718630 B A A SBT_TAPE 01.05.2015 06:40:49 1 1 NO TAG20150501T064020
373747390 B A A SBT_TAPE 01.05.2015 23:40:33 1 1 NO TAG20150501T234022
373755172 B A A SBT_TAPE 02.05.2015 03:40:31 1 1 NO TAG20150502T034022
373758977 B A A SBT_TAPE 02.05.2015 06:40:41 1 1 NO TAG20150502T064016
373763033 B A A SBT_TAPE 02.05.2015 09:40:27 1 1 NO TAG20150502T094020
373772933 B A A SBT_TAPE 02.05.2015 12:40:20 1 1 NO TAG20150502T124018
373775169 B A A SBT_TAPE 02.05.2015 14:40:17 1 1 NO TAG20150502T144016
373818387 B A A SBT_TAPE 04.05.2015 01:01:30 1 1 NO TAG20150502T164016
373826167 B A A SBT_TAPE 04.05.2015 03:41:13 1 1 NO TAG20150504T034021
373826168 B A A SBT_TAPE 04.05.2015 03:41:33 1 1 NO TAG20150504T034021
373830219 B A A SBT_TAPE 04.05.2015 06:41:12 1 1 NO TAG20150504T064022
373835638 B A A SBT_TAPE 04.05.2015 09:40:22 1 1 NO TAG20150504T094018
373847467 B A A SBT_TAPE 04.05.2015 12:40:35 1 1 NO TAG20150504T124024
373889376 B A A SBT_TAPE 05.05.2015 14:40:43 1 1 NO TAG20150505T144022
373889377 B A A SBT_TAPE 05.05.2015 14:40:58 1 1 NO TAG20150505T144022
373889378 B A A SBT_TAPE 05.05.2015 14:41:26 1 1 NO TAG20150505T144022
373889379 B A A SBT_TAPE 05.05.2015 14:42:03 1 1 NO TAG20150505T144022
373889380 B A A SBT_TAPE 05.05.2015 14:42:20 1 1 NO TAG20150505T144022
373889381 B A A SBT_TAPE 05.05.2015 14:42:37 1 1 NO TAG20150505T144022
373924623 B A A SBT_TAPE 06.05.2015 12:32:13 1 1 NO TAG20150506T123133
373924624 B A A SBT_TAPE 06.05.2015 12:32:45 1 1 NO TAG20150506T123133
373924625 B A A SBT_TAPE 06.05.2015 12:33:02 1 1 NO TAG20150506T123133
373927099 B A A SBT_TAPE 06.05.2015 13:01:48 1 1 NO TAG20150506T130147
373927100 B A A SBT_TAPE 06.05.2015 13:01:49 1 1 NO TAG20150506T130147
validation succeeded for backup piece
Media recovery start SCN is 169070460360
Recovery must be done beyond SCN 169092024179 to clear datafile fuzziness
validation succeeded for backup piece
Finished restore at 06.05.2015 14:18:16
No comments:
Post a Comment