| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Applying redo - recovery fundamentals
Is your 'until time' before you dropped the table? Just a thought. It has
to be set to a time when the table existed for it to be recreated from redo
or archivelogs.
HTH,
Ruth
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of orcl
Sent: Sunday, November 27, 2005 9:56 AM
To: oracle-l
Subject: Applying redo - recovery fundamentals
All, Im having big trouble in a recovery scenario, here is what I have
1, A small shell of a database with all datafiles copied to a backup
location (cold backup)
2. Database is in archivelog mode
3. startup up the database and create a table with 6K records. I can
see all the redo getting generated wait a few min and drop the table .
redo logs are 5mb
4. Shutdown the database, delete all datafiles and copy over all
database files (from step 1) including redo logs
5. Startup mount and issue recover database until cancel
6. I *dont * get prompted for cancel and in 2 seconds i get "media
recovery complete" and my table *is not* restored
Basically the same problem if I use recover database until time '2005-11-27:09:25:00';
What the heck am I doing wrong?
> archive log list
Database log mode Archive Mode Automatic archival Enabled Archive destination J:\ARCHIVE_DEST\ORCL Oldest online log sequence 0 Next log sequence to archive 1 Current log sequence 1
Table dropped.
Table created.
PL/SQL procedure successfully completed.
Commit complete.
COUNT(*)
60000
> archive log list;
Database log mode Archive Mode Automatic archival Enabled Archive destination J:\ARCHIVE_DEST\ORCL Oldest online log sequence 25 Next log sequence to archive 27 Current log sequence 27
>drop table test_reco
Table dropped
> shutdown immediate; <-- then copy over files from cold backup
C:\>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Nov 26 08:56:28 2005
> conn sys/***@orcl as sysdba;
Connected to an idle instance.
> startup mount
ORACLE instance started.
Total System Global Area 289406976 bytes
Fixed Size 1248576 bytes Variable Size 83886784 bytes Database Buffers 197132288 bytes Redo Buffers 7139328 bytesDatabase mounted.
> archive log list;
Database log mode Archive Mode Automatic archival Enabled Archive destination J:\ARCHIVE_DEST\ORCL Oldest online log sequence 0 Next log sequence to archive 1 Current log sequence 1
> recover database until cancel; <--- I dont get prompted here at all
and I have aprox 30 *new* redologs of 5mb each
Media recovery complete.
!! This comes back in 2 seconds without my dropped table
> show parameter archive
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ archive_lag_target integer 0 log_archive_config string log_archive_dest string log_archive_dest_1 string LOCATION=J:\ARCHIVE_DEST\ORCL log_archive_duplex_dest string log_archive_format string ORCL_%t_%s_%r.arc log_archive_local_first boolean TRUE log_archive_max_processes integer 2 log_archive_min_succeed_dest integer 1 log_archive_start boolean FALSE log_archive_trace integer 0 remote_archive_enable string true standby_archive_dest string %ORACLE_HOME%\RDBMS
>
--- -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 28 2005 - 10:51:22 CST
 |
 |