resetlogs without recover
How can I open database with resetlogs by don't take recovery database?
1. shutdown immediate;
2. take full backup database.
3. startup mount;
4. alter database open resetlogs; << Error
You can only use resetlogs with an incomplete recovery - after you mount the db issue recover database until cancel, then cancel the recovery straight away, then open resetlogs
Having said that - why do you want to resetlogs after taking a full backup? You should only be using resetlogs when you do an incomplete recovery or a recovery using a backup controlfile. If you are just shuting down the db to perform a cold backup then just start the database normally after the backup.
Last edited by fraze; 12-18-2003 at 04:04 AM.
Click Here to Expand Forum to Full Width