Discussion :

[mboubidi]

Bonjour,
je veux juste une confirmation pour un backup d'une BD Oracle, après un shutdown abort est ce qu'il est consistant ou pas.
Merci pour votre réponse;
Salutations.

[mboubidi]

Bonjour,
je vous remercie j'ai eu la réponse:

Inconsistent Backup:

An inconsistent backup is a backup of one or more database files that you make while the database is open or after the database has shut down abnormally.


sur le site Oracle.com


http://download.oracle.com/docs/cd/B...519/backup.htm


salutations.

[mboubidi]

Inconsistent Backup

An inconsistent backup is a backup in which all read/write datafiles and control files have not been checkpointed with respect to the same SCN. For example, one read/write datafile header may contain an SCN of 100 while other read/write datafile headers contain an SCN of 95 or 90. Oracle cannot open the database until all of these header SCNs are consistent, that is, until all changes recorded in the online redo logs have been applied to the datafiles on disk.
If the database must be up and running 24 hours a day, 7 days a week, then you have no choice but to perform inconsistent backups of a whole database. For example, a backup of an offline tablespace in an open database is inconsistent with other tablespaces because portions of the database are being modified and written to disk while the backup of the tablespace is progressing. The datafile headers for the online and offline datafiles may contain inconsistent SCNs. You must run your database in ARCHIVELOG mode to make online backups of online datafiles.
If you run the database in ARCHIVELOG mode, then you can construct a whole database backup using backups of online datafiles taken at different times. For example, if your database contains seven tablespaces, and if you back up the control file as well as a different tablespace each night, then in a week you will back up all tablespaces in the database as well as the control file. You can consider this staggered backup as a whole database backup.
Inconsistent Closed Backups

You have the option of making inconsistent closed backups if a database is backed up after a system crash or SHUTDOWN ABORT. This type of backup is valid if the database is running in ARCHIVELOG mode, because both online and archived redo logs are available to make the backup consistent.

[pachot]

Bonjour,
Juste une précision:
Après un shutdown abort, les datafiles ne sont pas consistents.
Par contre, avec le redo logs online, la base peut être rendue consistente avec un recovery.
Cordialement,
Franck.

[mboubidi]

Bonjour,
Juste une précision:
Après un shutdown abort, les datafiles ne sont pas consistents.
Par contre, avec le redo logs online, la base peut être rendue consistente avec un recovery.
Cordialement,
Franck.

Merci chef pour ta précision,
bon fin de journée.
Salutations.