olzcalgary.blogg.se

Oracle database backup
Oracle database backup










oracle database backup

DEVICE TYPE DISK to back your database up to a writeable CD or DVD, or some other device that has a larger physical block size. However, you can encounter this limitation when using BACKUP. In practice, most disk drives have physical block sizes of 512 bytes, so this limitation rarely affects backup. For example, a disk device with a block size of 2 KB can only be used as a destination for backups of Oracle files with logical block sizes of 2 KB, 4 KB, 6 KB and so on. When backing up Oracle Database files to disk, the logical block size of the files must be an even multiple of the physical block size of the destination device. If you specify DEVICE TYPE sbt, then you can back up files to any media supported by the media manager. If the statement CREATE TABLESPACE tablespace_name DATAFILE 'filename' works, then 'filename' is a valid backup path name. You can make a backup on any device that can store a data file. If you specify DEVICE TYPE DISK, then RMAN makes backups to random access disks. RMAN can only back up files onto valid media.

oracle database backup

You cannot use RMAN to back up a NOARCHIVELOG database after an instance failure or SHUTDOWN ABORT. The shutdown is only consistent if you successfully execute the SHUTDOWN command with the NORMAL, IMMEDIATE, or TRANSACTIONAL options. If the target database is in NOARCHIVELOG mode, then the database must be mounted after a consistent shutdown when you make the backup. You must apply redo log files after restoring an inconsistent backup to make the database consistent. Backups made while the database is open are inconsistent. If the target database is in ARCHIVELOG mode, then the database must be mounted or open with a current control file. See the CONNECT and RMAN commands to learn how to connect to a database as TARGET. RMAN must be connected to a target database.












Oracle database backup