ALTER DATABASE DATAFILE '/u01/oracle/rbdb1/users01.dbf' ONLINE;
To take the same file offline, issue the following statement:ALTER DATABASE DATAFILE '/u01/oracle/rbdb1/users01.dbf' OFFLINE;
Tuesday, June 7, 2011
Bringing Datafiles Online or Taking Offline in ARCHIVELOG Mode
The following statement brings the specified datafile online:
ALTER DATABASE DATAFILE '/u01/oracle/rbdb1/users01.dbf' ONLINE;
ALTER DATABASE DATAFILE '/u01/oracle/rbdb1/users01.dbf' OFFLINE;
ALTER DATABASE DATAFILE '/u01/oracle/rbdb1/users01.dbf' ONLINE;
ALTER DATABASE DATAFILE '/u01/oracle/rbdb1/users01.dbf' OFFLINE;
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment