In Unix,
= to run the update stats, use
brconnect -u / -c -f stats -t ALL
>> you may also use the above to address the kosima dbverify alert.
= to run the dbcheck manually again.
brconnect -u / -c -f check
Continue Reading
In DBrefresh, you will need to create controlfile from tracefile.
In sqlplus,
- alter database backup controlfile to trace resetlogs;
- this file can be found in /oracle/SID/saptrace/usertrace
Continue Reading
During DB refresh, you will need to copy sapdata. Before doing so, you have to alter database backup mode for tablespace to active
In sqlplus,
- ALTER DATABASE BEGIN BACKUP;
- once complete the copy of files,
- ALTER DATABASE END BACKUP;
Continue Reading
This command does not need to restart db.You can do it at run time
In sqlplus,
SQL> show parameter log_archive_dest;
SQL> startup mount;
SQL> alter system set log_archive_dest='/oracle/D28/oraarch' scope=memory;
* LOCATION will be the new path for your archive log folder.
* you may remove LOCATION word if sqlplus gives error.
Continue Reading