Recently I encountered a very troublesome problem. I used the company software to view the backup data.
The Oracle version is 9204, and the corresponding backup version is available now. Use the company's products to open the backup data. because the entire database is around t, the company's products are very troublesome to work, we have been testing for a long time, and an engineer has been testing for a week last week, but the result is not open, when the product arrives, it will not respond.
Note that the SQL input is as follows:
SQL> startup mount pfile = dbname. ora
SQL> recover database cancel using backup controlfile
SQL> enter the rollback log
SQL> cancel
SQL> alter databse open resetlogs
Because the database is too large to generate a large log file, it takes about 50 minutes to perform a "input rollback log" rollback. if we already know that a version can be opened by rolling back to a log, We can enter cancel and then "alter database open resetlogs. however, the problem is confusing to us.
[Content navigation] |
Page 1st: Pay attention to your input when using Oracle SQL |
Page 2nd: Pay attention to your input when using Oracle SQL |