-
Tablespace Offline
Hello All,
I have a small problem.In my database,i have made a tablespace offline with alter tablespace userdata offline immediate command.When i try to make it online, i am getting error that related file require recovery.how i can this tablespace online.
Thanks.
-
If you take a tablespace offline with the immediate clause the associated datafiles are not checkpointed. Therefore as the error implies you will need to perform a media recovery (using recover datafile ...) on the datafile before bringing online.
regards
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
Here it is
Code:
SQL> insert into scott.delme values ('delete me');
1 Zeile verarbeitet.
SQL> insert into scott.delme values ('delete me');
1 Zeile verarbeitet.
SQL> insert into scott.delme values ('delete me');
1 Zeile verarbeitet.
SQL> insert into scott.delme select * from scott.delme;
8 Zeilen verarbeitet
SQL> select tablespace_name from all_tables where table_name = 'DELME';
TABLESPACE_NAME
------------------------------
USERS
1 Zeile ausgewShlt.
SQL> alter tablespace users offline immediate;
Anweisung verarbeitet
SQL> alter tablespace users online;
alter tablespace users online
*
ORA-01113: Fnr Datei '3' ist DatentrSger-Recovery notwendig
ORA-01110: Datendatei 3: 'D:\ORACLE\ORADATA\ORCL\USERS.DBF'
SQL>
SQL>
SQL> alter database recover tablespace users;
Anweisung verarbeitet
SQL> alter tablespace users online;
Anweisung verarbeitet
SQL>
HTH
-
Tablespace offline
Thanks Sameer,for ur reply.I have got this error
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-00281: media recovery may not be performed using dispatcher
when i try to perform
alter database recover tablespace userdata;
what should i do know.
-
Hi
In order to these kind of activites you need a dedicated session.I c that you are connecting using MTS..
ORA-00281: media recovery may not be performed using dispatcher
get a dedicated connection..
regards
Hrishy
-
Thanks for such a prompt replies to all of you.but i am running my server in dedicated mode.it is not in shared server mode.so,what can be the cause that it showing this type of error of dispatcher.Yes i am having two databases on my machines and there are two instances running.it can be the reason.
Thanks and Regards,
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|