|
SWITCH Take the tablespace for the datafile offline, copy the file to the new location using the SET NEWNAME command, and make the new datafile active by using the SWITCH command. The RECOVER command will apply the redo logs, archived logs, and incremental and cumulative backups to the file. Issue the ALTER TABLESPACE command to bring the tablespace online. • Evaluate this command: ALTER DATABASE CLEAR LOGFILE GROUP 1 UNRECOVERABLE DATAFILE; Why would you issue this command? To clear a redo log file that is needed for recovery of an offline datafile THE ALTER DATABASE CLEAR UNARCHIVED LOGFILE command can be used when there are only two log groups or the corrupt redo log file is a member of the current group. This command will clear or recreate the files.
more
|
Which RMAN command updates the control file and recovery catalog when restoring a datafile after a media failure?
Related Questions
- SP uses some predefined DOC file names for import/export of certain data.
- Yes. All Graphs menu graphs can maintain automatic links to the data from which they were created as long as ...
- DBA_EXTENTS OWNER VARCHAR2(30) SEGMENT_NAME VARCHAR2(81) PARTITION_NAME VARCHAR2(30) SEGMENT_TYPE VARCHAR2(17) ...
- rman> CHANGE DATAFILECOPY 'finance2.dbf' UNCATALOG • Evaluate these commands issued in Recovery Manager: rman> ...
- Use an index scan to retrieve the data in the corrupt blocks.