Contact us for help registering your account, Veritas NetBackup for Oracle Administrator's Guide, NetBackup for Oracle operation using the Oracle Intelligent Policy, Logging the RMAN input and output on a client, NetBackup for Oracle operation using a script- or template-based policy, Creating an Oracle database instance group, Verifying the operating system and platform compatibility, Requirements for using NetBackup for Oracle in a NetBackup cluster, About the license for NetBackup for Oracle, About linking Oracle RMAN with NetBackup for UNIX, Verifying environment variables and shutting down Oracle, Linking Oracle RMAN with NetBackup on UNIX platforms, Preparing for NetBackup for Oracle configuration, Permissions for NetBackup for Oracle log directories, Oracle Home User permissions when NetBackup SAN Client is used, Configuring the Maximum jobs per client for NetBackup for Oracle, Instance management for an Oracle Intelligent Policy, Viewing the Oracle database instance repository, Manually adding an Oracle database instance to the repository, Automatic Registration of an instance group, Creating an Oracle Intelligent Policy (OIP), Oracle database upgrade effect on Oracle Intelligent Policies, Configuring NetBackup for Oracle automatic backup schedules, About NetBackup for Oracle schedule properties using Oracle Intelligent Policy, Oracle Intelligent Policy - Storage and Retention, About Oracle Intelligent Policy master server behavior, About using a NetBackup appliance share for Oracle backups (Copilot), Configuring an OIP using a share on the NetBackup appliance (Copilot), About script- or template-based Oracle policies, Adding a new script- or template-based Oracle policy, About backup schedules, templates, and scripts, Script- or template-based policy - Storage and Retention, About adding backup selections to an Oracle policy, Adding a template to the backup selections list in the NetBackup Administration Console, Adding a script to the backup selections list in the NetBackup Administration Console, About configuring the run-time environment, About the environment variables set by NetBackup for Oracle, About creating templates and shell scripts, Starting the NetBackup Backup, Archive, and Restore interface, Creating RMAN templates using the NetBackup for Oracle RMAN template generation wizard, About the NetBackup for Oracle sample scripts, Using the NetBackup for Oracle sample scripts, Configuring the logon account for the NetBackup Client Service for NetBackup for Oracle, Testing configuration settings for NetBackup for Oracle, Performing backups and restores of Oracle, Running the NetBackup for Oracle shell script, Browsing backups using the bplist command, Using bpdbsbora to run a recovery template, About an Oracle recovery shell script on the client, About Oracle multistream restore for proxy backup, Redirecting a restore to a different client, Preparing the master server for an alternate restore, About performing a redirected restore with RMAN, Example - Performing a redirected restore of Oracle, Using NetBackup for Oracle in a Microsoft Windows cluster environment, About backups of an Oracle clustered database on Windows, Bringing the database instance offline on Windows, Bringing the database instance online on Windows, User-directed backup or restore from the Windows client, Creating an instant recovery point from an Oracle Copilot image, Deleting an instant recovery point for Oracle Copilot instant recovery, Cleaning up the Copilot share after point in time restore of database, Single-step restore to ASM storage from a Copilot recovery point, About restoring from a data file copy to ASM storage using RMAN, Guided Recovery cloning pre-operation checks, Performing a Guided Recovery cloning operation, Troubleshooting files for metadata collection operations at the time of the backup, Troubleshooting files for Guided Recovery validation operations, Troubleshooting files for Guided Recovery cloning operations, NetBackup for Oracle with Snapshot Client, About NetBackup for Oracle with Snapshot Client, NetBackup for Oracle stream-based operations, NetBackup for Oracle file-based operations, How NetBackup for Oracle with Snapshot Client works, About the NetBackup for Oracle backup and restore operations, Database objects supported by advanced backup methods, About configuring Snapshot Client with NetBackup for Oracle, Configuration requirements for snapshot backups with NetBackup for Oracle, Configuring a snapshot policy for NetBackup for Oracle, Configuring a snapshot policy using a share on the NetBackup appliance (Copilot), Restoring NetBackup for Oracle from a snapshot backup, About restoring individual files from a NetBackup for Oracle snapshot backup, About NetBackup for Oracle restores of volumes and file systems using snapshot rollback, Performing a snapshot rollback restore from the Java or Windows interface, Performing a snapshot rollback restore using a script or RMAN command, Performing a NetBackup for Oracle point-in-time rollback restore from a SnapVault backup (UNIX), About configuring NetBackup for Oracle block-level incremental backups on UNIX, How BLI works with NetBackup for Oracle (UNIX), About the Storage Checkpoint facility and NetBackup for Oracle, Configuration requirements for BLI backups with NetBackup for Oracle, Configuring policies for BLI backups with NetBackup for Oracle, About the types of NetBackup for Oracle BLI backups, How Snapshot Client software affects backup types, How Snapshot Client software affects schedule properties, How Snapshot Client software affects templates and scripts, NetBackup for Oracle with Snapshot Client environment variables, About Oracle support for Replication Director, Configuring an Oracle Intelligent Policy using Replication Director, Configuring a script- or template-based Oracle policy, About troubleshooting NetBackup for Oracle, About NetBackup for Oracle troubleshooting steps, Enabling the debug logs manually (Windows), Setting the debug level on a Windows client, Troubleshooting RMAN backup or restore errors, Troubleshooting each stage of the backup or restore, Troubleshooting the UNIX browser interface and wizards, Troubleshooting NetBackup for Oracle with Snapshot Client, Minimizing timeout failures on large database restores, Minimizing the loading and unloading of tapes for database backups, Delays in backup job transfer and completion, About virtual names and NetBackup for Oracle, Troubleshooting database restores (UNIX and Windows), AppendixB.
Source: Internet, every post is very descriptive Good one, Oracle DBA Tweets . Learning is Fun-tastic, http://anuj-singh.blogspot.in/2011_07_16_archive.html, oracledbazone.wordpress.com/2012/04/18/useful-rman-commands/, Oracle APPS DBA Interview Questions and Answers, Oracle DBA Interview Questions and Answers, How to find Table Fragmentation in Oracle Database, Oracle DBA Interview Questions and Answers - Performance Tuning, Oracle DBA Interview Questions and Answers - RAC, Oracle DBA Interview Questions and Answers - Architecture, Oracle DBA Interview Questions and Answers - Patching,Cloning and Upgrade, Oracle DBA Interview Questions and Answers - Backup and Recovery, How to Copy files from ASM to filesystem and filesystem to ASM, Oracle DBA Interview Questions and Answers - Dataguard, Oracle DBA Interview Questions and Answers - ASM, Backup / Delete - Archivelogs and RMAN backups. Hello! Valuable information thanks for sharing Oracle DBA Online Training, Thanks for sharing this valuable information. round(sofar/totalwork*100,2) % Complete system archive log current'; SQL> SELECT sid, serial#, context, sofar, totalwork,
progress can be monitored by looking at where context = 3 as in the case Oracle DBA Tweets . Learning is Fun-tastic . optimizer_mode=RULE"; 4> allocate channel for maintenance device type disk; 5> allocate channel for maintenance device type SBT; 9> delete noprompt expired archivelog all; 56> # Hot database level 1 cumulative incremental WHERE totalwork 0 3> sql "alter session set We noticed that while you have a Veritas Account, you aren't yet registered to manage cases and use chat. and upper(opname) like %RMAN% 67> sql 'alter SQL> SELECT sid, serial#, context, sofar, totalwork, http://repettas.wordpress.com/2008/11/01/rman-general-commands-views-etc/, http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10770/rcmsynta.htm, http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10734/rcmcnctg.htm, http://www.oracle-base.com/articles/10g/RMANEnhancements10g.php, http://download.oracle.com/docs/cd/B14117_01/server.101/b10734/wnbradv.htm. completes creating the backpiece new sessions are created so overall SQL> alter system set db_block_checking = true scope=both; SQL> alter database enable block change tracking using file '/FRA/oradata/prod/change_tracking.f'; SQL> alter system set log_archive_dest_2='location=/bkp/prod/archive2' scope=both; SQL> alter database add logfile member '/u03/prod/redo21.log' to group 1; RMAN> backup check logical database plus archivelog delete input; RMAN> backup as compressed backupset incremental level 0 check logical database plus archivelog delete input; RMAN> backup as compressed backupset incremental level 0 check logical database filesperset 1 plus archivelog; backup as compressed backupset incremental level 0 check logical database plus archivelog; delete input" if you don't want to delete archivelogs after backup automatically. You must stop talking about the problem and start talking about the solution, start speaking words of victory. Always be positive and keep smiling..have a great day friends :) RMAN> backup database filesperset 1 plus archivelog delete input; SQL> alter system set control_file_record_keep_time=21 scope=both; RMAN> configure controlfile autobackup on; How to Check Clusterware Version and Name? We should never stop working on ourselves. following SQL you can monitor the progress of RMAN process, as channels You have posted a trust worthy blog keep sharingjava training in chennaidot net training in chennaiphp training in chennai, for preparing bank exam and group exam , we are providing an online test model questions papersGroup Exam Questions and AnswersBank Exam Questions and Answers, nice post.oracle dba trainingoracle dba online training. and sofar totalwork; Using the below it shows the overall progress is 38.05% complete. backup. Cluster related process in 11g RAC R2 Environment. FROM v$session_longops The following is an example fragment from an RMAN script that performs an optimized, deduplicated, stream-based backup of an Oracle database. Best practices for protecting Oracle RAC with NetBackup, About using Templates and Oracle Intelligent Policy (OIP) with RAC, Example RAC configuration: Failover name exists and backup is not load balanced, Example RAC configuration: Failover name exists and backup is load balanced, Example RAC configuration: Failover name is not available and backup is not load balanced, Example RAC configuration: Failover name is not available, and backup is load balanced, one policy with custom script, Example RAC configuration: Failover name is not available and backup is load balanced, simple script with manual policy failover, Configuring the appliance within a RAC environment, Optimizing and deduplicating stream-based and proxy copy Oracle backups, Example RMAN script for a stream-based backup, Editing the RMAN script and configuring NetBackup for Oracle for a proxy copy backup, Example RMAN script for a proxy copy backup, AppendixD.Snapshot Client support of SFRAC, NetBackup configuration for an SFRAC environment, Configuring the SFRAC environment for a backup operation, Performing a rollback restore in an SFRAC environment, Troubleshooting NetBackup in an SFRAC environment, AppendixE.Script-based block-level incremental (BLI) backups without RMAN on UNIX and Linux systems, About script-based block-level incremental (BLI) backups without RMAN, Verifying installation requirements for BLI backups without RMAN, File system and Storage Checkpoint space management, Creating NetBackup policies for script-based BLI backup, Number of policies required for BLI backup, Setting the maximum jobs per client global attribute, Identify the POLICY_IN_CONTROL for BLI backups, Oracle environment variables for BLI scripts, About BLI notify scripts for other policies, About NetBackup for Oracle agent automatic backups, About NetBackup for Oracle manual backups, About troubleshooting backup or restore errors, Troubleshooting stages of backup and restore operations, NetBackup restore and backup status codes, NetBackup for Oracle XML export and XML import, NetBackup for Oracle XML export and import archiving features, Sequence of operation: XML export archive, Sequence of operation: XML import restore, About the environment variables set by a user in the XML export parameter file, About XML export templates and shell scripts, Creating XML export templates using the NetBackup for Oracle wizard (UNIX), Creating XML export templates using the NetBackup for Oracle wizard (Windows), Creating an XML export script from a template, Running NetBackup for Oracle XML export templates, Using bpdbsbora to run an XML export template, Running the NetBackup for Oracle XML export script on the client, Running bporaexp on the client as an Oracle user, Writing to a directory versus writing to a storage unit, Browsing XML export archives using bporaimp parameters, Browsing XML export archives using bplist, Running the XML import wizard on the client, Using bpdbsbora to run an XML import template, Running an XML import script on the client, About redirecting a restore of an XML export archive to a different client, Redirecting a restore of an XML export archive to a new client using bporaimp, Example - Using bporaimp for a redirected restore, Troubleshooting XML export or XML import errors, Checking the logs to determine the source of an error, Troubleshooting each stage of the XML export or XML import, AppendixG.Register authorized locations, Registering authorized locations used by a NetBackup database script-based policy.