Parm Patram

Moving datafiles/logfiles to another disk/location

Database Recovery 08-31-2008

$ sqlplus "/ as sysdba"

SQL> shutdown immediate

SQL> !mv orig_file target_file
...
SQL> startup mount

SQL> alter database rename file 'orig_file' to 'target_file';
...

    Do not disconnect after this step. Stay logged in
    and proceed to open the database!

SQL> alter database open;

SQL> exit

Posted by admin @ 8:07 am

Comments are closed.

Administration
- ASM
- BLOCK SIZE
- Database Recovery
- DBVERIFY
- GRANTS
- OEM
- REDO LOGS
APPS
- AutoConfig
- Change EBS IP Address
- Cloning
- DB Environment Vars
- Discoverer
- Environment Vars
- Patching
- Problems
- Resources Online
- Tricks & Tips
- Upgrading
- Workflow
Articles
Backup & Recovery
Certification
Configuration
DATABASE STRUCTURE
- Data Dictionary
- Logical Database Structure
- Physical Database Structure
- SCHEMA
DATAGUARD
Documentation
- ASM (Automatic Storage Magement)
- Command Reference
- DataPump
- Documentation Library
- SQL Developer
EBS
Enterprise Manager
FLASHBACK
HACKING
HEADS UP
Installation
- RAC
JDeveloper
Linux
- iptables
NXclient/server
Online Resources
PERL
PERSONAL
- RECIPES
python
RMAN
- RMAN Catalog Setup
Scripts
Serial-Parallel-Port-Testers
SNMP
Software
Solaris
Spiritual
SQL & PL/SQL
SQLPLUS
Startup/Shutdown
Streams
Tuning
- INDEXES
- SQL Tuning
  - TKPROF and sql_trace
Version Control
VNC
VPN
Windows XP

Moving datafiles/logfiles to another disk/location

Category: