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; |
Database Mode: NO ARCHIVE LOG | Database 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; |
Database Mode: ARCHIVE LOG | Database 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; |
Database Mode: NO ARCHIVE LOG | Database 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; |