Teamcenter11数据库恢复使用的控制台命令

登陆：
sqlplus /nolog
conn sys as sysdba
infodba

删模式：
@D:\app\Administrator\product\11.2.0\dbhome_1\assistants\dbca\templates\tc_unpopulate_db.sql

创建目录对象：
create directory dpfolder as 'E:\TCDBBACKUP';

授权：
grant read,write on directory dpfolder to infodba;

grant create sequence to infodba;

grant connect,resource,dba to infodba;


设置临时表空间自动增容：
alter database tempfile 'D:\app\Administrator\oradata\tc11\TEMP01.DBF' autoextend on next 20m;

导入备份：
host impdp infodba/nfodba schemas=infodba directory=dpfolder parallel=16 dumpfile=DATA_2020-08-02.DMP

设置密码有效期为永久：
SELECT username,PROFILE FROM dba_users;
SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;