After recovery terminates, open the database for use by issuing the following command at the SQL*Plus prompt:
With the User Managed backup method, Plug‑in for Oracle lets you rename the Control File, Datafiles, and Archive Log Directory or Individual Archived Log files during restore. Renaming files can be useful if you do not want to overwrite the existing version and want to create a copy of the file. You can also relocate the files to a different directory while restoring it with the plug-in.
2 |
In the Navigation pane, click Create Restore Job, select Plug‑in for Oracle from the Plugin Type list. |
4 |
On the Create Selection Set page, select the item that you want to rename or relocate. |
5 |
6 |
• |
Rename: Enter the new name. |
• |
Relocate: Enter the new path. |
a |
b |
IMPORTANT: When renaming individual archive log files during a restore job, perform media recovery with SET AUTORECOVERY OFF, and enter the archive log filenames manually to indicate the revised filenames. |
When renaming an Archive Log Directory, all Archived Logs are restored to the directory specified.
2 |
In the Navigation pane, click Create Restore Job, select Plug‑in for Oracle from the Plugin Type list. |
4 |
On the Create Selection Set page, select the Archive Log Directory that you want to rename or relocate. |
5 |
6 |
• |
Rename: Enter the new name. |
• |
Relocate: Enter the new path. |
a |
b |
IMPORTANT: When restoring some or all of the required archived redo log files to an alternate location, specify the location before media recovery by using the LOGSOURCE parameter of the SET statement in SQL*Plus. |
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center