resetlogs without recover
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: resetlogs without recover

  1. #1
    Join Date
    Jan 2003
    Location
    Thailand
    Posts
    29

    resetlogs without recover

    How can I open database with resetlogs by don't take recovery database?

    My step:
    1. shutdown immediate;
    2. take full backup database.
    3. startup mount;
    4. alter database open resetlogs; << Error
    Regards,
    P.Peach

  2. #2
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    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

  3. #3
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    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 03:04 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width