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