-
startup fine, but v$recover_file has entries
i did a backup/restore. startup no problems. however, in the course of my application, i get some database errors. therefore, i went to check. and to my surprise, i find entries in V$recover_file.
i recovered them, put them online and all is fine.
but i am puzzled why there are entries in v$recover_file and startup is no problem.
-
Hi,
what type of backup you had?between the file you recovered is that file locally managed?
-
i did a backup with my db shutdown and then restore.
-
Were those tablespaces OFFLINE when you shutted down your database before backup? Or have you maybe put some tablespace in OFFLINE mode after you restored and started your database? In both cases you shouldn't have any problems with starting the database and in both cases you would find entries in V$RECOVER_FILE.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
i am sure that the tablespaces are not offline when i start the backup because i did a 1) shutdown immediate; 2) backup oracle.
any reasons for them to be offline?
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
|