Home » RDBMS Server » Backup & Recovery » why should i offline the tablespace?
why should i offline the tablespace? [message #538678] Sun, 08 January 2012 21:49 Go to next message
lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China
Member
Hi ,all:
when i restore the tablespace ,why should i offline the tablespace first?if i restore the tablespace without offlining,what will happen?
Re: why should i offline the tablespace? [message #538679 is a reply to message #538678] Sun, 08 January 2012 21:56 Go to previous messageGo to next message
BlackSwan
Messages: 26201
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

>when i restore the tablespace ,why should i offline the tablespace first?
>if i restore the tablespace without offlining,what will happen?

Restore what from what & why is restore needed to be done?

post SQL that "offline the tablespace"

Re: why should i offline the tablespace? [message #538694 is a reply to message #538678] Mon, 09 January 2012 01:32 Go to previous message
Michel Cadot
Messages: 65848
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
why should i offline the tablespace first?


This is juts a prerequisite Oracle asks, no need to think about it:
Database Backup and Recovery Reference
RESTORE page
Restrictions and Usage Notes section:

Quote:
To restore datafiles to their current location, the database must be started, mounted, or open with the tablespaces or datafiles to be restored offline.


Quote:
if i restore the tablespace without offlining,what will happen?

Just try it!

Regards
Michel

Previous Topic: how many times to backup controlfile?
Next Topic: restore issue about asm to no-asm
Goto Forum:
  


Current Time: Sat Oct 20 01:12:50 CDT 2018