-
编辑 删除
backup/restore pluggale database
Restore part PITR:Connect to CDB:ALTER pluggable database jackey close;run{set until scn xxx;restore pluggable database jackey;recover pluggable database jaceky}ALTER pluggable database jackey open resetlogs;
-
编辑 删除
compile invalid object
SQL> select owner, object_name,object_type from dba_objects where status ='INVALID'; OWNER--------------------------------------------------------------------------------OBJECT_NAME--------------------------------------------------------------------------------OBJECT_TYPE---------------------...
-
编辑 删除
RAC modify online redo log size
1.Add log fileSQL> alter database add logfile thread 1 group 7 ('+Q4DBFILE/ORADB/ONLINELOG/online7.dbf','+Q4DBFRA/ORADB/ONLINELOG/ronline7.dbf') size 500m reuse;SQL> alter database add logfile thread 1 group 8 ('+Q4DBFILE/ORADB/ONLINELOG/online8.dbf','+Q4DBFRA/ORADB/ONLINELOG/ronline8.dbf') size 5...
-
编辑 删除
Single instance to RAC related
You can refer to http://www.linkedin.com/groups/How-will-you-convert-single-3156190.S.5875270675291217921?view=&item=5875270675291217921&type=member&gid=3156190&trk=eml-b2_anet_digest-null-2-null&fromEmail=fromEmail&ut=22vczqI8fclmg1 for detailed information.a. using dbca b. using EM&...
-
编辑 删除
system state dump when cannot connect to db instance
$ORACLE_HOME/bin/sqlplus /nologSQL> set _prelim onSQL> connect / as sysdbaPrelim connection establishedSQL> !ps -ef|grep pmon racusr2 16086 1 0 01:07 ? 00:00:00 ora_pmon_DB21...
