Articles tagged with: Oracle
Administration, Backup Recovery, Oracle »
Your database has to be in archive log mode for this script to work.
Code:
RMAN> run {
2> # backup the database to disk
3> allocate channel d1 type disk;
4> backup
5> full
6> tag full_db
7> format ‘/backups/db_%t_%s_p%p’
8> (database);
9> release channel d1;
10> }
Administration, Backup Recovery, Oracle »
This script will perform datafile recovery
Code:
RMAN> run {
2> allocate channel d1 type disk;
3> sql “alter tablespace users offline immediate”;
4> restore datafile 5;
5> recover datafile 5;
6> sql “alter tablespace users online”;
7> release channel d1;
8> }
Oracle Error »
ORA-31223: DBMS_LDAP: cannot open more than string LDAP server connections
Cause: An attempt was made to open more than the maximum allowed LDAP server connections.
Action: Free unused connections.
Oracle Error »
ORA-31228: DBMS_LDAP: invalid MOD_ARRAY
Cause: An attempt was made by a PL/SQL module to use a MOD_ARRAY which is not valid and might have already been freed.
Action: Check the MOD_ARRAY in PL/SQL module involving DBMS_LDAP.
Oracle Error »
ORA-31398: DBMS_LDAP: Shared servers are not supported.
Cause: The session executing functions from the DBMS_LDAP package is being handled by a shared server in the Database.
Action: Use dedicated database sessions to execute functions in the DBMS_LDAP package.
Oracle Error »
ORA-31404: all input parameters are null
Cause: All input parameters are null. At least one property must be altered.
Action: Call the procedure again, making sure that all the required parameters have been specified. Ensure that at least one parameter is not null. Refer to user documentation for the correct way of calling this procedure.



