| | brbackup example
This command will perform full database backup. Run it as ora user.
brbackup -u / -t online -c force -m all -p initSID.sap | |   
More...
03/08/07 | | | | | | | | |
|
|
| | brrestore examples
Running brrestore without any options will restore all datafiles from the latest database backup.
To restore control files:
brrestore -m 0
To restore all datafiles from the last backup (not including controlfiles and redo logs):
brrestore -b last -m all | |
More...
03/07/07 | | | | | | | | |
|
| | How to install SAP license key
To install a SAP license key use the utility saplicense i.e.
saplicense -install
It will prompt you for SAP SYSTEM ID, hardware key etc. Enter all the information it's asking and hit enter. You should see this:
saplicense: License successfully installed
You can also check what licenses were installed by running
saplicense -show
| |
More...
03/02/07 | | | | | | | | |
|
| | ssh without password
On the Client, run the ssh-keygen utility.
Change directory to .ssh directory.
Do not enter a passphrase.
Example:
/apps/oracle/.ssh> ssh-keygen -t rsa
Enter file in which to save the key(/apps/oracle/.ssh/id_rsa): [enter]
Generating public/private rsa key pair.
Enter passphrase(empty for no passphrase): [enter]
Enter same passphrase again: [enter]
Your identification has been saved in /apps/oracle/.ssh/id_rsa.
Your public key has been ... | |
More...
02/27/07 | | | | | | | | |
|
| | Change PostgreSQL table column
In this example a column type is changed to varchar of size up to 10 characters:
ALTER TABLE [table name] ALTER COLUMN [column name] TYPE VARCHAR(10); | | More...
02/27/07 | | | | | | | | |
|
| | How to ANALYZE partitioned tables with VALIDATE STRUCTURE
If you got the error:
ORA-14508: specified VALIDATE INTO table not found
This may be because you are trying to analyze a partitioned table and INVALID_ROWS table is not found in the current schema.
To validate structure (checks objects for logical corruption) for partitioned tables you first need to ensure that you’ve got ... | |
More...
01/24/07 | | | | | | | | |
|
| | WARNING: TEMP tablespace is not large enough for the upgrade
Apparently Oracle wants the default temporary tablespace to be locally managed when upgrading from 10.1 to 10.2. When running utlu102i.sql script it throughs this warning if your temp tablespace is dictionary managed:
--> SYSTEM tablespace is adequate for the upgrade.
.... minimum required size: 347 MB
WARNING: --> TEMP tablespace is not large ... | | More...
01/23/07 | | | | | | | | |
|
| | How to add a column to PostgreSQL table
Below example adds a new column of type varchar and length 10 characters to a PostgreSQL database table:
psql> ALTER TABLE [table_name] ADD COLUMN [column_name] VARCHAR(10);
You can run it from psql, phpPgAdmin or any other admin tool
| | More...
01/19/07 | | | | | | | | |
|
| | Resize or add datafiles using brspace
This is a quick reference for SAP brspace utility.
To add a new file to tablespace (to keep the same size as the previous file and keep the same location) run:
brspace -c force -f tsextend -t [tablespace name]
The file properties such as size, autoextend, filesystem will default to the file that ... | |
More...
01/09/07 | | | | | | | | |
|
<< 1 | 2 | 3 | 4 | 5 | 6 | Page 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 >>
|
