Quote:
Originally posted by DcsoBob
I emptied the database and did an import (except for system). Only dropped all the user and application data. Did an import from the first of the month. Copied over the archive logs. Opened the database and issued the recover command. Got the message that the database did not need recovery.
You are talking about two seperate databases now. The database you have wiped out has its own SCN and can not be synced up with an import.
Quote:
Now, is this because the export produced an in-sync setup?
You data is current only to the point of the export.
Quote:
I am still reading through the backup and recovery books, but I am thinking that it should have worked.
Nope, no way. Never. Archivelogs and import/export have nothing to do with each other.
Quote:
If I undersand correctly, the SCN's in the control file, to show where we "are" in the process, would not match the header information in the datafiles, thus prompting a roll forward of the archive logs. But, I did not copy over the datafiles, I just emptied them and refilled them. So, will hte header information be the same.
Nope, the datafiles will have different file#'s (probably) and different header information. You are talking about two different databases at this point.
Quote:
I seem to be remember being told in my backup and recovery class that you could not create a new database on a new machine, copy over archive logs from old machine, and roll forward.
Yup.
Quote:
He said the SCN's are machine dependent.
Think of it this way, SCN's are instance specific. Once you cross instances, the SCN numbers are no longer relevant.
Quote:
If I restore the database from a previous cold backup, then there is no need for the import. Once I issue the open command, the database will recover automatically. Might take it a little while to roll through the logs, but it will open.
This is the proper way to do a backup/recovery.
Quote:
I am reviewing the restore procedures from hot backups.
That's a good idea. Repeat this to yourself every 30 seconds as you are reading through your documentation: Export/import is not a backup methodology.
Quote:
If i also drop the SYSTEM tablespaces and reimport them from the export, will that cause the archive logs to roll forward on the new box? What is "telling" the database that it has to roll forward. Is it a check of the current log number and SCN?
You are talking about a new database. Forget about import/export.
Quote:
BTW, thanks for the patience and the answers. It's what I love about posting to this forum. Very helpful. Thanks !!