Shulou(Shulou.com)06/01 Report--

Recently, a database is being migrated, using a full physical copy to the new environment, but the datafile directory needs to be changed. The previous environment preparation and physical copy went smoothly, but when the database was opened to read only mode, it was prompted that a standby log could not be read, so each redo log changed the storage location again.

Shut down the database and start the storage directory of shutdown immedaitestartup mount; change redo log file in mount state: alter database rename file 'old redo log file path' to 'new redo log file path'

There are 7 redo log files (plus 4 standby redo log), and only the fifth is unsuccessful.

ORA-01511: error in renaming log/data files ORA-01141: ORA-01110: ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory

After searching for information, you need to clear the standyb redo log file you are using. The command is as follows:

Alter database clear unarchived logfile group x

Then change the location of the redo file again.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.