Database Backup and Recovery (MOSC)

MOSC Banner

Rman restore database with skip tablespace then switch datafile all fails RMAN-03002

edited Sep 8, 2020 5:06AM in Database Backup and Recovery (MOSC) 7 commentsAnswered ✓

Hi Here is my RMAN script which is restoring a database to a new location but skipping the  tablespace documents (it had worked when restoring the full database), when it comes to the swich datafile all it falls over with the

failure of the switch datafile all command, any ideas how this can be resolved? Many thanks.

RMAN> connect target *

2> run {

3> set newname for database to "/oracle/data/wsuss/%U";

4> set newname for block change tracking file to "/oracle/data/wsuss/block_change_tracking.bct";

6> sql "alter database disable block change tracking";

7> sql "alter database rename file ''/oracle/mosprd/oradata/mosprd/redo01.log'' to ''/oracle/data/wsuss/redo01a.log''";

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center