Oracle Standalone Rman Note [4]---rman online backup

Note: Rman backup (supports SPFile-based backup only and does not support Init.ora configuration-based backups)

exercise: Turn on Archivelog mode1\ For archived redo logs are referred to FRA and separate archive log target SQL>Show parameter db_recovery_file_dest; SQL>AlterSystemSetDb_recovery_file_dest_size=2G; SQL>AlterSystemSetDb_recovery_file_dest='/u01/app/oracle/fast_recovery_area'; 2\ Now, define two archive log target directories, one is FRA. Set the database file and set the Log_archive_dest_1 parameter to point to the pre-defined file system, which will be the first archive log directory, since you want to configure the log_archive_dest_1 parameter using 1=RA, you need to use the parameter Use_db_recovery_file_dest parameter to set the LOG_ARCHIVE_DEST_10 parameter to point to the FRA. Use the show parameter command to verify that the settings are correct for SQL>AlterSystemSetLog_archive_dest_1='LOCATION=/BACKUP/ARCHIVE/ORCL'; SQL>AlterSystemSetLog_archive_dest_10='location=use_db_recover_file_dest'; SQL>Show parameter log_archive_dest; SQL>show parameter recover; SQL>ArchiveLoglist; 3\ Close Database SQL>shutdownimmediate; 4\ Load Database SQL>startup Mount; 5\ Place database into Archivelog mode SQL>Alter DatabaseArchivelog; View Archive mode SQL>ArchiveLoglist; See if archive mode turns on SQL>SelectLog_mode fromv$Database; 6\ Open Database SQL>Alter Database Open;

Exercise: Turn off archive mode        SQL>shutdown  immediate;        SQL>startup Mount;        SQL>alterdatabase  noarchivelog;        SQL>alterdatabaseOpen

Exercise: Perform an online backup operation1\ Start Rman[:~]$ Rman Target=Backup_admin/111111        2\ Start Backup operation RMAN>Backup  Databaseplus archivelog; 2\ Delete Archive log after backup RMAN>Backup  DatabasePlus ArchivelogDeleteinput; 2\ Backup, set up only one backup file per backup set RMAN>BackupFilesperset= 1  DatabasePlus ArchivelogDeleteinput; Execution times wrong'ora-19809:limit exceeded for recovery files'workaround Increase the flash back size: SQL>AlterSystemSetDb_recovery_file_dest_size=10G; Configure the default location for archive logs Configure channel1Device typeDiskFormat'/backup/archive/orcl/backup_%u'Configuration Backup has two copies of configure DataFileBackupCopies forDevice typeDisk  to 2; Automatic backup control file Configure Controlfile Autobackup on; Clears the default Channel 1 setting configure channel1Device typeDiskClear Settings control file backup format Configure Controlfile autobackup format forDevice typeDisk  to '/backup/archive/orcl/controlfile. Orcl.%f'; Check the archive log crosscheck Archivelog All; Delete Expired archive logsDeleteExpired Archivelog All; DeleteArchivelog AllCompleted before'sysdate-1'; DeleteArchivelog AllCompleted before'sysdate'; run{Configure Controlfile Autobackup on; SetControlfile autobackup Format forDevice typeDisk  to 'Controlfile. Orcl.%f'; BackupFilesperset= 1  DatabasePlus ArchivelogDeleteinput; }

-----End-------

Oracle Standalone Rman Note [4]---rman online backup