Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Archive log path

Johnny BJul 14 2010 — edited Jul 14 2010
Hi all,
I'm trying to automate a restore archive logs but I'm getting confuse with the path.
I set the archive log path in sql plus as C:\JFBBackup
SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            C:\JFBBackup
Oldest online log sequence     46
Next log sequence to archive   48
Current log sequence           48
It's creating a single file for each sequence.

Now in RMAN shows a different path as one file: C:\APP\ADMINISTRATOR\PRODUCT\11.1.0\DB_1\DATABASE\20LIO9RS_1_1
RMAN> list backup of archivelog all;

List of Backup Sets
===================
BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
60      98.72M     DISK        00:00:09     14-JUL-10
        BP Key: 60   Status: AVAILABLE  Compressed: NO  Tag: TAG20100714T061940
        Piece Name: C:\APP\ADMINISTRATOR\PRODUCT\11.1.0\DB_1\DATABASE\20LIO9RS_1_1

  List of Archived Logs in backup set 60
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    45      1577060    13-JUL-10 1611007    13-JUL-10
  1    46      1611007    13-JUL-10 1644153    14-JUL-10
  1    47      1644153    14-JUL-10 1649121    14-JUL-10
I'm using dbms_backup_restore.restoreBackupPiece but I need to have the log files alone in a separate folder so I can get the name of the file, create my sql file and restore in my REMOTE box.
I try to use the single file that it's create it on my C:\JFBbackup path but it's not working.
Any ideas?
Thanks

Johnny
This post has been answered by asifkabirdba on Jul 14 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 11 2010
Added on Jul 14 2010
19 comments
25,693 views