Month: April 2005

nnnnnRDBMS Version: 8.1.7.2Operating System & Version: AIX 4.3.2Error Number (if applicable):Product (i.e. SQL*Loader, Import, etc.): RMAN w/ TDPProduct Version:RMAN + TDP backup failureHi,I have Oracle 8.1.7.3 running on an IBM AIX 4.3.2 OS. TDP has been configured w/ RMAN for complete hotbackups. Thissetup was working fine for the last 4 months before I started receiving…

nnnnnStarting RMAN backup based on Archive File System Usage: nStarting RMAN Backup Based on Archive File Systemnby Avnish RastoginnOften when DBAs do export/import to load data from one database to another database, it gerenartes archive logs at very high pace and fills up archive file system in couple of hours. Below script will help DBA…

nnnnnattach all the datababses on a SQL Server:If you are trying to attach all the files to a simillar location as the current server, you can use the script below. It will print out the script with sp_attach_db statements for all the databases. It doesn’t look for secondary files and you can update the script…