-
Hello There,
can somebody pl. help me to sort the problem of recovery.
Database was set up by earlier DBA working here, and i dont have much cuel about the same.
Details of Database on Window NT
Oracle8i Release 8.1.5.0.0 - Production
PL/SQL Release 8.1.5.0.0 - Production
CORE Version 8.1.5.0.0 - Production
TNS for 32-bit Windows: Version 8.1.5.0.0 - Production
NLSRTL Version 3.4.0.0.0 - Production
Have database backup in Archieve mode on
log_archive_dest e:\oracle\ora81\database\archive\bed1
log_archive_dest_1
log_archive_dest_2
log_archive_dest_3
log_archive_dest_4
log_archive_dest_5
log_archive_dest_state_1 enable
log_archive_dest_state_2 enable
log_archive_dest_state_3 enable
log_archive_dest_state_4 enable
log_archive_dest_state_5 enable
log_archive_duplex_dest
log_archive_format ARC%S.%T
log_archive_max_processes 5
log_archive_min_succeed_dest 1
log_archive_start TRUE
standby_archive_dest %ORACLE_HOME%\RDBMS
And Following is details related to datafile of Temp tablespace
THis datafile has grown over the days nobody know why and since when?
STATUS ENABLED
RECOVER READ WRITE
And as this datafile need to be recovered, and is not online
we cant make any modification and if we try to compile anything in production it fails.
Can somebody help me and tell me what do i need to do for getting this data file online, i know i need to use Recovery manager but can someone take me thru the steps to do the same
Hoping that somebody will reply .
Thanks
-
you can change you users to use another tablespace for there temporary segments.
This does not resolve you problem, but your users can work again.
alter user <ausername> temporary tablespace <anotherTS>;
Gert
-
temporary tablespace shouldnt be tricky, create another temporary tablespace and alter all users to use that new temporary tablespace, then you can drop the faulty temporary tablespace
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
|