RE: Applying redo - recovery fundamentals
- From: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
- To: <orcl@xxxxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 28 Nov 2005 11:48:53 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]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
> @generatedata
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 bytes
Database 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
>
---
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
