window bat scripts

cat standby_recovery.bat

@echo off

set ORACLE_SID=test

set ORACLE_HOME=D:\app\plmadmin\product\12.1.0\dbhome_1

D:\app\plmadmin\product\12.1.0\dbhome_1\BIN\sqlplus sys/sys@test01 as sysdba @D:\ORACLE_TEST_SERVER_BKP\con1.sql

#select name,open_mode,database_role,db_unique_name from v$database;

#alter database register logfile 'D:\63_archivelog\*.arc';

#alter database recover managed standby database disconnect from session;"

PAUSE

#exit

con1.sql

select name,open_mode,db_unique_name,database_role from v$database;

alter database recover managed standby database disconnect from session;

cat archivelog_movment.bat

@echo off

xcopy "\\10.33.105.63\DB_Shared\oradata\test01\ArchiveLog" "D:\63_archivelog" /Y

#PAUSE

exit

cat rman_movement.bat

@echo off

xcopy "\\10.10.10.10\DB_Shared\rmanbkp_SMRPRODB" "D:\rman_backup_smrprodb" /Y

#PAUSE

exit