after cloning from an open backup onto a different machine. same 10204 and OS. I'm applying the archive log from immediately after the backup for consistency. Oracle is still not able to recover the DB, says needs more recovery...
archangle25: what recovery prompt have you used? recover database until cancel?
i run that but it always is asking for the next in sequence archive og so whenever its done i then alter database open resetlogs and its always complaining about needing more recovery
have you isseued CANCEL ? :D recover database until cancel -> feed all archivelogs you want -> enter CANCEL
sorry recover database using backup controlfile; then i just use auto as all the archive logs are in place ive done this before numeros times... numerous alert logs gives no indication of error
so alertlog doesn't tell what needs to get recovered further?
it does. but its not part of my backup set. before i start backup i get the 'CURRENT' SEQUENCE# from v$log; i then backup all tablespaces chkeck for current once i backup all tablespaces, then i i copy over all arc logs where seq# >= 'VALUE';
(SELECT * from table1 group by col1 having count(*) = 1 How do I achieve this? selecting the rows which dont have duplicates according to col1 nvm
hi, how to create new empty table with identical structure as another table? create table X as select * from Y; will create not only table, but will put Y data into X, right?
Reign1: where 1=2;
hi folks - is there a way to see NLS_TIMESTAMP_FORMAT of all sessions currently connected?