1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
| RMAN> shutdown immediate;
database closed
RMAN> startup mount;
RMAN> RUN
{
SET UNTIL SCN 3040951;
RESTORE DATABASE;
RECOVER DATABASE;
}
executing command: SET until clause
Starting restore at 25-AUG-17
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=254 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00009 to /u01/app/oracle/oradata/orcl12c/orcl/system01.dbf
channel ORA_DISK_1: restoring datafile 00010 to /u01/app/oracle/oradata/orcl12c/orcl/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00011 to /u01/app/oracle/oradata/orcl12c/orcl/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00012 to /u01/app/oracle/oradata/orcl12c/orcl/users01.dbf
channel ORA_DISK_1: restoring datafile 00014 to /u01/app/oracle/oradata/orcl12c/orcl/APEX_1993195660370985.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/orcl12c/ORCL12C/49BFF8A6BB912582E0530100007F8BE4/backupset/2017_08_22/o1_mf_nnndf_TAG20170822T093715_dsrdwdr4_.bkp
channel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/orcl12c/ORCL12C/49BFF8A6BB912582E0530100007F8BE4/backupset/2017_08_22/o1_mf_nnndf_TAG20170822T093715_dsrdwdr4_.bkp tag=TAG20170822T093715
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:06
Finished restore at 25-AUG-17
Starting recover at 25-AUG-17
using channel ORA_DISK_1
applied offline range to datafile 00009
offline range RECID=101 STAMP=952695955
applied offline range to datafile 00010
offline range RECID=100 STAMP=952695955
applied offline range to datafile 00011
offline range RECID=99 STAMP=952695955
applied offline range to datafile 00012
offline range RECID=98 STAMP=952695955
applied offline range to datafile 00014
offline range RECID=97 STAMP=952695955
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 08/25/2017 10:31:01
RMAN-07536: command not allowed when connected to a Pluggable Database |
Partager