Check the configuration parameters of Rman. Connect to Rman without catalog. Controlfile is used to store Rman metadata: You need to set the environment before invoking Rman: ORACLE_BASE=/u01/app/oracle ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1 ORA_CRS_HOME=/u01/app/crs ORACLE_PATH= $ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin ORACLE_SID=mars1 $rman target / nocatalog RMAN> show all; RMAN>exit; ———————————– rmanbackupconf.sh rman target / nocatalog <<EOF CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # […]

Orac is the creation of a dedicated group of volunteer programmers led by Andy J. Duncan. Some of the major contributors include Kevin Brannen and Thomas Lowery, but many others too numerous to mention have contributed as well. A list of most of the contributors is included in the README file that accompanies the program. […]

http://www.materialdreams.com/oracle/ http://www.orafaq.com/ http://www.orafaq.com/scripts/ http://www.idevelopment.info/data/Oracle/DBA_tips/Sun_Solaris/SUNSOLARIS_5.shtml http://www.dbasupport.com/oracle/scripts/ The OracleResourceStop Script Archive Mark Lang’s Script collection OraMag’s Code Depot Material Dreams’ DBA Scripts Biju’s Oracle tips and scripts page Steve Rea’s Oracle Tips, Tricks, and Scripts Tracing the Sessions(s) of a Given User In a case where you cannot (because you don’t have enough time, for example) query […]

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘/orabackup/rman/%F’; CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO […]

http://www.oracle.com/technology/oramag/code/tips2005/010305.html select substr(a.sid,1,10) sid, substr(nvl(b.program,machine),1,30) program, count(*) from v$open_cursor a, v$session b where a.saddr=b.saddr group by substr(a.sid,1,10), substr(nvl(b.program,machine),1,30) order by 3 desc ; Track and Monitor Resources This tip comes from Luis Adalberto, DBA at Universidad Autonoma de Coahuila, in Saltillo, Coahuila, Mexico. Running this query will produce a list of database statements and objects […]