Tag Info

New answers tagged

0

Yes, following the backup output: RMAN> list backup; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 10 Full 1010.57M DISK 00:00:48 02-APR-15 BP Key: 10 Status: AVAILABLE Compressed: NO Tag: ...


0

In order to do RMAN backups you need the SYSDBA or SYSOPER roles. In order to grant those you need to be able log on as a user with those roles: ie the SYS role. There are variations where you use OS authentication or if your OS user is a member of the ORA_DBA group. Easiest is if you can do this: CONNECT / AS SYSDBA from the server then you can run ...


0

From the very first lines in the Oracle Documentation about Flashback Database feature ( https://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta023.htm#RCMRF194 ): This command works by undoing changes made by Oracle Database to the data files that exist when you run the command. Flashback its mean to undo logical changes in the database. A ...


0

Try "List Backup", or perhaps "list backup summary" http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmreprt.htm#BRADV89586 and http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta027.htm#RCMRF132


2

Sounds like a data pump using a network link would do the job. It's always preferable to run it during quieter hours but if your source database is not under powered then you might be able to run it during regular hours without your user's noticing any difference in performance. From the article create a database link from the destination to the source ...



Top 50 recent answers are included