rman restore database from disk backup

Oracle rman database backup and recovery in non-archive mode, mongolerman1. database Backup SQL> archive log list in non-archive mode; automatic archiving in non-archive mode in Database Log mode disable the archiving end point US

required (recovery) Non-consistent backup After the database is open (open), or the database closes abnormally (shut down abnormally), one or more data A backup of the library file. Non-conformance backups need to be restored after the restore operation 4.

optimization is that if you have backed up the same version of a file, you will no longer back up the file. , keep only one copy of the backup file.CONFIGURE Controlfile autobackup OFFDo not start automatic backup of control files, after modification to on, if the database structure changes or in the backup

RMANgt; backupdatabaseincludecurrentcontrolfileforstandbyplusarchivelog; note that the standby control is created when the database is backed up. RMANgt; backup database include current controlfile for standby plus archivelog; // note that the standby control is created when the database is backed up 1. General st

Tags: redo content orm Pre base class make Device tabStep 1:create the Incremental Backuprman> BACKUP DEVICE TYPE DISK INCREMENTAL from SCN 750983 DATABASE FORMAT '/tmp/incr_for_standby/bkup_%u ';Step 2:make the Incremental Backup Accessible at the Standby DatabaseFTP or SCP copy incremental

routine has been started. Total system global area 603979776 bytesFixed size 1250380 bytesVariable Size 163580852 bytesDatabase buffers 432013312 bytesRedo buffers 7135232 bytesSQL> exitFrom Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-ProductionWith the partitioning, OLAP and Data Mining options disconnected C: \> RMAN target sys/orcl @ demo auxiliary sys/orcl @ standby3 Recovery MANAGER: Re

. Example: You have a tablespace having one datafile of size 100 MB and out of 100 MB, 50 MB is used by the user tables. then user dropped a table belonging to that tablespace which was of 25 MB, with the new unused block compression on 25 MB of the files is backed up. in this example if null compression is used then it wocould have backed up 50 MB because null compression will consider the blocks that are Formatted/ever used. Unused Block Compression is done, if all of the following conditions

bytesVariable Size 281021364 bytesDatabase buffers 314572800 bytesRedo buffers 7135232 bytesThe database has been loaded.The database has been opened.SQL> exit From Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-ProductionWith the partitioning, OLAP and Data Mining options disconnected C: \> RMAN target sys

-pfile 'C:\init.ora'; Three. Restore the control file set oracle_sid=mdb > Sqlplus/nolog / as sysdba $ startup Nomount pfile=C:\init.ora $ exit > Rman target/ Rmanfrom 'C:\data\NCCNTRL_20150921_8AQHLUR6_1_1' #这一步需要使用到参数文件中对控制文件的配置信息 RMAN> ALTER DATABASE mount; Four. Catalog Bac