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