![]() To check whether a data file is part of a current online tablespace backup, query the V$BACKUP view. Because the current database structure may not match the database structure at the time a given control file backup was created, saving a list of files recorded in the backup control file can aid the recovery procedure.ĭetermining Data File Status for Online Tablespace Backups If you plan to perform control file backup with the ALTER DATABASE BACKUP CONTROLFILE TO ' filename ' statement, then save a list of all data files and online redo log files with the control file backup. You must back up only one copy of a multiplexed control file. Obtain the file names of the current control files by querying the V$CONTROLFILE view. ![]() SELECT t.NAME "Tablespace", f.NAME "Datafile" You can also join the V$TABLESPACE and V$DATAFILE views to obtain a listing of data files along with their associated tablespaces: Start SQL*Plus and query V$DATAFILE to obtain a list of data files.
0 Comments
Leave a Reply. |