OraFAQ Forum: Backup & Recovery » datafile offline drop

Home » RDBMS Server » Backup & Recovery » datafile offline drop

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

datafile offline drop [message #290962]

Wed, 02 January 2008 06:12

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

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: datafile offline drop [message #291627 is a reply to message #290962]

Sat, 05 January 2008 09:33

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".

Report message to a moderator

Re: datafile offline drop [message #291632 is a reply to message #291627]

Sat, 05 January 2008 09:57

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Where is it marked as DROP?

Regards
Michel

Report message to a moderator

Re: datafile offline drop [message #291636 is a reply to message #291632]

Sat, 05 January 2008 10:15

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.

Report message to a moderator

Re: datafile offline drop [message #291643 is a reply to message #290962]

Sat, 05 January 2008 11:01

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?

Report message to a moderator

Re: datafile offline drop [message #291684 is a reply to message #290962]

Sat, 05 January 2008 23:27

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.

Report message to a moderator

Re: datafile offline drop [message #291685 is a reply to message #290962]

Sat, 05 January 2008 23:34

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.

Report message to a moderator

Re: datafile offline drop [message #291693 is a reply to message #291685]

Sun, 06 January 2008 00:37

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Aug 19 12:57:55 CDT 2025