5、启动数据库
SQL> startup ORACLE instance started. Total System Global Area 4275781632 bytes Fixed Size 2220200 bytes Variable Size 2113933144 bytes Database Buffers 2147483648 bytes Redo Buffers 12144640 bytes Database mounted. Database opened. SQL> exit |
6、修改用户密码
SQL> alter user oaadmin identified by oaadmin;
User altered.
7、解锁帐户
SQL> alter user oaadmin account unlock;
User altered.
上面第4步也可以利用一条命令直接处理：
select 'host cp /u03/backup/'||substr(name,(instr(name,'/',-1)+1))|| ' '||name from v$controlfile union all select 'host cp /u03/backup/'||substr(name,(instr(name,'/',-1)+1))|| ' '||name from v$controlfile union all select 'host cp /u03/backup/'||substr(member,(instr(member,'/',-1)+1)) ||' '||member from v$logfile union all select 'host cp /u03/backup/spfile${ORACLE_SID}.ora $ORACLE_HOME/dbs/' from dual union all select 'host cp /u03/backup/orapw${ORACLE_SID} $ORACLE_HOME/dbs/' from dual; |
