The following are the major steps I planned to follow in order to move a redo lo

Question

The following are the major steps I planned to follow in order to move a redo log member from C:APPSTUDENTORADATACSC544744REDO04.LOG to E:LOGSREDO04.LOG:

a) Connect to the database as the SYS user using the SYSDBA privilege

b) Execute:

shutdown immediate

c) Use operation system commands to move the redo log file from C:APPSTUDENTORADATACSC544744REDO04.LOG to E:LOGSREDO04.LOG

d) Execute:

startup nomount

e) Execute:

alter database rename file ‘C:APPSTUDENTORADATACSC544744REDO04.LOG’ to ‘C:LOGSREDO04.LOG’;

f) Execute:
alter database open;

When I tried the plan on my Oracle database, it did not work through.
Point out the step(s) that would fail. Make suggestions on how to fix the problem(s).

Explanation / Answer

Here in this your steps are perfectly right to move the redolog file except step d

startup nomount

Because you need to alter the filename in mount state. Not in the nomount state. Then only database will recognise and take this new path/file. Below are the steps to move the redolog file.

Follow these steps it will resolve your error.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.