| 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: Recovery until point in time...
You don't really need to open as resetlog as long as you have all archive
logs that had been generated since the last cold backup and all the online
redo log. You can open the database as normal after recovery (without
resetting logs)
Just make sure that you ONLY restore the datafile, but not controlfile or any other files from the cold backup.
Winnie
"Allen R. Lucas" <alucas_at_chicagobridge.com> on 07/05/2000 12:56:06 PM
Please respond to ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)
Subject: Re: Recovery until point in time...
yes.
You can roll a cold backup forward by applying the archivelogs before
opening
the database. Bring database to mounted state and use the recover
database
command to roll forward. After applying all logs you want, alter database
open
resetlogs.
You then might want to shutdown the DB and take a fresh cold backup.
rockyw_99_at_yahoo.com on 07/05/2000 01:46:16 PM
Please respond to ORACLE-L_at_fatcity.com
To: ORACLE-L_at_fatcity.com
cc: (bcc: Allen R. Lucas/Plainfield/CBI)
Hi Gang,
Is it possible to recover a database from cold backup using archived logs
that were generated after the cold backup? In other words, applying logs
that were generated on Friday to a cold backup that was taken on Thursday
by manually telling the database the name of the log to use to recover to
a time on Friday <Whew, that hurt to type in!>?
TIA,
rockyw_99_at_yahoo.com
-- Author: Rocky Welch INET: rockyw_99_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Wed Jul 05 2000 - 14:54:38 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Author: Allen R. Lucas INET: alucas_at_chicagobridge.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
 |
 |