Home » RDBMS Server » Backup & Recovery » 9i Recover database with redo log files
9i Recover database with redo log files [message #109515] Fri, 25 February 2005 04:04 Go to next message
temm
Messages: 2
Registered: February 2005
Junior Member
Im trying to build a backup strategy and created a test enviroment with 9.2i
I have made a cold backup of all datafiles, control files, redo log files, pwd files, initsid.ora of the production database.
I've put the test database into archivelog and have two questions.
1. When i recover the database (restoring only the datafiles) with
recover database until cancel using backup controlfile;
alter database open resetlogs;
everything works fine even if i use the current controlfile or the backup one.
Should the last working controlfile be used and what is the difference?

2. How can i recover everything and from the latest redo log files so there will be no data loss?

Thank you.


Re: 9i Recover database with redo log files [message #109940 is a reply to message #109515] Wed, 02 March 2005 02:25 Go to previous message
temm
Messages: 2
Registered: February 2005
Junior Member
well i found out that after using all archive log files i just have to give the last current redo log file and all data will be recovered.
i haven't understood the difference between the old control file (the backuped one) and the last working copy since they both work.

Teo
Previous Topic: ORA-01033
Next Topic: pl/sql or unix script for oracle dba to see database status
Goto Forum:
  


Current Time: Fri Mar 29 06:38:31 CDT 2024