v$log_history,
v$archived_log
V$RECOVERY_LOG - [
Lists only the archived redo logs that Oracle needs to perform media recovery. It also includes the probable names of the files, using LOG_ARCHIVE_FORMAT.
Note: This view is only populated when recovery is required for a datafile. Hence, this view is not useful in the case of a planned recovery such as a user error.
]
If sufficient space is not available at the location indicated by the archiving destination initialization parameter, restore some or all of the required archived redo log files to an alternate location. Specify the location before or during media recovery using the LOGSOURCE parameter of the SET statement in SQL*Plus or the RECOVER ... FROM parameter of the ALTER DATABASE statement in SQL. For example, enter:
SET LOGSOURCE /disk2/temp # set location using SET statement
DATABASE RECOVER FROM '/disk2/temp'; # set location in RECOVER statement itself
in rman
SET ARCHIVELOG DESTINATION TOcommand ARCHIVE LOG START '
for temporary change';
No comments:
Post a Comment