|
SET NEWNAME指导restore:
- run{
- set newname for datafile 5 to '/home/oracle/examplettio.dbf';
- restore datafile 5;
- delete datafilecopy '/home/oracle/examplettio.dbf';
- }
复制代码- RMAN> report schema;
- using target database control file instead of recovery catalog
- Report of database schema for database with db_unique_name ORCL
- List of Permanent Datafiles
- ===========================
- File Size(MB) Tablespace RB segs Datafile Name
- ---- -------- -------------------- ------- ------------------------
- 1 690 SYSTEM *** +DATA/orcl/datafile/system.267.972323303
- 2 560 SYSAUX *** +DATA/orcl/datafile/sysaux.259.972323303
- 3 100 UNDOTBS1 *** +DATA/orcl/datafile/undotbs1.273.972323303
- 4 5 USERS *** +DATA/orcl/datafile/users.262.972323303
- 5 100 EXAMPLE *** +DATA/orcl/datafile/example.265.972323303
- 6 0 TBSOCP05_TEST *** +DATA/orcl/datafile/tbsocp05_test.257.974234897
- List of Temporary Files
- =======================
- File Size(MB) Tablespace Maxsize(MB) Tempfile Name
- ---- -------- -------------------- ----------- --------------------
- 1 50 TEMP 32767 +DATA/orcl/datafile/temp01.dbf
- RMAN> list backup of tablespace TBSOCP05_TEST;
- specification does not match any backup in the repository
- RMAN> exit
- Recovery Manager complete.
- [oracle@station11 ~]$ sqlplus /nolog
- SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 23 20:54:40 2018
- Copyright (c) 1982, 2009, Oracle. All rights reserved.
- SQL> conn / as sysdba
- Connected.
- SQL> alter database create datafile 6 ;
- Database altered.
- SQL> recover datafile 6 ;
- ORA-00283: recovery session canceled due to errors
- ORA-01110: data file 6: '+DATA/orcl/datafile/tbsocp05_test.257.974234897'
- ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
- ORA-01110: data file 6: '+DATA/orcl/datafile/tbsocp05_test.257.974234897'
- SQL> alter database create datafile 6 as new;
- Database altered.
- SQL> recover datafile 6 ;
- ORA-00279: change 2328927 generated at 04/23/2018 20:48:16 needed for thread 1
- ORA-00289: suggestion : /u01/app/oracle/oradata/archivelog/1_38_972323822.dbf
- ORA-00280: change 2328927 for thread 1 is in sequence #38
- Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
- auot
- ORA-00308: cannot open archived log 'auot'
- ORA-27037: unable to obtain file status
- Linux-x86_64 Error: 2: No such file or directory
- Additional information: 3
- Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
- auto
- ORA-00279: change 2329205 generated at 04/23/2018 20:48:17 needed for thread 1
- ORA-00289: suggestion : /u01/app/oracle/oradata/archivelog/1_39_972323822.dbf
- ORA-00280: change 2329205 for thread 1 is in sequence #39
- ORA-00279: change 2329224 generated at 04/23/2018 20:48:18 needed for thread 1
- ORA-00289: suggestion : /u01/app/oracle/oradata/archivelog/1_40_972323822.dbf
- ORA-00280: change 2329224 for thread 1 is in sequence #40
- ORA-00279: change 2329229 generated at 04/23/2018 20:48:22 needed for thread 1
- ORA-00289: suggestion : /u01/app/oracle/oradata/archivelog/1_41_972323822.dbf
- ORA-00280: change 2329229 for thread 1 is in sequence #41
- Log applied.
- Media recovery complete.
- SQL>
复制代码
|
|