SAP BASIS,HANA AND ORACLE DBA BLOGS

Basic explanation of COLD BACKUP and HOT BACKUP A database is in CONSISTENT STATE when it shut down normally . If database ARCHIVING is not enabled(NOARCHIVELOG) you must take a CONSISTENT backup A database is in INCONSISTENT STATE when it is open and there are ongoing transactions AND it is shutdown abnormally . If database ARCHIVING is enabled(NOARCHIVELOG) you take an INCONSISTENT backup.     A HOT BACKUP is one that is taken when database is OPEN and is possible only if the database is in ARCHIVELOG mode. (PROBLEM)--- HOT BACKUPS are performed at TABLESPACE level only. EXAMPLE SQL>ALTER TABLESPACE USERS BEGIN backup; SQL> host cp /u01/app/oracle/oradata/orcl/users01.db /home/oracle/hotbackup SQL> host cp /u01/app/oracle/oradata/orcl/users02.db  /home/oracle/hotbackup SQL>ALTER TABLESPACE USERS END BACKUP; --- Next, force a log switch so Oracle will archive the current redo log file.(for redo generated duri...

RMAN BASIC COMMANDS FOR QUICK START                            by anand gupta For the impatient, here is the quick snippet, that takes RMAN backup of both database and archive logs. RMAN> BACKUP AS BACKUPSET DATABASE PLUS ARCHIVELOG; 1. View Current RMAN Configuration Before we take the backup, we have to configure certain RMAN parameters. For example, how long you want to reatain the RMAN backup, etc. Before we modify any configuration, execute the following command to view all current RMAN configuration settings. To connect to RMAN, do the following from command line. This will take you to RMAN> command prompt, from here you can execute all RMAN commands. $ rman target / Recovery Manager: Release 10.2.0.3.0 - Production on Sat Aug 10 11:21:29 2013 Copyright (c) 1982, 2005, Oracle.   All rights reserved. connected to target database: DEVDB (DBID=821773) RMAN> T...