Home » RDBMS Server » Backup & Recovery » datafile offline drop
datafile offline drop [message #290962] Wed, 02 January 2008 06:12 Go to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
what does this command do besides marking it offline?
SQL>alter database datafile '.../df1.dbf' offline drop.

But datafile cannot be deleted prior to 10g

[Updated on: Wed, 02 January 2008 06:16]

Report message to a moderator

Re: datafile offline drop [message #290967 is a reply to message #290962] Wed, 02 January 2008 06:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It does nothing more than taking offline the file.
DROP option is mandatory in NOARCHIVELOG mode and is ignored in ARCHIVELOG mode.

Regards
Michel
Re: datafile offline drop [message #291627 is a reply to message #290962] Sat, 05 January 2008 09:33 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

>alter database datafile '.../df1.dbf' offline drop.
above statement taking datafile offline but marked as DROP we will can't reuse once file marked as "DROP".

Re: datafile offline drop [message #291632 is a reply to message #291627] Sat, 05 January 2008 09:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Where is it marked as DROP?

Regards
Michel
Re: datafile offline drop [message #291636 is a reply to message #291632] Sat, 05 January 2008 10:15 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Michal,
I was wrong. but actually i want to say once we take datafile with "offline drop" then we can't back datafile online.

Re: datafile offline drop [message #291643 is a reply to message #290962] Sat, 05 January 2008 11:01 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
>want to say once we take datafile with "offline drop" then we can't back datafile online.
Why can't we?
Re: datafile offline drop [message #291684 is a reply to message #290962] Sat, 05 January 2008 23:27 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:

once we take datafile with "offline drop" then we can't back datafile online.


I think it is not right.
Re: datafile offline drop [message #291685 is a reply to message #290962] Sat, 05 January 2008 23:34 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I mean,
SQL> select log_mode from v$database;

LOG_MODE
------------
NOARCHIVELOG

SQL> alter database datafile 6 offline drop;

Database altered.

SQL> recover datafile 6;
Media recovery complete.
SQL> alter database datafile 6 online;

Database altered.
Re: datafile offline drop [message #291693 is a reply to message #291685] Sun, 06 January 2008 00:37 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can do it until the offline SCN goes out of the online redo logs.
So how long depends on your logs size and workload.

Regards
Michel
Previous Topic: What do you do with NOARCHIVE DB?
Next Topic: How to backup flash recovery area (asm diskgroup) to tape?
Goto Forum:
  


Current Time: Sun Dec 04 14:48:40 CST 2016

Total time taken to generate the page: 0.04632 seconds