I was just wondering if it was possible to restore a database using the backup image? The reason is, i want to have another copy of the database in another machine which is not in the same domain.
Other question is, can i use the same image to restore on a different operating system.
the backup image from the same OS can be used for recreating the database at other machine.
Linux is considered a different OS than Unix.
HP-UX and Sun OS , I have used it for backing and restoring.
Never did it from aix to other unix system, but it can be done.
Sathayam , you do need log files , no matter that you have done online or offline backup,If your original database is in rollforward mode (userexit or logretain on) , you want to rollforward, and your restore database will be in the same state(after the restore).
Now after the restore you need log files for rollforward, only if it is allowed.
You can have an offline backup , but if you don't want to rollforward then you don't need these log files.
Incase of online, your original database must be in rollforward mode, so you must need log files to rollforward the database, so it must be consistent.
1. list history file command for backup.
2. the image file name contains the timestamp it is before the sequence no
.....< timestamp>.<seq no> . you will see instancename,type of backup,database name.
you need the archive file and the online log file if you want to perform rollforward operation, otherwise you don't need that.