-
standby database query
i received the following error when i tried to open the standby database in read mode after creating it.
alter database open read only
*
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'D:\STANDBY\ORADATA\ORACL\SYSTEM01.DBF'
I repeated the steps for creating standby database thrice but got the same error everytime.
Before opening the database in read mode, i also noticed that the redo logs
have not been archived at the location of standby database specified by
log_archive_dest_2='service=stby' on primary database and standy_archive_dest on standby database.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|