Database Datafiles Renaming/Relocating

Tablespace: SYSTEM

Case -I

Database mode: ARCHIVE LOG Database status: MOUNT Tablespace status: ONLINE Datafile status: OFFLINE
svrmgrl>ALTER DATABASE DATAFILE '/File_path/system02.dbf' OFFLINE;
svrmgrl>!cp /File_path/system02.dbf /New_file_path/system02.dbf
svrmgrl>ALTER DATABASE RENAME FILE '/File_path/system02.dbf' TO '/New_file_path/system02.dbf';
svrmgrl>ALTER DATABASE DATAFILE '/New_File_path/system02.dbf' ONLINE'

Case -II

Database mode: NO ARCHIVE LOG Database status: MOUNT Tablespace status: ONLINE Datafile status: OFFLINE
svrmgrl> shutdown normal
Set init parameters log_archive_start =TRUE, log_archive_format=%s_%T.ARC,log_archvie_dest=/File_path_dir/arch/
svrmgrl> startup mount
svrmgrl> ALTER DATABASE ARCHIVELOG;
svrmgrl>ALTER DATABASE DATAFILE '/File_path/system02.dbf' OFFLINE;
svrmgrl>!cp /File_path/system02.dbf /New_file_path/system02.dbf
svrmgrl>ALTER DATABASE RENAME FILE '/File_path/system02.dbf' TO '/New_file_path/system02.dbf';
svrmgrl>ALTER DATABASE DATAFILE '/New_File_path/system02.dbf' ONLINE'
svrmgrl> ALTER DATABASE NOARCHIVELOG;

Tablespace: DATA/INDEX/TEMP

Case -I

Database Mode: ARCHIVE LOGDatabase status: OPEN Tablespace status: ONLINE Datafile status: OFFLINE
svrmgrl>ALTER DATABASE DATAFILE '/File_path/data_02.dbf' OFFLINE;
svrmgrl>!cp /File_path/data_02.dbf /New_file_path/data_02.dbf
svrmgrl>ALTER DATABASE RENAME FILE '/File_path/data_02.dbf' TO '/New_file_path/data_02.dbf';
svrmgrl>RECOVER DATAFILE '/New_file_path/data_02.dbf';
svrmgrl>ALTER DATABASE DATAFILE '/New_File_path/data_02.dbf' ONLINE;

Case -II

Database Mode: NO ARCHIVE LOGDatabase status: OPEN Tablespace status: OFFLINE Datafile status: OFFLINE
svrmgrl>ALTER TABLESPACE DATA_TBS OFFLINE;
svrmgrl>ALTER DATABASE DATAFILE '/File_path/data_02.dbf' OFFLINE;
svrmgrl>!cp /File_path/data_02.dbf /New_file_path/data_02.dbf
svrmgrl>ALTER DATABASE RENAME FILE '/File_path/data_02.dbf' TO '/New_file_path/data_02.dbf';
svrmgrl>ALTER DATABASE DATAFILE '/New_File_path/data_02.dbf' ONLINE;
svrmgrl>ALTER TABLESPACE DATA_TBS ONLINE;

Tablespace: ROLLBACK

Case -I

Database Mode: ARCHIVE LOGDatabase status: OPEN Tablespace status: ONLINE Datafile status: OFFLINE
Rollback segment status : ONLINE
svrmgrl>ALTER DATABASE DATAFILE '/File_path/rollback01.dbf' OFFLINE;
svrmgrl>!cp /File_path/rollback01.dbf /New_file_path/rollback01.dbf
svrmgrl>ALTER DATABASE RENAME FILE '/File_path/rollback01' TO '/New_file_path/rollback01.dbf';
svrmgrl>RECOVER DATAFILE '/New_file_path/rollback.dbf';
svrmgrl>ALTER DATABASE DATAFILE '/New_File_path/rollback.dbf' ONLINE;

Case -II

Database Mode: NO ARCHIVE LOGDatabase status: OPEN Tablespace status: OFFLINE Datafile status: OFFLINE
All Rollback segment status : OFFLINE
svrmgrl>ALTER ROLLBACK SEGMENT RBS_01 OFFLINE;
svrmgrl>ALTER TABLESPACE ROLLBACK OFFLINE;
svrmgrl>ALTER DATABASE DATAFILE '/File_path/rollback01.dbf' OFFLINE;
svrmgrl>!cp /File_path/rollback01.dbf /New_file_path/rollback01.dbf;
svrmgrl>ALTER DATABASE RENAME FILE '/File_path/rollback01' TO '/New_file_path/data_02.dbf';
svrmgrl>ALTER DATABASE DATAFILE '/New_File_path/rollback01' ONLINE;
svrmgrl>ALTER TABLESPACE ROLLBACK ONLINE;
svrmgrl>ALTER ROLLBACK SEGMENT RBS_01 ONLINE;

REDO LOG FILES

Database Mode: ANY Database status: OPEN Redo Member status: INACTIVEFile status: No process hold
svrmgrl>!fuser /disk1/oradata/TDB8/redo02.log(Check for any process holding the file)
svrmgrl>ALTER SYSTEM SWITCH LOGFILE; (Make current status to inactive)
svrmgrl>!cp /disk1/oradata/TDB8/redo02.log /disk3/oradata/TDB8/redo02.log;
svrmgrl>ALTER DATABASE RENAME FILE '/disk1/oradata/TDB8/redo02.log' TO '/disk3/oradata/TDB8/redo02.log';