start and stop oracle RAC
Starting the Oracle RAC 10g Environment
$ export ORACLE_SID=orcl1
$ srvctl start nodeapps -n linux1
$ srvctl start asm -n linux1
$ srvctl start instance -d orcl -i orcl1
$ emctl start dbconsole
Stopping the Oracle RAC 10g Environment
$ export ORACLE_SID=orcl1
$ emctl stop dbconsole
$ srvctl stop instance -d orcl -i orcl1
$ srvctl stop asm -n linux1
$ srvctl stop nodeapps -n linux1
Start/Stop All Instances with SRVCTL
$ srvctl start database -d orcl
$ srvctl stop database -d orcl
datapump 10g
Connect
CONN sys/password@db10g AS SYSDBA
ALTER USER scott IDENTIFIED BY tiger ACCOUNT UNLOCK;
GRANT CREATE ANY DIRECTORY TO scott;
CREATE OR REPLACE DIRECTORY backup_dir AS ‘/u01/app/oracle/oradata/’;
GRANT READ, WRITE ON DIRECTORY backup_dir TO scott;
Difference between startup mount and startup mount exclusive
Fact: startup mount and startup mount exclusive are the same because default for startup mount is exclusive
STARTUP [FORCE][RESTRICT][NOMOUNT][MIGRATE][QUIET]
[PFILE=]
[MOUNT [EXCLUSIVE] x |
OPEN
]
For RAC and non-RAC databases, startup mount and startup mount exclusive have no differences.
startup mount exclusive is meant to shutdown all instances on a RAC and bringing up only one instance.
On a RAC database, when init parameter on all instances for cluster_database is set to TRUE, you will have to set cluster_database to FALSE and then shutdown all the RAC instances and then startup only one instance with startup mount exclusive. Since exclusive is default for startup mount, issuing startup mount is sufficient.
Oracle table size estimation
The following is an excerpt from http://www.itland.pl/en/knowledge_base/oracle/ I do not claim to be the author of this article.
Estimating table size
Estimating table size – calculation
Table size estimation is performed in a few steps.
First calculate database block header size with formula:
archivelog mode setup in 9i RAC/non RAC, 10g and 11g
10g/11g non rac single node instance
enable archiving:
SQL> SELECT log_mode FROM v$database; or SQL> archive log list
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT;
SQL> ALTER DATABASE ARCHIVELOG;
SQL> ALTER DATABASE OPEN;
